COIT20247 Database Design and Development

COIT20247
Database Design
and Development
Assignment 2
Student ID:
Student Name:
5/20/2019

Report
Normalization
Normalized Relations
TabbCustomer (FiildCustomerID, FiildCustomerName, FiildStreet, FiildCity, FiildPostCode,
FiildCustomerContactNum)
Primary Key FiildCustomerID
TabbEmployee (FiildEmployeeID, FiildEmployeeName, FiildEmployeeStartDate)
Primary Key FiildEmployeeID
TabbParcel (FiildParcelID, FiildParcelWeightInGrams, FiildFromStreet, FiildFromCity,
FiildFromPostCode, FiildToStreet, FiildToCity, FiildToPostCode, FiildDateCollected,
FiildParcelValue, FiildCharges, FiildStatus, FiildCustomerID, FiildEmployeeID)
Primary Key ParcelID
FiildCustomerID references TabbCustomer (FiildCustomerID)
FiildEmployeeID references TabbEmployee (FiildEmployeeID)
TabbDelivered (FiildParcelID, FiildDeliveredDate)
Primary Key FiildParcelID
FiildParcelID references TabbParcel (FiildParcelID)
TabbReturned (FiildParcelID, FiildReturnedDate)
Primary Key FiildParcelID
FiildParcelID references TabbParcel (FiildParcelID)
TabbLost (FiildParcelID, FiildLostEntryDate)
Primary Key FiildParcelID
FiildParcelID references TabbParcel (FiildParcelID)
TabbClaim (FiildClaimID, FiildClaimLodgeDate, FiildClaimSettledAmount,
FiildClaimPaidDate, FiildParcelID)
Primary Key FiildClaimID
FiildParcelID references TabbLost (FiildParcelID)
TabbInvoice (FiildInvoiceID, FiildInvoiceAmount, FiildInvoiceDate, FiildParcelID)

Primary Key FiildInvoiceID
FiildParcelID references TabbParcel (FiildParcelID)
Functional Dependency
Employee Table
FiildEmployeeName  FiildEmployeeID
FiildEmployeeStartDate  FiildEmployeeID
Customer Table
FiildCustomerName  FiildCustomerID
FiildStreet  FiildCustomerID
FiildCity  FiildCustomerID
FiildPostCode  FiildCustomerID
FiildCustomerContactNum  FiildCustomerID