Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

QUESTION 17 Consider the following LegoMaster scenario for questions 15 to 17. L

ID: 3733567 • Letter: Q

Question

QUESTION 17 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 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 BlockID Size Shape Colour DesignlD DName Client ID 1.n

Explanation / Answer

Solution:

5 is the correct option.

Explanation:

The given ER diagram will be mapped to a relational model where 5 tables are there in which the tables are

Block

Design

Series

Client

Owns

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

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote