Question

analyze the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams...

analyze the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams studied in chapters 8, 10 and 12 of IT242.

The management of the groceries ordering system would desire to have a database system to keep track of orders, customers, drivers and stores. Read the following paragraph to answer the given questions.

The system maintains four users' information. For each user, the system keeps a unique ID, name, login, password, address, contact number, category (Grocery Owner, admin, customer and driver) and status (approved by admin or not). Each Grocery Owner has an address and name of the store. He can view one or more order also it can manage one or more product. Each order has an order ID, amount to pay, status and rate service. An order can be managed by one grocery owner and one admin. A single order is associated with one or more product. The product details to be stored are reference, quantity and price. A product can be processed by one grocery owner. Each driver can view and change the status of one or more order. An order can be assigned to one driver only. Each customer can make one or more order and fill zero or more complaints. Each complaint has a complaint ID, title, body and date. A complaint can be handled by one admin. Each admin can approve registration of store owners, drivers, and customers. He can view reports about the service ratings.

3.1 Draw a Class diagram for the given database. The diagram must show all classes, relationships between classes, and multiplicities

0 0
Add a comment Improve this question Transcribed image text
Answer #1

DIAGRAM:-

HERE,

NOTE: I TRIED TO IMPLEMENT THE REQUESTED PROBLEM AS PER BEST OF MY UNDERSTANDING....IF YOU NEED ANY SORT OF HELP REGARDING THIS PROBLEM , PLEASE DO MENTION IN COMMENTS.....IF YOU GOT ANY SORT OF HELP THROUGH THIS ARTICLE PLEASE DO UPVOTE.....THANKYOU!!!

Add a comment
Know the answer?
Add Answer to:
analyze the students’ understanding in analyzing the given scenario and practical skills to build Class diagrams...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The case study is about the analysis of the students’ understanding in analyzing a given scenario...

    The case study is about the analysis of the students’ understanding in analyzing a given scenario and practical skills to apply concepts and build diagrams studied in IT242 (Software Engineering). The case study consists of five parts. Students are required to answer all these parts based on the below scenario. The SEU has adopted a blending approach to electronic learning, requiring learners to attend class lectures (25%), while 75% of course time is assigned to virtual classes, learning forums and...

  • Questions of this part analyze the students’ understanding in analyzing the given scenario and practical skills...

    Questions of this part analyze the students’ understanding in analyzing the given scenario and practical skills to build State diagrams studied in Chapter 12 under the Design Model. 1- The SES system will be in the Locked stateone week before thesemester begins (Week 0). In the locked state, the system is open only for Admins to add courses. In the first two weeks (Week 1 and Week 2), the system is in Registration state, in which the students register their...

  • Programming Assignment 5: UML Diagram Objectives: After successfully completing this assignment, students will practice Object Oriented...

    Programming Assignment 5: UML Diagram Objectives: After successfully completing this assignment, students will practice Object Oriented design by creating an UML diagram for a Java program. Program Statement: Bank System You were asked to create a simple UML diagram for a bank system. Each bank has a specific identification number, a name, and a location that needs to be stored. Tellers serve customers’ loans, checking and savings accounts. The bank must know each tellers’ name and identification number for record...

  •    Prepare a design class diagram. A retail store wants to build an online system for...

       Prepare a design class diagram. A retail store wants to build an online system for their customer to place orders online and for pickup later from the store. Customers join the system by registering online (username (email), password, address, phone no) and including a credit card for use in online ordering; at that time they use login credentials (uername and password) to enter the online system. Customers who have joined the system can use the online system to search...

  • This is extra information about the shopping database given to answer this question: For many query...

    This is extra information about the shopping database given to answer this question: For many query questions we refer to the following database schema for a website that keeps track of what people like to buy or actually buy in different on-line supermarkets. (Think of something like a cross-store loyalty card system.) customer(cID, cName, street, city) Customers with unique cID and other attributes store(sID, sName, street, city) Stores with a unique ID and other attributes. Stores with the same name...

  • A database used for a toy store that keeps track of the inventory and purchase orders...

    A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...

  • A database used for a toy store that keeps track of the inventory and purchase orders...

    A database used for a toy store that keeps track of the inventory and purchase orders from the store. All clients will have their membership ID card to shop. This database will help the store to keep track of their orders. It will also help the store to know how many products are available in the inventory. It is necessary to have a membership to purchase a product. The customer can also bring coupons to get discount. Key attributes: Salesman:...

  • Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small...

    Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small database to store information about the online orders. You’re given the following requirements: ⚫ A customer is uniquely identified by his/her email. For each customer, we also record his/her name, phone number and address. The address is composed of suburb and street. ⚫ A rider is uniquely identified by his/her ID. We will keep record of the rider’s age, gender, phone number and available...

  • Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...

    Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...

  • Study case 1: National Best Health Food Store National Best Health Food Store (NHFS) is a...

    Study case 1: National Best Health Food Store National Best Health Food Store (NHFS) is a chain of health food stores serving in three major well- known (NSW, Queensland and Victoria). Open in 1965 with selling on ly herbal items like coffees, teas and house hold products, since the expansion of business in 1990, it has increase the range of product line including personal care, pert care and grocery items. Currently it has fifteen stores in three states. Due these...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT