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

(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

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!