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

Some field are very general like courseid, facultyid, firstname, lastname etc. we can put directly.

Description - Description of the course
Days - on which day (mon, tue, etc)
StartTime - starting time
EndTime - Ending time
Status - Status of the course
capacity - no. of students capacity (100 students)

Experience - experience of the faculty

Building - building number
Room - room number
SeatAailable - no. of seats available in the room

SectionID - where the course class will be in the section