Reference no: EM131790345

You are going to build tables for the following:

You are going to create database that will model a small school.Here is some basic info you will need in order to begin creating your database: 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 course 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 the appropriate tables to demonstrate the relationships.

*** Rules

1) You must enter your name as one of the instructors.

2) Each course is taught once a week for 8 weeks.

3) You must have at least 4 tables (instructors, courses, classrooms, students). You will then create  5th table (called either enrollment or schedule) that can be used to connect/create relationships between the other tables. This table should have at least 20 records entered into it. PLEASE SEE THE ATTACHED EXPLANATION DOCUMENT FOR HELP UNDERSTANDING THE RELATIONSHIPS.

4) 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.

5) 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.

Classroom Table: This table only needs to include specific info that would need to be stored for each classroom such as classroom name (ID). This will be the primary key since no two classrooms will have the same number (ID). You may want to add other fields such as building location and description, but they are not necessary.

Students Table: This table only needs to include info that would need to be stored for each student such as ID (the primary key), last name, first name, and some other fields such as date of birth and major.

Instructors Table: This table only needs to include info that would need to be stored for each instructor such as ID (the primary key), last name, first name, and maybe some other fields such as email address, phone number, or department.

Courses Table: This table only needs to include info that would need to be stored for each course such as ID (the primary key), day of the week, start time, end time, section (if you want to offer more than one section of a course, you will need to use courseID and section as the primary/composite key).

Schedule Table: By using this table, you can add more than one student to a course. This table will need to include fields such as scheduleID (the primary key), courseID, and studentID. This table should also include fields for instructorID (to identify who is teaching each course) and classroomID (to identify where the class will be held).