Database System of International Parcel Service (IPS)

Student ID:
Student Name:
Date:

Report
Introduction
The report is explaining the database system of International Parcel Service (IPS). The logical
design and physical design both are explained in the report. The report is showing the database
report, database form and all developed queries. The logical design is developed by the ER
diagram and physical design is implemented into the MS Access database.
ER Diagram

The ER diagram is showing the database in pictorial form. Each entity and its attributes are being
shown in the report. The ER diagram is made in the crow’s foot notation. The tables in the ER
diagram are in the third normalized form.
Relational Schema inThird Normal Form Relations
TabCustomer (FlcustomerID, FlCustomerName, Fladdress, Flphone, Flemail)
Primary Key FlCustomerID
TabItem (FlitemNumber, Flweight, Fldimensions, FlinsuranceAmount, Fldestination,
FlfinalDeliveryDate, Flinstructions)
Primary Key FlitemNumber
TabRetailCentre (FlretailCentreID, Fltype, Fladdress)
Primary Key FlretailCentreID
TabEmployee (FlemployeeID, FlemployeeName, Fladdress, Flphone, Flemail,
FlretailCentreID)
Primary Key FlemployeeID
FlretailCentreID references Tabretail_Centre (FlretailCentreID)
TabReceipt (FlitemNumber, FlreceivedDate, Flcharges, FlretailCentreID, FlemployeeID)
Primary Key FlitemNumber
FlretailCentreID references Tabretail_Centre (FlretailCentreID)
FlemployeeID references TabEmployee (FlemployeeID)
FlitemNumber references TabItem (FlitemNumber)
TabTransportation (FlscheduleNumber, FlcustomerID, Fltype, FldeliveryRoute,
FlitemNumber)
Primary Key FlscheduleNumber
FlcustomerID references TabCustomer (FlcustomerID)
FlitemNumber references TabItem (FlitemNumber)