You will need to analyze the data in the spreadsheet and determine functional dependencies. Show your work at each step of 1NF,2NF,3NF. Once the relations are in 3NF create a detailed ERD. After you have your detailed ERD.

Report 1.

List of Classes by semester and in which building they are taught.

Report 2

List of Classes and which Instructor teaches it.

Report 3

List of Students and their grades.

Id

CourseNum

CourseName

InstructorId

InstructorPrefix

InstructorName

SemesterNum

SemesterYear

SemesterSeason

StudentId

FirstName

LastName

Email

Gender

Birthdate

BuildingNum

BuildingName

Grade

1

BIOL-211A

Microbiology

4

Mr

Williamson

2014FA

2014

Fall

289-12-6024

Louis

Clark

lclarko@bbb.org

Male

6/29/1996

2

Library

4

2

ACCT-494Z

Topics: Acct Res & Analysis I

14

Dr

Jones

2014SU

2014

Summer

105-63-6433

Amanda

Bowman

abowmani@hubpages.com

Female

11/23/1985

4

St. Albert

3

3

CHEM-341A

Medicinal Chemistry

19

Mr

Fisher

2015SU

2015

Summer

470-98-9023

James

Davis

jdavis11@cbslocal.com

Male

9/10/1980

4

St. Albert

2

4

HIST-112A

Hist of World Civ 1500 to Pres

3

Dr

Oliver

2014FA

2014

Fall

973-08-5293

Dorothy

Fox

dfox19@phoca.cz

Female

5/15/1995

2

Library

4

5

ENGL-200A

Introduction to Literature

4

Mr

Williamson

2014SP

2014

Spring

494-32-1646

Edward

Hill

ehilla@unc.edu

Male

10/14/1980

2

Library

2

6

HIST-111A

Hist of World Civ to 1500

8

Mr

James

2015SU

2015

Summer

328-70-7072

Jessica

Jordan

jjordanw@clickbank.net

Female

12/4/1994

1

Tower

3

7

CHEM-120A

Foundations of Chemistry

1

Dr

Harvey

2015SU

2015

Summer

105-63-6433

Amanda

Bowman

abowmani@hubpages.com

Female

11/23/1985

2

Library

3

8

ACCT-126A

Managerial Accounting

17

Mrs

Anderson

2014FA

2014

Fall

470-98-9023

James

Davis

jdavis11@cbslocal.com

Male

9/10/1980

3

Rec Center

2