Using Oracle 11g sql plus create a single script file-
Submit the entire script for the Model shown below as a single text file. The file must include scripts to:
1. drop the tables you are creating (in case they've already been created within the schema I'm using)
2. create the tables for the project
3. insert sample data into the tables
4. produce the reports listed below
Reports
Faculty: List of all faculty
• Fields: first name
• Sort: last name
• Input: none
Advisors: List of all students and their advisors
• Fields: student's first name, student's last name, advisor's first name, advisor's last name
• Sort: student's last name
• Input: none
Student status: List of all students and their enrollment status
• Fields: first name, last name, current enrollment status, years enrolled, academic advisor
• Sort: years enrolled
• Input: none
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
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), 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