CCCS215Lab#8 ExerciseHaving the following DB:create table dep (deptno number (3) primary key,dname varchar2 (20));create table course (corsno number (3) primary key,cname varchar2 (30),deptno number (3),cmax number (2),foreign key (deptno) references dep (deptno));insert into dep values (1,'cs');insert into dep values (2,'it');insert into dep values (3, 'is');insert into course values (1,'intro to DS', 2,30);insert into course values (2, 'data warehousing', 2,30);insert into course values (3, 'data mining', 2,30);insert into course values (4, 'algorithms', 1,30);insert into course values (5, 'OOP I', 1,30);insert into course values (6, 'project management', 3,30);select * from dep;select * from course;Exercise: Write a stored procedure which receives a department name(p_depName) as input, and displays the list of courses ' names for the specifieddepartment name.

Here we write store procedure for get desired output:…

Answered: Exercise: Write a stored procedure…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Increment Count Using Augmented Assignment Use an augmented assignment operator to increment the value stored in the variable count by one. Assume that count already has a value.
PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csv
The memory locations listed in a procedure’s parameterList have procedure scope and are removed immediately after the procedure header is processed.a. Trueb. False
Formatting Customer Names Build a function that displays a customer's name and location if applicableSuppose that you are building a Customer Relationship Management (CRM) system, and you want to display a user record in the following format: John Smith (California). However, if you don't have a location in your system, you just want to see "John Smith." Create a format_customer() function that takes two required positional arguments, first_ name and last_name, and one optional keyword argument, location. It should return a string in the required format. Create the customer.py file. Define the format_customer() function. Open a Python shell (Or Jupyter Notebook) and import your format_customer() function. Try running a few examples. The calls should look like this: from customer import format_customerformat_customer('John', 'Smith', location='California') and the output should look like this: John Smith (California) In [ ]:
Python No hand written and fast answer with explanation
It is recommended to use functions that are specified by the user rather than those that are preset.
Menu option C The program reads in data from HowManyHours.txt, displays a report header with the report creator’s name, employee id, and department and who they created the report for. The body of the report displays the total number of students who used the program, the average credits taken, and the average study hours. In the following format –STUDY HOURS REPORT Created for Dr. Payne, A004567893 Dept: Computer Science Created By: Karen Smith, A00494928Dept: Advising Total Students: 3Average Credits: 9.00Average Study Hours: 20.00Menu option DThank the user for using the programTerminates the program
Task 6: Create the GET_INVOICE_DATE procedure to obtain the customer ID, first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I_INVOICE_NUM. Place these values in the variables I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE respectively. When the procedure is called it should output the contents of I_CUST_ID, I_CUST_NAME, and I_INVOICE_DATE. (mySQL)
E MyS Mura 04- S Visu: Blac 9 Sign N Hom MyS y goog y! Exer SN c.blackboard.com/ultra/courses/_207342_1/cl/outline Completion Your answers are saved automatically. * Question Completion Status: QUESTION 1 Exercise: Create a statement that will make a copy of the vendors table. The name of the copy should be vendors QUESTION 2 Exercise: Create a statement that will delete the vendors archive table you created in the previous exercise. QUESTION 3 Exercise: Create a statement that will add the following row to the vendor_contact table Click Save and Submit to save and submit. Click Save All Answers to save all answers.
The Save Transaction button depicted in the screen attached is used to save relevant data to the sales table and the salesdetails tables from the depicted schema. When this button is clicked it calls the saveTransaction() function that is within the PosDAO class, it passes to this function an ArrayList of salesdetails object, this list contains the data entered into the jTable which is the products and qty being sold.Write the saveTransaction function. You are to loop through the items and get the total sales, next you are to insert the current date and the total sales into the sales table. Reminder that the sales table SalesNumber field is set to AUTO-INCREMENT, hence the reason for only entering the total sales and current date in sales table.
Write a stored procedure named displayNumberOfFilmRatings(). The displayNumberOfFilmRatings () procedure should find number of films for each film rating and then display the film rating and the number for films having that type of rating. Note: The displayNumberOfFilmRatings() procedure does not need to declare any variables. Hint: The output should have two columns only. Hint: There is no need to use cursor processing for this stored procedure.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Concepts of Database Management

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS

Exercise: Write a stored procedure which receives a department name p_depName) as input, and displays the list of courses ' names for the specified lepartment name.