Question: You have been nominated as a database designer for ABC online Laptop management system. It maintains complete up-to-date information on sales and services of various
You have been nominated as a database designer for ABC online Laptop management system. It maintains complete up-to-date information on sales and services of various laptop brands. The laptops can be portrayed by laptop ID, brand, price, and configuration details. The components of the laptops can be portrayed by component ID, name, type and the description. The sales information can be portrayed by sales ID, price, type and description. The service information can be portrayed by service ID, type, price and description. The customer information can be portrayed by customer ID, name, address, contact no and email ID. Construct an Entity Relationship diagram to illustrate the above scenario. Identify the necessary relationships, cardinality constraints and min- max constraints in the design. Document all assumptions that you make about the mapping constraints (cardinality ratios)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
