Identify the modality of the relationship

Assignment Help Database Management System

Reference no: EM13700789

Data Model

Question: You are working on the database design that will support PPI's new order entry system. PPI has many thousands of customers around the world who place and pay for orders. One customer can place an order for many products at a time.

Many different customers may order any particular product. Workers at the warehouse keep track of orders while they fulfill and ship them.

Customer service representatives should be able to review all of a customer's orders, whether they are being filled, in transit, or historical.

To simplify this analysis, assume that PPI has only one warehouse, that merchandise is always in stock, that every order ships in a single package, and that customers never cancel orders or return products. PPI uses different systems to process customer payments and to manage its inventory.

Prepare a UML class diagram that models the data for this situation.

- To create the class diagram, do the subsequent with pencil and paper:

- Identify up to 10 classes. Justify your choices.

- Identify what relationships exist between classes. Elaborate on the nature of each relationship that you identified.

- Identify the cardinalities of each relationship-whether the relationship is one to one, one to many, or many to many. Explain your reasoning.

- Identify the modality of the relationship-whether the relationship always exists between the two entities or is optional, existing only in specific conditions.

Justify your thinking behind the modality of each relationship.

- Create a new class diagram by choosing the File > New > Class Diagram command.

- Add a class box to the class diagram for each class you identified.

- Add between 2 and 6 relevant attributes to each class box. These should describe the information most important to the order entry and fulfillment process.

Show relationships between entities by adding associations between the class boxes.

Reference no: EM13700789

Questions Cloud

Prepare demo program that implements all of above method : Specify, design, and implement a class that can be used in a program that simulates a combination lock.

What volume of hcl is required to react with zinc : Question- What volume (in mL) of 2.44 M HCl is required to react with 3.78 g of zinc according to the following reaction

Two phase routing algorithm : Two Phase Routing Algorithm: use the analysis of the first phase to give a full analysis (no "symmetry" argument) of the second phase.

What is the ph for the reaction : Question- When 0.298 moles of B completely reacts according to the reaction above, 49.9 kJ of energy is released. What is the pH for the reaction as written above

Identify the modality of the relationship : You are working on the database design that will support PPI's new order entry system. PPI has many thousands of customers around the world who place and pay for orders. One customer can place an order for many products at a time.

Describe the long-term impact new business architecture : You have been asked by the CEO to describe the long-term impact new business architecture for your POS system will have on the organization.

The turbulence reynold number of a stoichometric : Question- The turbulence Reynold number of a stoichometric n-hexane/air mixture, whose mixing time os 50 microseconds and whose large eddies have a mean size of 1 mm, exceeds 10^4 at 1000 K.

Calculate the number of grams of carbon required to react : Question- Calculate the number of grams of carbon required to react completely with 5.5 grams of iron(lll) oxide according to

Write a switch-case statement : Create a script named 'descent.m'. Give a brief but concrete example when switch?case statements should be preferred to if? elseif statements. Use block comments to enter your answer in the script.

User Account

All Pages