Question: Depend on the database which you created in the assignment 1 write subprograms as following: a. procedure that will accept project number then display list

Depend on the database which you created in the assignment 1 write subprograms as following: a. procedure that will accept project number then display list the employee name and work hours for all employees who work in the project. b. function that will accept the department number then return the number of employee in the department. using pl/sql

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!

Depend on the database which you created in the assignment 1 write subprograms as following: a. Procedure that will accept project number then display list the employee name and work hours for all...

CREATE TABLE DEPARTMENT( DEPTNO INT PRIMARY KEY, DEPTNAME VARCHAR(30) ); INSERT INTO DEPARTMENT VALUES(1,'COMPUTER SCIENCE'); CREATE TABLE PROJECT( PROJECTNO INT, PNAME VARCHAR(30), DEPTNO INT,...

CREATE TABLE DEPARTMENT( DEPTNO INT PRIMARY KEY, DEPTNAME VARCHAR(30) ); INSERT INTO DEPARTMENT VALUES(1,'COMPUTER SCIENCE'); CREATE TABLE PROJECT( PROGNO INT, PNAME VARCHAR(30), DEPTNO INT, FOREIGN...

QUESTION 2 Consider this table which violates 3NF customer-branch cust_id fname lname branch branch_zip_code 1 James Hadley Chicago 60007 2 Susan Tingley Naperville 60540 3 Frank Tucker Elmhurst...

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

Here are the steps you need to go through to do the project: Given the business rules above, create a logical-level Crows Foot ERD using Visio. Show all original entities and any associative entities...

BUAD 2020 - Assignment #5 Database Queries - Microsoft Access. plsss help I am unsure how to do this assignment I just need some assistance Download the A5_SalesCo.accdb database file and review the...

DEPARTMENTS DeptNo DName Location STAFF StaffID + employ, Ename Job + + Mgr CUSTOMERS CustID Name service Address City State Zip AreaCode Phone ReplD HireDate Salary Comm DeptNo manage y create...

Using this table: CREATE TABLE department ( DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) NOT NULL UNIQUE, LOCATION VARCHAR2(20) NOT NULL); INSERT INTO department VALUES(10,...

Determine the force that the smooth roller C exerts on member AB. Also, what are the horizontal and vertical components of reaction at pin A? Neglect the weight of the frame androller. 60 Ib - ft 4...

plss answer the highlighted number PROBLEMS (SI) 2.17 For the situation sketched below, the following information is known: P0 kg/m', PH, = 13 590.0 kg/m', g=9.8 m/s-2, p,-500 kPa. Determine Pn....

does the bond discount amoritization using effective interest method decrease in later periods

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

4. According to the theory of liquidity preference, the central bank can increase the of money and the interest rate. a. supply, raise b. supply, lower c. demand, raise d. demand, lower

5. The LM curve slopes upward because income increases money and, in turn, the interest rate. a. higher, supply b. higher, demand c. lower, supply d. lower, demand

6. At the intersection of the IS and LM curves, a. the economy is at full employment. b. the economy has the right balance of inflation and unemployment. c. the goods market and money market are both...