Assignment Instructions

Instructions: 

1) You must upload the database name in this format

     INFO261_WK2_{yourlastname}.accdb.

2) Make sure that you review Chapter 2 from the text book. 

3) I encourage you to search the Internet for additional information.

 

Assignment:

You are going to build tables for the following:

You are about to model a small education institute with the following specs

there are 5 instructors, 8 courses, 3 classrooms, and 40 students

The relationships between them as follows;
Each  instructor has one or more courses, each course will be taught in one or more classroom, each classroom will have one or more students, you need to relate the tables using primary/ foreign keys.

Insert  all required records (5 instructors, 8 courses, 3 classrooms, and 40 students)
in each table to demonstrate the relationships, also the student can take more than one course

*** Rules
1) You must enter your name as one of the instructors
2) Each course is taught once a week for 8 weeks

** Be creative and simple, you can use more tables if needed such as enrollment or schedule