Answer Happy

Question 3 The following question will be based on the given report. SEK. RENDAH KEBANGSAAN ALOR GAJAH, MELAKA MID-TERM EXAM REPORT Date : 19 Mei 2009 Teacher Code: TE0021 Teacher Name: ZawawiAwang Subject Code: ENG05 Subject Name: English Standard Five Birth certificate Student Name no. AK1111 AJ1212 AV4343 AK5555 AB2323 AV3333 AJ5151 AK4545 Ahmad Ali Suraya Abdul Faridah Abu Rahmah Abdullah Class Code TengkuZahid SuriatiSalleh 58 5C 5B 5C 5J 5J Mariam Sufian 5B 5C Wahid Abas Jamilah Osman AJ6677 5B a) What normal form is the report in? Give reason. (2 marks) b) Identify primary key (s) for the above report. (3 marks) c) Normalize into 3 NF. Show all your work. (7 marks) Class 5 Budi 5 Cemerlang 5 Budi 5 Cemerlang 5 Jaya 5 Jaya 5 Budi 5 Cemerlang 5 Budi d) Draw Entity Relationship Diagram (ERD) based on 3NF (6 marks) Marks 80 75 45 97 65 86 80 60 55