For each of the two ER Diagrams, map the ER diagram into a relational schema. PK is underlined or each entity.

Wilmington University Database Design Project

Instructions:

For each of the two ER Diagrams, map the ER diagram into a relational schema. PK is underlined or each entity. Clearly indicate all foreign keys and including whether NULLs allowed or not allowed in the FKs.

(A) Products Contain Orders ProductID Description Qty Price OrderNumber OrderDate Place Customers Reps RepID FirstName LastName Phone Email CustomerID FirstName LastName Street City State Zip Takes d Mentor Wholesale Retail TaxIDNumber TaxRate

(B) Hint: For the ‘Publishes_with’ relationship, refer to the examples on mapping many-to many unary relationship. Also note that PubCount is an attribute of the relationship ‘Publishes_with’. with Faculty FacID FacName d Full Time Degree Title Part Time Cell Phone Assigned-to Office OfficeNo Office Add Office Phone Teach Supervise Course Sem Course# Section# CourseName