Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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_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 IVStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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