Consider the following LegoMaster scenario for questions 15 to 17 LegoMaster is

Question

Consider the following LegoMaster scenario for questions 15 to 17 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 bult. 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 Cient ID DesigniD DName Shape First Name Colour Last Narme Series number of designs in On status [current, sold If a relational model was constructed from the ERD above, which of the following attributes would be in the relation Design? Number of Boxes BlockiD ClientID DesignlD SName

Explanation / Answer

Solution:

The first question is done as per Chegg guidelines, please repost others.

15)

DesignID

Explanation:

Because in the newly created relation for the Design table then DesignID must be there in the relationship because it is the primary key of the deisgn table and it will act as a foreign key in the relation.

The options for the other two are not given, if they were I would have answered them as well. Please provide them in the comments.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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