Database Project
Database Project
Draw an entity-relationship diagram for a small retail store. You wish to keep track of the product name, description, unit price, and number of items of that product sold to each customer. You also wish to record customer name, mailin" rel="nofollow">ing address, and billin" rel="nofollow">ing address. You must track each transaction (sale), date, product purchased, unit price, number of units, tax, and total amount of the sale
Be sure to in" rel="nofollow">include the followin" rel="nofollow">ing:
Identify your entities (# of tables)
Identify your Primary Key
Entity-Relationship diagram for the retail store
Explain" rel="nofollow">in Database Normalization