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 BlockID Size Shape Colour DesignlD Client ID 1n Have 1.n First Name 1..n Last Name email [1..n O..n Series SName number of designs in O.n senes Likes status [current, sold out, future release] Some of the designs are generated by independent authors (Indie Designs), and instructions can be purchased by clients independently of blocks. They also wish to display a link to a vendor for the boxed set designs for purchase if the clients wish. The following entity types are proposed to alter the previous ERD: Design Indie Design Box Set What would be the attributes of each entity type? Design: Indie Design:I Box set: Options to choose from: DesignD, DName, Price, Link. IndieDesignD, IndieDesignName, BoxSetID and BoxSetNamel What will be the Participation Constraint? I believe answer is Indie Design What will be the Disjoint constraint? The author relationship type will be connected to which of the entity types?1 I believe Answer is Design I believe answer is Box Set Options to choose from: Design, Indie Design, AND, IF/THEN, OR, Design ID, LIKE, Mandatory, Box Set and Price.

Explanation / Answer

Design

DesignID - varchar2(10)
Dname - varchar2(20)

Indie Design

IndieDesignID - varchar2(10)
IndieDesignName - varchar2(20)
Price - int

Box Set

BoxSetID - varchar2(10)
BoxSetName - varchar2(20)
Price - int

Participation Constraint - Mandatory
Disjoint Constraint - Design
The author relationship type will be connected to which of the entity type - Mandatory for the box set.

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

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