logo

Database Normalization and 3NF Relations

9 Pages947 Words25 Views
   

Added on  2022-12-22

About This Document

This report discusses the concept of database normalization and 3NF relations. It explains the tables and their relationships in a relational database, along with functional dependencies. The report also provides a demonstration of 3NF and discusses the implementation of a relational database using an ER diagram. It covers data integrity and error messages, as well as various database queries. The report concludes with interesting and difficult points encountered during the assignment.

Database Normalization and 3NF Relations

   Added on 2022-12-22

ShareRelated Documents
Student ID:
Student Name:
Database Normalization and 3NF Relations_1
Report
Database Normalization
3NF Relations
TableCustomer (FieldCustomerID, FieldCustomerName, FieldStreet, FieldCity, FieldPostCode,
FieldCustomerContactNum)
Primary Key FieldCustomerID
TableEmployee (FieldEmployeeID, FieldEmployeeName, FieldEmployeeStartDate)
Primary Key FieldEmployeeID
TableParcel (FieldParcelID, FieldParcelWeightInGrams, FieldFromStreet, FieldFromCity,
FieldFromPostCode, FieldToStreet, FieldToCity, FieldToPostCode, FieldDateCollected,
FieldParcelValue, FieldCharges, FieldStatus, FieldCustomerID, FieldEmployeeID)
Primary Key ParcelID
FieldCustomerID references TableCustomer (FieldCustomerID)
FieldEmployeeID references TableEmployee (FieldEmployeeID)
TableDelivered (FieldParcelID, FieldDeliveredDate)
Primary Key FieldParcelID
FieldParcelID references TableParcel (FieldParcelID)
TableReturned (FieldParcelID, FieldReturnedDate)
Primary Key FieldParcelID
FieldParcelID references TableParcel (FieldParcelID)
TableLost (FieldParcelID, FieldLostEntryDate)
Primary Key FieldParcelID
FieldParcelID references TableParcel (FieldParcelID)
TableClaim (FieldClaimID, FieldClaimLodgeDate, FieldClaimSettledAmount,
FieldClaimPaidDate, FieldParcelID)
Primary Key FieldClaimID
FieldParcelID references TableLost (FieldParcelID)
TableInvoice (FieldInvoiceID, FieldInvoiceAmount, FieldInvoiceDate, FieldParcelID)
Database Normalization and 3NF Relations_2
Primary Key FieldInvoiceID
FieldParcelID references TableParcel (FieldParcelID)
Functional Dependency
Employee Table
FieldEmployeeName FieldEmployeeID
FieldEmployeeStartDate FieldEmployeeID
There is no partial or transitive dependency in Employee table.
Invoice Table
FieldInvoiceAmount FieldInvoiceID
FieldInvoiceDate FieldInvoiceID
FieldParcelID FieldInvoiceID
There is no partial or transitive dependency in Invoice table.
(Tutorialspoint.con n.d.)
Database Normalization and 3NF Relations_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
COIT20247 Database Normalization and ERD Mapping
|9
|928
|391

Database Normalization and Implementation
|9
|840
|35

Database Normalization and Implementation for COIT20247
|9
|766
|417

COIT20247 Database Design and Development
|9
|875
|115

COIT20247 Database Design and Development
|10
|864
|257

The MyLibrary website
|25
|2842
|492