COIT20247 Database Design and Development

Student ID:
Student Name:

Report
Database Normalization
3NF Relations
TabCustomer (FildCustomerID, FildCustomerName, FildStreet, FildCity, FildPostCode,
FildCustomerContactNum)
Primary Key FildCustomerID
TabEmployee (FildEmployeeID, FildEmployeeName, FildEmployeeStartDate)
Primary Key FildEmployeeID
TabParcel (FildParcelID, FildParcelWeightInGrams, FildFromStreet, FildFromCity,
FildFromPostCode, FildToStreet, FildToCity, FildToPostCode, FildDateCollected,
FildParcelValue, FildCharges, FildStatus, FildCustomerID, FildEmployeeID)
Primary Key ParcelID
FildCustomerID references TabCustomer (FildCustomerID)
FildEmployeeID references TabEmployee (FildEmployeeID)
TabDelivered (FildParcelID, FildDeliveredDate)
Primary Key FildParcelID
FildParcelID references TabParcel (FildParcelID)
TabReturned (FildParcelID, FildReturnedDate)
Primary Key FildParcelID
FildParcelID references TabParcel (FildParcelID)
TabLost (FildParcelID, FildLostEntryDate)
Primary Key FildParcelID
FildParcelID references TabParcel (FildParcelID)
TabClaim (FildClaimID, FildClaimLodgeDate, FildClaimSettledAmount, FildClaimPaidDate,
FildParcelID)
Primary Key FildClaimID
FildParcelID references TabLost (FildParcelID)
TabInvoice (FildInvoiceID, FildInvoiceAmount, FildInvoiceDate, FildParcelID)

Primary Key FildInvoiceID
FildParcelID references TabParcel (FildParcelID)
Functional Dependency
Claim Table
FildClaimLodgeDate  FildClaimID
FildClaimSettledAmount  FildClaimID
FildClaimPaidDate  FildClaimID
FildParcelID  FildClaimID
Customer Table
FildCustomerName  FildCustomerID
FildStreet  FildCustomerID
FildCity  FildCustomerID
FildPostCode  FildCustomerID
FildCustomerContactNum  FildCustomerID