Question: 1. ( 25 pts.) Write the SQL statements to create a view called as ProductPrice that returns the price of products that are electronics. 2.

1. ( 25 pts.) Write the SQL statements to create a

1. ( 25 pts.) Write the SQL statements to create a view called as "ProductPrice" that returns the price of products that are electronics. 2. (75 pts.) Create a PL/SQL function called as "GetCustomerinfo" which gets a customer id (cid) and returns the total numbe of buying for the given customer. ( 40pts.) - Function returns 1 if the given customer id does not exist. (5 pts.) - Display "No customer found" message if there is no customer for the given id. (10 pts.) - Display number of buying for each customer. (10 pts.) - Use "DBMS_OUTPUT.PUT_LINE" for displaying output. - Create anonymous block to test function. (10 pts.) Note1: PK Primary Key FK Foreign Key NN Not Null Note2: You can find sample data on the back of the page

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. (25 pts.) Write the SQL statements to create a view that will display course names by section. 2. (75 pts.) Create a PL/SQL procedure which accepts a course code (ccode) and display the...

Just solve question 2 QUESTIONS 1. (25 pts.) Write the SQL statements to create a ylew that will display student names and sum of students by section. 2. (75 pts.) Create a PL/SQL procedure which...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Introduction to databases Assignment 1 Description of the schema The following database is used by a building materials company to edit invoices for its customers and to manage its inventory The...

Page 1 of 4 SQL Assignment ACCTG 333 - Fall 2019 Professor Perols Due Friday, November 8, 2019 Why should you learn SQL? Technology is drastically changing the accounting industry...and structured...

There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...

CIS 220 Week 5 Assignment. Please complete all the questions and paste your codes to this document. Also submit all the source code files along with this assignment. 1-a) Design a blueprint class...

please help me with this as my tutor fell through and I dont understand all sections these are the programs it gave me this is the main java above this is the grade book reader above these are the...

Q This document has all of the instruction in it. please contact me if you have any questions. Download Attachment: (1) On October 5, Narveson Company buys merchandise on account from Rossi Company....

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

Water at 150 kPa and 12oC is heated in a mixing chamber at a rate of 3 kg/s where it is mixed with steam entering at 150 kPa 120oC. The mixture leaves the chamber at 150 kPa and 55oC. Heat is lost to...

Book value is the value of an asset that a company uses to create its balance sheet. Some companies depreciate assets using straight-line depreciation so that the value of the asset declines by a...

2. If Haley My Hang Althaus earned $10,000 in 2008, how much Social Security tax did she pay? (LO5 )

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

9. Are your presentation aids solid, and do they back up your main points (without overwhelming your speech)?

7. Have you defined your terms clearly and related unfamiliar terms to familiar ideas?

3. Locate a persuasive speech that you found particularly compelling. Print it out and edit it, removing any and all of the material that you feel is persuasive in nature (for example, the speakers...