Student ID: Student Name: Date:.

Student ID:
Student Name:
Date:

Report
ER Diagram

Relational Tables in Third Normal Form
Customers (FlcustomerID, FlCustomerName, Fladdress, Flphone, Flemail)
Primary Key FlCustomerID
Items (FlitemNumber, Flweight, Fldimensions, FlinsuranceAmount, Fldestination,
FlfinalDeliveryDate, Flinstructions)
Primary Key FlitemNumber
RetailCentres (FlretailCentreID, Fltype, Fladdress)
Primary Key FlretailCentreID
Employees (FlemployeeID, FlemployeeName, Fladdress, Flphone, Flemail, FlretailCentreID)
Primary Key FlemployeeID
FlretailCentreID references retailCentres (FlretailCentreID)
Receipts (FlitemNumber, FlreceivedDate, Flcharges, FlretailCentreID, FlemployeeID)
Primary Key FlitemNumber
FlretailCentreID references retail_Centre (FlretailCentreID)
FlemployeeID references Employees (FlemployeeID)
FlitemNumber references Items (FlitemNumber)
Transportation (FlscheduleNumber, FlcustomerID, Fltype, FldeliveryRoute, FlitemNumber)
Primary Key FlscheduleNumber
FlcustomerID references Customers (FlcustomerID)
FlitemNumber references Items (FlitemNumber)