Database Normalization and Implementation

[COIT20247
DATABASE DESIGN
AND DEVELOPMENT
(T12019)]
Student ID:
Student Name:
2019

Report
Database Normalization
3NF Relations
TblCustomer (FldCustomerID, FldCustomerName, FldStreet, FldCity, FldPostCode,
FldCustomerContactNum)
Primary Key FldCustomerID
TblEmployee (FldEmployeeID, FldEmployeeName, FldEmployeeStartDate)
Primary Key FldEmployeeID
TblParcel (FldParcelID, FldParcelWeightInGrams, FldFromStreet, FldFromCity,
FldFromPostCode, FldToStreet, FldToCity, FldToPostCode, FldDateCollected, FldParcelValue,
FldCharges, FldStatus, FldCustomerID, FldEmployeeID)
Primary Key ParcelID
FldCustomerID references TblCustomer (FldCustomerID)
FldEmployeeID references TblEmployee (FldEmployeeID)
TblDelivered (FldParcelID, FldDeliveredDate)
Primary Key FldParcelID
FldParcelID references TblParcel (FldParcelID)
TblReturned (FldParcelID, FldReturnedDate)
Primary Key FldParcelID
FldParcelID references TblParcel (FldParcelID)
TblLost (FldParcelID, FldLostEntryDate)
Primary Key FldParcelID
FldParcelID references TblParcel (FldParcelID)
TblClaim (FldClaimID, FldClaimLodgeDate, FldClaimSettledAmount, FldClaimPaidDate,
FldParcelID)
Primary Key FldClaimID
FldParcelID references TblLost (FldParcelID)
TblInvoice (FldInvoiceID, FldInvoiceAmount, FldInvoiceDate, FldParcelID)

Primary Key FldInvoiceID (Guru99 2016)
FldParcelID references TblParcel (FldParcelID)
Functional Dependency
Invoice Table
FldInvoiceAmount  FldInvoiceID
FldInvoiceDate  FldInvoiceID
FldParcelID  FldInvoiceID
Customer Table
FldCustomerName  FldCustomerID
FldStreet  FldCustomerID
FldCity  FldCustomerID
FldPostCode  FldCustomerID
FldCustomerContactNum  FldCustomerID