Question: Hi there, can you help me with this question? TABLE: USER USER_NUM USER_NAME USER_STATE USER_AGE 1 Ramesh Penang USER_COUNTRY Malaysia Malaysia 20 2 Ramesh Malacca

Hi there, can you help me with this question? TABLE: USER USER_NUMHi there, can you help me with this question?

TABLE: USER USER_NUM USER_NAME USER_STATE USER_AGE 1 Ramesh Penang USER_COUNTRY Malaysia Malaysia 20 2 Ramesh Malacca 19 3 Ramli Kedah 21 Malaysia Malaysia 4 Alyssa Penang 19 Given the USER table above. Based on the sample data provided in the table, recommend strategies to improve the design of the table up till 3NF. 1. Resolve the transitive dependency USER_STATE USER_COUNTRY. II. Set USER_NAME as the primary key of the table. III. Store the user's date of birth instead of age. IV. Break down the USER_NAME attribute into two more atomic attributes storing the first name and last name. V. The USER is already in 3NF and requires no change. I and III II and IV V only I, III and IV

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!