Question

Problem 2 (Continuation) b) Consider the following E-R diagram Parts pld pName NpPrice Assembles Supplies Supplier sld sName sPhone Which of the following statements can be inferred from the diagram? Every supplier must supply a part. Some parts are used to assemble other parts. I. III. Every part must be supplied by some supplier IV. Both 11 and 111 V. All of the above VI. None of the above Answer: c) (5pts) Let Ei and E2 be two entities. Let R be a many-to-many relationship between Ei and E2. If l E1 l Xand | E2l Y, then the maximum cardinality for R will be I. Max {X,Y IV. , since we can have as many pairs of elements from E1 and E2 as we want. V. None of the above Answer:

Answer 1

Answer b: Option 5 ( All of the above )

There is many to many relation between Supplier and Parts i.e; each supplier must supply a part.

There is many to many relation ( Assembles ) between in enitity Parts i.e; some parts are used to assemble another parts.

There is many to many relation between Supplier and Parts, and it works in practical life as well because whatever we purchase it is supplied by any supplier i.e; each part must be supplied by some supplier.

-----------------------------------------------------------------------------------------------------------------------------

Answer c: Option 3 ( X*Y )

Many to many relation means N object of one entity is related by M objects of another entity. So if R is a many to many relation between E1 and E2 i.e | R | = | E1 | * | E2 | = X * Y