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

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 General Management Questions!