Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
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 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started