Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Temporal Databases Research And Practice Lncs 1399

Authors: Opher Etzion ,Sushil Jajodia ,Suryanarayana Sripada

1st Edition

3540645195, 978-3540645191

More Books

Students also viewed these Databases questions