COURSE SELECTION LAB

In this lab you will make a relational database that allows a guidance counselor to create a student schedule.

You are making this database from scratch. There will be 4 tables to construct ( this is almost identical to the Baseball and Coffee databases you have already created.

Name your new database CourseSelector.

1. Take a look at the screensnapshot below - to get an idea how the finished product will look.
2. Create two tables- student data and courses.
3. To see the student data fields, look at the screen snapshot below. Put fake data in the table
4. To get the courses fields, look at the screen snapshot below. Put fake data in the table. You will need 16 courses - two for each period.
5. Create the line item table and create needed fields
6. Relate the databases, make the portal on CourseSelector