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 Please review the complete Create and Use Database Instructions page before submitting this assignment.