Translate the ER diagram to relational database design. New, foreign keys might be introduced during the translation. Highlight the new foreign keys created.  Explain in what normal form the database design is. 

Transcribed Image Text:

Book Author Bio ISBN (Foreign key) AuthorID (Foreign key) Author AuthorID Name Contact information Online Book Store Matt Bennett | March 26, 2023 ISBN Title Book Publisher Publication date Price Quantity in stock Order Item OrderID (Foreign key) ISBN (Foreign key) Quantity Shipment ShipmentID OrderID (Foreign key) Shipping carrier Tracking number Delivery date CustomerID Customer Name Email Address Phone number Payment information OrderID Date Order CustomerID (Foreign key) Shipping address Payment amount Book Author Bio ISBN (Foreign key) AuthorID (Foreign key) Author AuthorID Name Contact information Online Book Store Matt Bennett | March 26, 2023 ISBN Title Book Publisher Publication date Price Quantity in stock Order Item OrderID (Foreign key) ISBN (Foreign key) Quantity Shipment ShipmentID OrderID (Foreign key) Shipping carrier Tracking number Delivery date CustomerID Customer Name Email Address Phone number Payment information OrderID Date Order CustomerID (Foreign key) Shipping address Payment amount

Answer rating: 100% (QA)

Relational Database PatientPatientID Demographics Allergies InsuranceInformation MedicalHistory Insu... View the full answer