Ask Question, Ask an Expert


Ask Programming Language Expert

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.



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

Programming Language, Programming

  • Category:- Programming Language
  • Reference No.:- M9956

Have any Question? 

Related Questions in Programming Language

1 implement dfs by using prolog2 implement bfs by using

1. Implement DFS by using PROLOG. 2. Implement BFS by using PROLOG. 3.  Solve the problem of Question 3 in Assignment 1 by using your PROLOG programs of DFS and BFS, respectively. Question 3 from Assignment 1 to Solve wi ...

Operating systems assignment-1 binary record sorting in

Operating Systems Assignment- 1. Binary Record Sorting in Ascending Order| You will write a simple sorting program. This program should be invoked as follows: shell% ./fastsort -i inputfile -o outputfile The above line m ...

Concurrent programming task ydetailsmany banking systems

CONCURRENT PROGRAMMING TASK YDETAILS Many banking systems allow multiple cardholders access a single account (e.g. a business account). The consequence of this is that is possible for more than one person to attempt to w ...

Shell programmingyou have created the directory structure

Shell Programming You have created the directory structure and some base files to be used by the Web server and Web site. For the Web site to be created in a production environment, you need to package your commands in a ...

1 construct a markov algorithm that will reverse the order

1) Construct a Markov Algorithm that will reverse the order of an input string that consists of zero or more upper case letters. ABCDE should become EDCBA, AB should become BA, A should stay A, and A should stay A. NOTE: ...

Integrative programmingassignment- managing a user account

Integrative Programming Assignment- Managing a User Account List Objective: To manage a user list that can be modified and saved to a text file. Inputs: • Input text file consisting of pairs of usernames and passwords, s ...

Write a program that calculates several possible tips to

Write a program that calculates several possible tips to give to a waiter at a restaurant. Ask the user to enter the total cost of the meal and then calculate a tip at 10%, 12.5%, 15%, 17.5%, and 20%. Write the original ...

Electrical engineering computer methods assignmentq1 write

Electrical Engineering Computer Methods Assignment Q1. Write a program that given the following array, reverses all array elements and then prints them. int x[] = {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}; Q2. Write a program to d ...


Computer Science Program- Write all of the following: main program: Call a function to open an input file. Call a function to read 3 integers in from the input file. Call a function that will find 3 normalized doubles, g ...

Part a-1 what arguments can you make for the idea of a

Part A- 1. What arguments can you make for the idea of a single programming language for all programming domains? It would be ideal to have a single programming language for all 2. What arguments can you make against the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate