Entity-Relationship Model

Use draw.io to draw an entity-relationship diagram (ERD) for the JustLee Book database (reference the structure of the database in Figure 1-5 in the Ppt presentation above. The same figure can also be found in the textbook on p.11).

Draw a fully-labeled ERD that includes entities, labeled relationships (indicate whether each relationship is mandatory or optional), primary keys, foreign keys, and cardinalities. Follow the format (Crow's Foot notation) and naming conventions used in class.

 

Reference attached below:

 

CUSTOMERS Customer# Lastname ORDERS Order# Customer# Orderdate Shipdate Shipstreet Firstname Email Shipcity Address Shipstate City Shipzip State BOOKAUTHOR AUTHOR Shipcost BOOKS Zip ISBN AuthoriD Referred ISBN Region ORDERITEMS AuthorID Lname Title Fname Ordere Pubdate Item# PubID Cost ISBN Retail Quantity Discount Paideach PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretail Maxretail FIGURE 1-5 JustLee Books's table structures after normalization