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:
drop the tables you are creating (in case they’ve already been created within the schema I’m using)
create the tables for the project
insert sample data into the tables
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