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.