View the step-by-step solution to:

Please can you look at the attachment to see if I am on the right track and make any adjustments as necessary. You are working on the database design...

Please can you look at the attachment to see if I am on the right track and make any adjustments as necessary.


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.

Create a UML class diagram that models the data for this situation.
To create the class diagram, do the following 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.
Now click here to download the Violet UML diagram editor. Start Violet and use it to redraw your class diagram.

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.
Represent relationships between entities by adding associations between the class boxes.

Background image of page 1
Sign up to view the entire interaction

Top Answer

Dear , Please respond i have check everything is covered in... View the full answer

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online