Need help to get the answers of these two question shown in picture. I found ans

Question

Need help to get the answers of these two question shown in picture. I found answer of these two questions on chegg but both says different answers. One says yes and other says. Please i need final right answer.

PRODUCT Prod Title Prod_ReleaseDate Prod_Price Prod _Type d Prod_Type BOOK CD MOVIE PK,FK1 Prod Num PK,FK1 Prod Num PK,FK1 Prod Num Book CoverType Book PageCount CD Genre CD Artist Movie Rating Movie_Director (8.) According to the data model, is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why or why not? 3. 4. (9.) Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why or why not?

Explanation / Answer

Question 3 :

Its not needed that every instance in the Product table to be associated with an instance in the CD table because the product can be either of the three types or it can be neither.

product table holds only the basic details of product but not the type of it and it can of any type.

Question 4:

Its not possible for a BOOK instance to appear in book table without an instance in Product table because there is a foregin key constraint applied on the prod_num attribute of the book table with relation to the same key in the product table where it is the primary key.

In order to define a prod_num in book table ,firstly a record with that particular prod_num as primary key should be defined in the product table which is identified by book table when creating a record for the same product number without violating foreign key constraint.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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