PRODUCT PK Prod Num Prod_Title Prod ReleaseDate Prod Price Prod Type Piee Typn BOOK CD MOVIE PK,FK1 Prod Num PK,FK1 Prod Num PK,FK1 Prod Num Book CoverType Book PageCount CO_Genre CO Artist Movie Rating Movie Director

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter11: User Interfaces, Visual Basic For Applications (vba), And Collaboration Features
Section: Chapter Questions
Problem 12AYK
icon
Related questions
Question

According to the data model, is it required that table every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why, or why not?

PRODUCT
PK Prod Num
Prod_Title
Prod ReleaseDate
Prod Price
Prod Type
Piee Typn
BOOK
CD
MOVIE
PK,FK1 Prod Num
PK,FK1 Prod Num
PK,FK1 Prod Num
Book CoverType
Book PageCount
CO_Genre
CO Artist
Movie Rating
Movie Director
Transcribed Image Text:PRODUCT PK Prod Num Prod_Title Prod ReleaseDate Prod Price Prod Type Piee Typn BOOK CD MOVIE PK,FK1 Prod Num PK,FK1 Prod Num PK,FK1 Prod Num Book CoverType Book PageCount CO_Genre CO Artist Movie Rating Movie Director
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L