Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions