By using Oracle 11g sql plus create a single script file:
Submit the whole script for the Model shown below as a single text file. The file should comprise scripts to:
1) Drop the tables you are creating (in case they've already been created within the schema).
2) Create the tables for the project.
3) Insert sample data into the tables.
4) Produce the reports listed below.
Reports:
A) Faculty: List of all the faculty:
• Fields: first name
• Sort: last name
• Input: none
B) Advisors: List of all the 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
C) Student status: List of all the students and their enrollment status
• Fields: first name, last name, current enrollment status, years enrolled, academic advisor
• Sort: years enrolled
• Input: none
D) Course enrollment report for chosen term:
• Fields: course number or name, professor (last name comma first name), student (last name comma first name)
• Sort: course number
• Input: term
E) Course completion status report: List of all the 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
F) Thesis committee report:
• Fields: student name (as last comma first), committee member name (as last comma first), chair indicator (a yes or no indication of whether that committee member is the chair).
• Sort: student last name, committee member last name.
• Input: none.
G) Course sequence: List of all the courses and their prerequisite.
• Fields: course number, course name, course prerequisite number, course prerequisite name
• Sort: course number
• Input: none