COIT20247 Database Normalization and ERD Mapping

Report
Database Normalization
Third Normal Form Relations
TlCustomer (FlCustomerID, FlCustomerName, FlStreet, FlCity, FlPostCode,
FlCustomerContactNum)
Primary Key FlCustomerID
TlEmployee (FlEmployeeID, FlEmployeeName, FlEmployeeStartDate)
Primary Key FlEmployeeID
TlParcel (FlParcelID, FlParcelWeightInGrams, FlFromStreet, FlFromCity, FlFromPostCode,
FlToStreet, FlToCity, FlToPostCode, FlDateCollected, FlParcelValue, FlCharges, FlStatus,
FlCustomerID, FlEmployeeID)
Primary Key ParcelID
FlCustomerID references TlCustomer (FlCustomerID)
FlEmployeeID references TlEmployee (FlEmployeeID)
TlDelivered (FlParcelID, FlDeliveredDate)
Primary Key FlParcelID
FlParcelID references TlParcel (FlParcelID)
TlReturned (FlParcelID, FlReturnedDate)
Primary Key FlParcelID
FlParcelID references TlParcel (FlParcelID)
TlLost (FlParcelID, FlLostEntryDate)
Primary Key FlParcelID
FlParcelID references TlParcel (FlParcelID)
TlClaim (FlClaimID, FlClaimLodgeDate, FlClaimSettledAmount, FlClaimPaidDate,
FlParcelID)
Primary Key FlClaimID
FlParcelID references TlLost (FlParcelID)
TlInvoice (FlInvoiceID, FlInvoiceAmount, FlInvoiceDate, FlParcelID)

Primary Key FlInvoiceID
FlParcelID references TlParcel (FlParcelID)
Functional Dependency
Claim Table
FlClaimLodgeDate  FlClaimID
FlClaimSettledAmount  FlClaimID
FlClaimPaidDate  FlClaimID
FlParcelID  FlClaimID
Employee Table
FlEmployeeName  FlEmployeeID
FlEmployeeStartDate  FlEmployeeID
(Poolet A. M. 2019)