LegoMaster is an online service that provides its clients with information about

Question

LegoMaster is an online service that provides its clients with information about which blocks are needed/provided in each of the set boxes (designs) ever sold, as well as new designs that can be built. Clients can register which boxes they own, so that the service can suggest all the possible designs that they can build with their collection. The ERD blow models the information they need to store. Number of boxes Block Design Client 1.n o.n BlockID Client ID Owns DName CName Shape Colour First Name 1n Last Name email [1 O.n 01 Series SName number of designs in o series cLikes status (current, sold out, future release]

Explanation / Answer

What will be the participation constraint?

ANS: Inde Design , às Design : 0.,* Inde Design related to zero or more object of the Desig

What will be the disjoint constraint ?

ANS: Design, as Either a Design can be a Inde design or a box set but not both.

The author relationship type will be connected to which of the entity types?

ANS: Design , as Design the generalized entity of the inde design entity.

I have answered your question. Please do not forget to give a positive feedback to the answer. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.