M3b Create and Use Database - Part 2

Submit the statements for the Create and Use Database based on the diagram (as corrected) from the M2b Ivey School of Business: Doctoral Tracking Database - Part 3 assignment.

Please review the complete Create and Use Database Instructions page before submitting this assignment.

Submit the entire script for the Ivey Database Model as a single text file. The file must instructions to:

a header, subheaders, and all necessary comments

drop the tables you are creating (in case they've already been created within the schema I'm using)

create all the tables for the project

insert sample data into the tables

create a view that lists all active students and their advisors

delete data - delete one row from each table

produce the reports listed below

Reports

Course enrollment report for selected term

Fields: course number/name, professor (last name comma first name), student (last name comma first name)

Sort: course number

Input: term (prompt should indicate format for term input)

Course completion status report: List of all courses a student has started and the status

Fields: student last name, student first name, course number, course name, status

Sort: Student last name, course number

Input: none

Thesis committee report

Fields: student name (as last comma first), thesis advisor name (as last comma first), committee member name (as last comma first), chair indicator (a yes/no indication of whether that committee member is the chair)

Sort: student last name, committee member last name

Input: none

Course sequence: List of all courses and their prerequisite

Fields: course number, course name, course prerequisite number, course prerequisite name

Sort: course number

Input: none