Question
Find the 1NF, 2NF, and 3 NF and show your work step by step (follow, apply and explain the normalization process): Let us assume a
Find the 1NF, 2NF, and 3 NF and show your work step by step (follow, apply and explain the normalization process):
Let us assume a table USERINFO as given below:
UserID | UserEmail | Fname | Lname | City | State | PCode |
J123 | Joe@yahoo.com | Joe | Smith | Toronto | Ontario | M3R4Z5 |
JO45 | John@yahoo.com | John | Doe | Brampton | Ontario | L6S4T4 |
B678 | Brian@yahoo.com | Brian | Silva | Oakville | Ontario | L6M4G6 |
A895 | Amy@yahoo.ca | Amy | Sylvia | Victoria | BC | V8Z3L6 |
D185 | Dan58@yahoo.com | Danny | Ford | St. Johns | NL | A1H3J5 |
Q1: Is this table in First Normal Form? Explain, if no, how to convert into 1NF?
Q2: Is this table in Second Normal Form? Explain, if no, how to convert into 2NF?
Q3: Is UserInfo in 3NF? Explain, if no, how to convert into 3NF?
Step 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