Home‎ > ‎B188 6pm‎ > ‎Kaur, Ramanprit‎ > ‎

Acess Project

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.


Comments