Logical and Physical Design of International Parcel Service Database

[DATABASE
FUNDAMENTALS]
2019
Student ID:
Student Name:

Report
Introduction
The report is showing the logical and physical design of International Parcel Service (IPS). The
ER diagram is showing the important entities and relationships among them. The database design
is being shown by ER diagram while the database is implemented in the MS Access database.

1. ER Diagram
The ER diagram is showing the logical design of the International Parcel Service (IPS)
system. There are six entities in the system. There is one-to-many relationship between Customer
and Transportation entity. There is one-to-many relationship between RetailCentre and
Employee entity. There is one-to-many relationship between Item and Transportation entity.
There is one-to-many relationship between Item and Receipt entity. There is one-to-many

relationship between Employee and Receipt entity. There is one-to-many relationship between
RetailCentre and Receipt entity.
2. Relations in Normalized Form
TabbCustomer (FFcustomerID, FFCustomerName, FFaddress, FFphone, FFemail)
Primary Key FFCustomerID
TabbItem (FFitemNumber, FFweight, FFdimensions, FFinsuranceAmount, FFdestination,
FFfinalDeliveryDate, FFinstructions)
Primary Key FFitemNumber
TabbRetailCentre (FFretailCentreID, FFtype, FFaddress)
Primary Key FFretailCentreID
TabbEmployee (FFemployeeID, FFemployeeName, FFaddress, FFphone, FFemail,
FFretailCentreID)
Primary Key FFemployeeID
FFretailCentreID references TabbretailCentre (FFretailCentreID)
TabbReceipt (FFitemNumber, FFreceivedDate, FFcharges, FFretailCentreID, FFemployeeID)
Primary Key FFitemNumber
FFretailCentreID references TabbretailCentre (FFretailCentreID)
FFemployeeID references TabbEmployee (FFemployeeID)
FFitemNumber references TabbItem (FFitemNumber)
TabbTransportation (FFscheduleNumber, FFcustomerID, FFtype, FFdeliveryRoute,
FFitemNumber)
Primary Key FFscheduleNumber
FFcustomerID references TabbCustomer (FFcustomerID)
FFitemNumber references TabbItem (FFitemNumber)