My project will be about an online retail store. I will have the following 3 tables with the following fields in them:
1. Orders - items that were sold and order number will be the entity
Fields: Selling Date, Selling Time, How Much Sold For, How Much Bought for, Customer ID, Manufacturer ID
2. Customer Information - Customer ID will be entity
Fields: Last Name, First Name, Street Address, Apartment #, City, State, Zip-code, Phone Number, Email address
3. Manufacturer Information: Manufacturer ID will be the entity
Fields: Business Name, Location, Phone Number, Email Address
I will link Customer Information table with Orders table with the Customer ID.
I will link Manufacturer Information Table with Orders table with the Manufacturer ID.