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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started