Part Aa)User viewsEmployee tableDepartment tableProject tableCustomer table
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
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Systems and Designlg...
|12
|558
|120
Hall of Fame Nominated Team Member HallOfFame HallOfFamelg...