Question: (b) Examine the relation schema Project_Employee shown in Table 2 and answer all questions given. Proj_No and Emp_No are chosen as the primary key for
(b) Examine the relation schema Project_Employee shown in Table 2 and answer all questions given. Proj_No and Emp_No are chosen as the primary key for this table. Table 2: Project_Employee Relation Proj_No Proj_Title Proj_Manager Proj_Budget Emp_No Emp_Name P001 Aims Web Faris Ismail 24,500 510001 Syahidah Mohd P001 Aims Web Faris Ismail 24,500 S10030 Firdaus Ali POO1 Aims Web Faris Ismail 24,500 S21010 Kamal Mahmud POOS HR System Afham Tarmizi 17,500 S10010 Jamal Ibrahim PO05 HR System Afham Tarmizi 17,500 S10001 Syahidah Mohd PO05 HR System Afham Tarmizi 17,500 S31002 Fakrul Amirudin PO05 HR System Afham Tarmizi 17,500 S13210 Daud Ahmad P009 RADIS Amir Farhan 15,000 S31002 Fakrul Amirudin P009 RADIS Amir Farhan S21010 Kamal Mahmud P009 RADIS Amir Farhan 15,000 510034 Helmi Baba Dept No Dept_Name Rate (Hourly) D004 Information System 22.00 D023 Software Engineering 18.50 D004 Information System 21.00 D004 Information System 21.75 D004 Information System 18.00 D028 Network & Security 25.50 D008 Multimedia 17.0 DO28 Network & Security 23.25 D004 Information System 17.50 DO23 Software Engineering 16.50 15,000 i) Identify all functional dependencies that can be derived for Project_Employee relation in Table 2. ii) Based on the functional dependencies identified in (i), produce the 1NF relation schema and show the primary key for this relation. Transform the relation schema in (ii) into 2NF and 3NF relations
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
