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. GCAC wants to develop an entity relationship diagram (ERD) to describe the above data requirements.
In the ERD, which of the following correctly describe(s) the relationship between product and component? Select all that apply (note: partial (positive or negative) credits are assigned to partially correct or incorrect answers respectively; minimum score of the question is zero).
A) The relationship is ternary.
B) The quantities of products and components should be modeled as an entity type.
C) The relationship is binary.
D) The cardinality symbol near to the "component" side is optional many.
E) The cardinality symbol near to the "product" side is optional many.
F)An associative entity type can be used to model the relationship.
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