Normalize the above mentioned table up to 3rdnbspnormal


Database Management System

The Assignment:

Student #

S_Name

S_Address

S_phone

Advisor

A_Room No

Course_code

Course_Name

Credit_

Hours

Instructor Name

Address

Major

1

John

NY

123

Jonah

307

Cs403

DBMS

3

Khan

VU

BCS

2

Smith

LHR

456

Jain

308

Cs403

DBMS

3

Khan

VU

BIT

3

Jason

KAR

789

Nasir

309

Cs401

NW

3

Habib

VU

MCS

1

John

NY

123

Jonah

308

Cs402

SWE

3

Lodhi

VU

BCS

4

Roberta

Texas

654

Sajid

310

Cs402

SWE

3

Lodhi

VU

MIT

5

Jack

NY

321

Sajid

310

Cs401

NW

3

Habib

VU

MIT

6

Jill

MTN

212

Nasir

309

Cs404

OS

3

A.D

VU

MCS

1

John

NY

123

Johan

307

Cs406

NC

3

Naseeb

VU

BCS

6

Jill

MTN

212

Sajid

310

Cs406

NC

3

Naseeb

VU

MIT

Normalize the above mentioned table up to 3rd normal form. 

Purposes:

Ensure that you can able to normalize any relation  

Objective

  • This assignment has been designed so that you understand the concept of Normalization.

Solution Preview :

Prepared by a verified Expert
Business Management: Normalize the above mentioned table up to 3rdnbspnormal
Reference No:- TGS01385555

Now Priced at $20 (50% Discount)

Recommended (93%)

Rated (4.5/5)