Question 1 The following questions will be based on the tables given below: Emp Name Post Unit Unit_name Subject Subject

[answerhappygod]

Question 1 The Following Questions Will Be Based On The Tables Given Below Emp Name Post Unit Unit Name Subject Subject 1 (48.64 KiB) Viewed 17 times

Question 1 The following questions will be based on the tables given below: Emp Name Post Unit Unit_name Subject Subject code -code No CSC131 11111 Dalilah Lecturer CSC 22222 Zaleha Lecturer CSC 33333 Aishah Lecturer CSC 44444 Salman Lecturer ENG Computer Science Computer Science Computer Science Engineering CSC125 Problem Solving using computer ITS250 ITS330 ITS250 Computer Concept ENG12 3 Intro to dbase design System analysis and design Intro to dbase design CSC258 Data Structure Heat and Mass Transferi Credit Room_no hour 4 4 4 4 4 4 4 B610 B622 B408 B408 B408 Lab 1 B225 a) What normal form is the table in? Give your reasons. (2 marks) b) Identify the primary key for the table (2 marks) c) Normalize the table into 3NF and show all the steps involved in order for you to reach your answer (10 marks)