Question: General Computer Accessory Company : In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at
General Computer Accessory Company: In General Computer Accessory Company (GCAC), each product (described by product number (primary key (PK)), description, and cost) comprises at least one component and can comprise many components (described by component number (PK), description, and unit of measure), and each component is used to make zero to many products. GCAC keeps track of the quantities of products and components in the manufacturing process. In addition, a component can be used to make zero to many other components and a component can consist of zero to many other components. GCAC also keeps track of how many components go into making some other components.
Draw an ER diagram using LucidCharts.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
