Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Customer: - Customer_ID - Customer_Name - Customer_Address - Customer_Zip - Customer_Phone_Number - Customer_Email 2. Product: - Product_ID - Product_Name - Product_Category - Product_Price 3.


1. Customer: - Customer_ID - Customer_Name - Customer_Address - Customer_Zip - Customer_Phone_Number - Customer_Email

2. Product: - Product_ID - Product_Name - Product_Category - Product_Price

3. Order: - Order_ID - Customer_ID - Order_Date - Shipping_Date - Delivery_Date

4. Warehouse: - Warehouse_ID - Warehouse_Name - Warehouse_Location - Warehouse_Zip - Warehouse_Capacity

5. Employee: - Emp_Last_Name - Emp_First_Name - Emp_Street_Addr - Emp_Street_Name - Emp_City - Emp_State - Emp_Zip - Emp_Job_Code - Emp_PayRate - Emp_Start_Date - Emp_Warehouse_ID

6. Payment: - Payment_ID - Customer_ID - Payment_Amount - Payment_Date

7. Returns: - Returns_ID - Customer_ID - Product_ID - Return_Date

8. Inventory: - Inventory_ID - Product_ID - Warehouse_ID - Quantity


-a UML class diagram should be made. (Note: Every entity corresponds to a single class.) -Determine the connections between the classes. -Choose the appropriate notation to indicate the cardinalities of each relationship in the diagram, indicating whether the link is one to one, one to many, or many to many.

-Determine the relationship's modality in the diagram using the appropriate notation, indicating whether it is a necessary relationship that always occurs between the two entities or an optional relationship that only exists under certain circumstances.

-Justify the rationale behind each relationship's modality. a rundown of your reasoning for choosing each relationship's cardinality and modality.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of College Algebra

Authors: Margaret Lial, John Hornsby, David Schneider, Callie Daniels

12th Edition

0134697022, 978-0134697024

More Books

Students also viewed these Databases questions

Question

Repeat Exercise using the followingtable: 28 18

Answered: 1 week ago

Question

Solve each equation or inequality. |85x|2

Answered: 1 week ago

Question

Solve each equation. Vx+7+3= x-4

Answered: 1 week ago

Question

Graph each function. f(x) = [x + 3 -x+4 if x Answered: 1 week ago

Answered: 1 week ago