The purpose of this exercise is to provide students with the opportunity to visualize your table definitions before you begin building your tables. In order to facilitate this process, I have provided a short description on how they relate to each other.

Course – This is the general course information. This includes high level details about the courses but not necessarily the details related to a given section of the course.

Faculty – This is the instructor that would be hosting a class.

Location – This is the details around the given location in which the session will be hosted.

Section – This is the actual details around where the section may be hosted including location, time, date, instructor and so on.

Student – This is the student that would be attending a class.

You should think of this in a normalized sense. After normalizing your data set, you should have created references through the user primary and foreign keys and so forth.

To Do:

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.