Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 model the above data requirements.

In the ERD, which of the following correctly describe(s) the modeling of components? 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) A binary relationship should be used to model the making of component(s).

B) The number of component(s) used to make a component is an attribute in the relationship type in the modeling.

C) Two entity types should be used to represent component(s) and its own component(s) separately.

D) A unary relationship should be used to model the making of component(s).

E)The cardinality near to the "component" side should be mandatory many.

F) A ternary relationship should be used to model the making of component(s).

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entity Alignment Concepts Recent Advances And Novel Approaches

Authors: Xiang Zhao ,Weixin Zeng ,Jiuyang Tang

1st Edition

9819942527, 978-9819942527

More Books

Students also viewed these Databases questions