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 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.

Answer

Solutions

Expert Solution

Class diagram for groceries management database with the relationship among the classes and its multiplicities.

venereology answered 6 months ago

Next > < Previous

Related Solutions

Understanding how the American university culture affects students requires analyzing the cultural norms that students bring...

Understanding how the American university culture affects students requires analyzing the cultural norms that students bring to college and how these norms interact with the norms institutionalized in university settings. Cultural models of self—implicit understandings of oneself in relation to others and the social context—are one important source of these individual and institutional norms (Cross & Madson, 1997; Markus & Kitayama, 2010). Research conducted in a variety of cultural contexts has identified two common models of self that provide culture-specific...

Students performed a procedure similar to Part III of this experiment (Analyzing a Vitamin Supplement for...

Students performed a procedure similar to Part III of this experiment (Analyzing a Vitamin Supplement for Vitamin C Content) as described in the procedure section. A 1.044 g vitamin C tablet is crushed, treated, and diluted to 100.00 mL in a volumetric flask with deionized water. Three 5.00 mL samples of this solution are titrated with DCP that had a standardized concentration of 9.92x10-4 M. The three titrations took an average of 42.87 mL of DCP. (MM Ascorbic Acid =...

Next, answer the following questions regarding the dataset you are analyzing (Exam Anxiety in Students) How...

Next, answer the following questions regarding the dataset you are analyzing (Exam Anxiety in Students) How did you treat missing or oddly coded data and outliers? What did you visually observe about your variables? What were the results of testing for normality for scale variables? What is the difference in the graphs for scale and non-scale variables? How would you summarize the descriptive statistics for each variable? How would you state a potential null and alternative hypotheses that might be...

The next two questions are part of the same scenario. You will use VLSM to design...

The next two questions are part of the same scenario. You will use VLSM to design an addressing scheme for a client who has the 185.33.64.0 /24 address block. (a) The largest host requirement is for LAN A, which requires 100 hosts. What would be the subnet address and prefix length for this subnet?

Read and analyze the scenario below. Using Microsoft Word, answer the questions posed. You must use...

Read and analyze the scenario below. Using Microsoft Word, answer the questions posed. You must use the law you learned to support your answers. Your assignment should be a minimum of 1 full page and follow these guidelines: 12-point Times font One inch margins Double-spaced Correct spelling, grammar and sentence structure. The Great Minneapolis Surplus Store published the following advertisement in a Minneapolis newspaper: Saturday 9 a.m. 2 Brand New Pastel Mink 3-Skin Scarfs selling for $89.50 now selling for...

Part 1: Please read the following scenarios. For each scenario, answer the following questions: a) what...

Part 1: Please read the following scenarios. For each scenario, answer the following questions: a) what is the independent variable, b) what is the dependent variable, and c) is this a between-subjects or within-subjects design? A child psychologist wants to determine the effects of cloth versus paper diapers on toilet training. Day-old infants will be used to begin the project. The age at which diapers are no longer needed (to the nearest week) will be determined. A researcher wants to...

Scenario 1: A college wants to determine if students prefer face-to-face or online classes. 100 students are selected at random and given a survey.

1. Please define population and sample in your own word. 2. Please indicate the population and sample of each of the scenarios below. Scenario 1: A college wants to determine if students prefer face-to-face or online classes. 100 students are selected at random and given a survey. Scenario 2: A restaurant wants to determine customer satisfaction. They place cards on the tables and 55 surveys are returned. Scenario 3: CNN wants to predict the outcome of an election. They poll...

subject: International business Q. No. 3 Analyze the following situation and answer the questions given below...

subject: International business Q. No. 3 Analyze the following situation and answer the questions given below Max Marks 10 Should We Allow Global Corporation to Set Up a Factory in our Country? About the business. Global Corporation is applying for planning permission to build a factory in your country. The factory is expected to be very profitable. 1000 new jobs should be created for assembly-line work. Many of the goods made could be sold abroad. Some of the supplies for the...

Case Study Analysis Read carefully the following case/scenario and answer the questions given at the end....

Case Study Analysis Read carefully the following case/scenario and answer the questions given at the end. A manufacturing company, involved in the business of food processing, faces a technical problem at one of their major plants. Recently they faced a technical issue which resulted in loss of production and was fixed by engaging their mechanical staff. Now this technical problem can result in even bigger loss of production and if it gains attention of public through social or electronic media,...

I have a three part questions for grade 7 students: 1. Explain briefly the meaning of...

I have a three part questions for grade 7 students: 1. Explain briefly the meaning of energy crisis 2. What are the consequences of using fossil fuels excessively for all of our daily activities? 3. What alternatives can be exploited to avoid over reliance on fossil fuels? What answers and explanation i can give to grade 7 students?

Subjects