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) Each course is taught once a week for 8 weeks
2) You must have at least 4 tables (instructors, courses, classrooms, students). You will then create a 5th table (called either enrollment or schedule) that can be used to connect/create relationships between the other tables.
3) Make sure that you use an appropriate primary key in each table. For example, last name is not appropriate for student or instructors. These tables should use an instructor or student ID field as the primary key instead.
4) Data in each table should be unique to that table (this helps to prevent redundant data). For example, the instructors table should only contain info related to instructor characteristics such as ID, Name, Department, etc. This table should not include any data on the courses that each instructor teaches.

 

I've also attached further instructions that really helps out but my issue is creating the relationships. Please see my attached database, as I did most of the layout.