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 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
Get step-by-step solutions from verified subject matter experts
