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 BlockID Size Shape Colour DesignID ownsCName Client ID 1n Have 1.n DName First Name Last Name email [1..n O..n Series SName number of designs in O.n senes Likes status [current, sold out, future release] If a relational model was constructed from the ERD above, which of the following would be attributes in the relation Series? SName number of designs in series ClientID Design|D Status I believe this is true Ibelieve this is true I believe this is true

Explanation / Answer

SOLUTION:-

ANS-1:- Participation constraints are set boxes because they are the main part of the client legomaster.

ANS-2:- Indie block designs are disjoint constraints since they are designed by independent authors.

ANS-3:- The author relationship type will be connected to Box Set, as the instructions to deisgn blocks(Boxes) are given by author.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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