90.2K

Verified Solution

Link Copied!

The following is extracted from the student record of the New Age Business College. StaffName SFirstname Irene Grade D D David SID 92212103 96013245 98765432 98765432 92212103 92212103 93315644 99121112 98765432 SUBJNO 11269 11269 11269 11270 11270 11266 11266 11252 11269 Slastname Smith Johnstone Huang Huang Smith Smith Patel Sharma Huang SubiectName Information Systems Ethics Information Systems Ethics Information Systems Ethics Management Accounting Management Accounting Financial Accounting Financial Accounting Advanced Auditing Information Systems Ethics Weizhong Weizhong Irene Irene Binod Monita Weizhong Semester S12005 S12005 S22004 S22004 S22004 S22004 S12004 S22003 S22003 SAge 23 34 34 25 22 25 22 23 23 23 20 21 25 StaffID 34512 34512 34512 30072 30072 30072 SDOB 12/02/1982 08/11/1971 06/07/1980 06/07/1980 12/02/1982 12/02/1982 07/06/1985 12/04/1984 06/07/1980 H D F B Boyce A.Adams A Adams A.Adams B.Boyce C.Cook C.Cook A.Adams A.Adams 36214 36214 34512 34512 Required: a. Normalise the above table so that all resulting tables are in the third normal form. b. Create an ER diagram with cardinalities to represent your normalised tables. c. Explain the terms transitive dependency and partial dependency. d. What will be the problems if normalization is not achieved for the database

Answer & Explanation Solved by verified expert

See Answer