Question: Rem Cat 01 Please find the database table below. Staff Staff Name si Mahta Salim Al Badi Dept (RoomNo, Location) IT, New Building ProjectID P1

 Rem Cat 01 Please find the database table below. Staff Staff

Rem Cat 01 Please find the database table below. Staff Staff Name si Mahta Salim Al Badi Dept (RoomNo, Location) IT, New Building ProjectID P1 Project Name IOT 300 P2 350 6 P3 500 A S2 Zuwalna Rashid Al Alowi P3 Big Data Accounting Accounting Big Data BS Main Bulding EN Engg Building B 375 400 S4 Rahman Al Abri P2 B P1 500 A Assume that above table has following functional dependencies: Stal > StaffName, Dept PrajectID -> Project Name Staff, Project Rem Remi - Cat Find the Primary key of the table. (1 Mark) Check the conditions of First Normal Form (INF) to check if the table is in 1NF, it No, make it INF compliant. (2 Marks) Check the conditions of Second Normal Form (2NF) on the resultant tables to check if the tables are in 2NF, if No, make them 2NF compliant (2.5 Marks Check the conditions of Third Normal Form (BNF) on the resultant tables to check if the tables are in 3NF, if No, make them 3NF compliant. 25 Maries) When you are sure that all the tables are in 3NF, name all the tables with suitable names and mark the primary keys. (2 Marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!