Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The ERD listed below depicts a book store. An ORDER can have many books on it and a book can be on many ORDERs. Additionally
The ERD listed below depicts a book store. An ORDER can have many books on it and a book can be on many ORDERs. Additionally there can be many Authors per book and an Author can write many books. How would you revise this draft?
tableORDEROrderID: VARCHAR PKOrderDate: VARCHARCustomerID: VARCHAREmployeeid: VARCHAR
tableBOOKBookID: VARCHAR PK Title: VARCHARAuthorID: VARCHARCopyrightDate: VARCHARISBN: VARCHAR
Take the OrderID in ORDER and place it in BOOK. Create an entity for AUTHOR and place BookID in AUTHOR as a foreign key.
Nothing needs to be done. This is perfect.
Take the BookID in BOOK and place it in ORDER. Create an entity for AUTHOR.
Create a linking table between ORDER and BOOK. Additionally create an entity for AUTHOR and linking table between AUTHOR and BOOK.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started