Ask a question from expert

Ask now

Database Normalization Assignment

6 Pages345 Words276 Views
   

Added on  2020-05-01

Database Normalization Assignment

   Added on 2020-05-01

BookmarkShareRelated Documents
Student Details
Database Normalization Assignment_1
Part Aa)User viewsEmployee tableDepartment tableProject tableCustomer table
Database Normalization Assignment_2
b)RelationshipsThe following are the relationships that exist between the tablesThe relationship between Employee and department is one to oneThe relationship between Customer and project is one to manyThe relationship between Project and employee is one to manyThe relationship between Project and department is one to manyc)NormalizationNormalization involves removing any duplicate records to achieve the following tablesEmployee tableDepartment tableProject table
Database Normalization Assignment_3

End of preview

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

Related Documents
Database Systems and Design
|12
|558
|120

Hall of Fame Nominated Team Member HallOfFame HallOfFame
|7
|1207
|492

COIT20247- Database Design and Development
|7
|699
|75

1804ICT – Data Management
|12
|994
|207