This is a Dtabase application that can be useful for a package delivery company (similar to FedEx, UPS, DHL, the USPS, etc.)
ER(Entity Relationship) - Diagram
Description of ERD:
● 1-1, 1-N and N-N lines depicts One-to-One, One-to-Many and Many-to-Many respectively.
● Green Color Rectangles are Entities and Double Walled Rectangles are Weak Entities.
● Grey Color Diamonds are Rectangles.
● Maroon colored Circles are attributes and Double Walled Circles are Multivalued.
Relational Model
Description of Relational Model:
● Green colored tables are Relational Tables(PackageDelivery and Tracking)
● Customer to PackageDelivery is a One-to-Many relationship since one Customer
can ship multiple Packages.
● Customer to Transaction is a One-to-Many relationship since one Customer can do
multiple Transactions.
● Package to PackageDelivery is a One-to-One relationship since one Package can
have only one Receiver.
● Package to Tracking is a One-to-Many relationship since one Package can have
multiple Locations at different times.
● Package to International is a Weak One-to-One relationship.
● Service to Transaction is a One-to-Many relationship since the same service can be
used by multiple transactions.
● Vehicle_Warehouse to Tracking is One-to-Many relationship since the same vehicle
or warehouse can have multiple packages.
● Package to Transaction is a One-to-One relationship since one package can have
only one transaction.
Description of Main Tables:
● Customer table contains all the details like address, phoneNo, etc of each Customer.
● Service table contains all the details like ServiceType (like Prepaid, Postpaid, etc) ,
PackageType, etc.
● Transaction table contains details of all transactions for each PkgID.
● Package contains description of Package, its categories etc