oracle 11g script needed

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