Figure 4-37 includes an EER diagram describing a publisher specializing in large edited works. 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 AuthorID Auth Name (Auth Last Name, Auth First Name, Auth Middle Initial) Auth Phone EDITOR Editor ID Editor LName Auth Email Editor FName {Auth Expertise) Editor Institution AUTHOR ASSIGNMENT Author Position Author Type (Is Lead Author?, Is Contact Author?) CHAPTER BOOK Chapter ID Includes %23 Chapter Number Chapter Title Book Nbr Book ISBN Book Title to Book Price ORDER LINE ORDER WHOLESALER Orderline Nbr OL Price OL Discount OL Quantity Order ID Cust ID Order Date Cust Name Places Order Delivery Date Has volumes Edits Editor Order