Datasheet

Designing Applications
25
A more detailed analysis has revealed the attributes of the five entities that we need to record
and our preliminary entity relationship diagram (ERD, or more simply, database design) looks
like this:
tblCustomer
CustomerID
CompanyName
Address
City
State
ZipCode
Country
Phone
Fax
Email
Web
ContactName
tblSupplier
SupplierID
CompanyName
Address
City
State
ZipCode
Country
Phone
Fax
Email
Web
ContactName
tblIceCream
IceCreamID
IceCream
Description
Price
Picture
tblSales
SalesID
fkCustomerID
fkIceCreamID
Quantity
DateOrdered
DateDispatched
DatePaid
AmountPaid
ContactName
tblIngredient
IngredientID
Name
Description
Unit
UnitsInStock
ReOrderPoint
tblSupplierList
fkSupplierID
fkIngredientID
PricePerUnit
LeadTime
tblIceCreamIngredient
fkIngredientID
fkIceCreamID
Quantity
1
1
1
1
As you can see from the database diagram above, five tables have been created to represent the
five basic entities identified in the data analysis:
tblSupplier
represents
the Suppliers entity
tblCustomer
represents
the Customers entity
tblIceCream
represents
the Ice Creams entity
tblIngredient
represents
the Ingredients entity
tblSales
represents
the Sales entity