Question: Please create an entity-relationship model (ERM) and diagram (ERD) for a database Apple inc based on the following description of the company: Apple Inc. builds
Please create an entity-relationship model (ERM) and diagram (ERD) for a database Apple inc based on the following description of the company:
Apple Inc. builds multiple types of laptops: macbook pro and macbook air. Each type has a mac ID number, serial code, and year of manufacturing.
The key specifications for each type include storage space, display type and cpu speed.
Every laptop has a warranty policy.
for each warranty policy we want to record its unique policy ID.
The company uses different processor chip types depending on the year of development, exactly one of which is used for one specific laptop type; the same processor chip can be used in multiple types of Laptops.
Each chip has a manufacturer name and a manufacturers unique code. The unique code identifies each chip.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
