Question: Study the following database table named course_registration, Table 1 semester intake year_intake 2 2010 1 2015 course student_name Country pre_entry register Ahmad Bin Social Malaysia

 Study the following database table named course_registration, Table 1 semester intake

year_intake 2 2010 1 2015 course student_name Country pre_entry register Ahmad Bin

Social Malaysia Diploma Mokhtar, Science Aminah Bt Jusoh, Ali Bin Atan Juliana

Study the following database table named course_registration, Table 1 semester intake year_intake 2 2010 1 2015 course student_name Country pre_entry register Ahmad Bin Social Malaysia Diploma Mokhtar, Science Aminah Bt Jusoh, Ali Bin Atan Juliana Bt Art Malaysia SPM Dahlan, David a/1 Murusamy Zainab Bt Musa, IT Malaysia, Diploma Kumar a/l Morocco Muthu, Omar Saeed Abdullah, Ghanish A/I Devindran 3 2018 Question 4 (b) 3 points (b) Explain the problem that occurs in the records of the data kept in a database table named course registration. [3 marks) Your answer 5 points Question 4 (c) Please upload your Question 4 (c) answer by clicking the "Add file' button below. Please make sure the answer is fully satisfy Draw a first normal form (INF) to eliminate data in the record which was discovered in Question 4 (b). [5 marks) 1 Add File 9 points Question 4 (d) Please upload your Question 4 (d) answer by clicking the "Add file button below. Please make sure the answer is fully satisfy (d) Draw a second normal form (2NF) diagram based on the INF diagram created in Question 4 (c). [9 marks) 1 Add File

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!