Question

Please check my work.

The purpose of this exercise is to provide students with the opportunity to normalize data.

Assignment:

Identify what fields from the list below belong to which table. If you are uncertain, place the field under the column with your argument on why it should belong. Write your answers in the columns below the table names.

COURSE	FACULTY	LOCATION	SECTION	STUDENT
CourseID CourseNumber CourseName CreditHours Status Description Days StartTime EndTime	FacultyID Status FirstName LastName WorkPhone HomePhone CellPhone Experience Rank PIN	LocationID State City Zip Status	SectionID SectionNumber SeatAvailable Building Status CourseID Room Capacity	StudentID FirstName LastName Status Address LocationID Email WorkPhone DOB

Field List – choose and paste above in correct column

StudentID, Experience, Room, CourseNumber, EndTime, Days, WorkPhone, Status, FacultyID, CreditHours, DOB, PIN, LastName, CourseID, Rank, Description, WorkPhone, City, Building, State, HomePhone, Email, SeatsAvailable, Status, FirstName, MI, CellPhone, MI, CourseName, Address, Status, SectionID, CourseID, FirstName, SectionNumber, StartTime, LocationID, Status, Capacity, Status, Zip, LastName, LocationID

Answer 1

StudentID -> STUDENT,

Experience -> FACULTY,

Room -> SECTION,

CourseNumber-> COURSE,

EndTime -> COURSE,

Days -> COURSE,

WorkPhone -> STUDENT,

Status -> LOCATION, STUDENT, SECTION, COURSE

FacultyID -> FACULTY,

CreditHours -> COURSE

DOB ->STUDENT

PIN -> FACULTY

LastName -> STUDENT. FACULTY

CourseID -> COURSE

Rank -> FACULTY

Description -> COURSE

WorkPhone -> STUDENT

City -> LOCATION

Building -> SECTION

State -> LOCATION

HomePhone -> FACULTY

Email -> STUDENT

SeatsAvailable -> SECTION

Status -> LOCATION, STUDENT, SECTION, COURSE

FirstName -> STUDENT, FACULTY

CellPhone -> FACULTY

CourseName -> COURSE

Address -> STUDENT

Status -> LOCATION, STUDENT, SECTION, COURSE

SectionID -> SECTION

CourseID -> COURSE

FirstName -> STUDENT, FACULTY

SectionNumber -> SECTION

StartTime -> COURSE

LocationID -> LOCATION

Status -> LOCATION, STUDENT, SECTION, COURSE

Capacity -> SECTION

Status -> LOCATION, STUDENT, SECTION, COURSE

Zip -> LOCATION

LastName -> STUDENT, FACULTY

LocationID -> LOCATION