Figure 4-38 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.

Transcribed Image Text:

AUTHOR AuthorlD Auth Name (Auth Last Name Auth First Name, Auth Middle Initial) Auth Phone Auth Emai Auth Expertisel EDITOR Editor ID Editor LName Editor FName Editor Institution AUTHOR ASSIGNM Author Position Author Type (Is Lead Author?, Is Contact Author?) BOOK Chapter ID Chapter Number Chaptor Title Includes Book Nbr Book ISBN Book Title Book Price ORDER LINE Orderline Nbr OL Price OL Discount OL Quantity ORDER WHOLESALER Order 10 Order Date Order Dofivery Da Cust ID Places Cust Name