Database Fundamentals.

Student ID:
Student Name:

Report
Introduction
The report is showing the database design and development of International Parcel Service (IPS)
system. First the database design is developed and after that the database is implemented in MS
Access. All tables, queries and report are developed in MS Access. MS Access database
management system is very effective and appropriate for the International Parcel Service (IPS)
system because all required features are available in it.
ER Diagram

Third Normal Form Relations
TCustomer (FcustomerID, FCustomerName, Faddress, Fphone, Femail)
Primary Key FCustomerID
TItem (FitemNumber, Fweight, Fdimensions, FinsuranceAmount, Fdestination,
FfinalDeliveryDate, Finstructions)
Primary Key FitemNumber
TRetailCentre (FretailCentreID, Ftype, Faddress)
Primary Key FretailCentreID
TEmployee (FemployeeID, FemployeeName, Faddress, Fphone, Femail, FretailCentreID)
Primary Key FemployeeID
FretailCentreID references TretailCentre (FretailCentreID)
TReceipt (FitemNumber, FreceivedDate, Fcharges, FretailCentreID, FemployeeID)
Primary Key FitemNumber
FretailCentreID references TretailCentre (FretailCentreID)
FemployeeID references TEmployee (FemployeeID)
FitemNumber references TItem (FitemNumber)
TTransportation (FscheduleNumber, FcustomerID, Ftype, FdeliveryRoute, FitemNumber)
Primary Key FscheduleNumber
FcustomerID references TCustomer (FcustomerID)
FitemNumber references TItem (FitemNumber)