Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!