6. Study the following block, and answer the questions below: (a) What are declared in the package specification? (b) What information can you get from the function ck.tax.pp? (c) What is the name of the table referred in the block? (d) Create a PL/SQL block that uses the function. 1 CREATE OR REPLACE PACKAGE tax_pkg IS CURSOR peur_tax IS SELECT state, taxrate FROM bb_tax; FUNCTION ck_tax_pp 3 4 (p_state IN CHAR) RETURN NUMBER; END; 10 CREATE OR REPLACE PACKAGE BODY tax_pkg IS FUNCTION ck_tax_pp 11 12 13 14 (p_state IN CHAR) 15 RETURN NUMBER 16 IS lv_tax_num NUMBER ( 3, 3) := 0; 17 18 BEGIN 19 FOR pcur_rec IN pcur_tax LOOP IF pcur_rec.state = p_state THEN lv_tax_num := pcur_rec.taxrate; RETURN lv_tax_num; 20 21 22 23 EXIT; 24 END IF; 25 END LOOP; END; END; 26 27

6. Study the following block, and answer the questions below: (a) What are declared in the package specification? (b) What information can you get from the function ck.tax.pp? (c) What is the name of the table referred in the block? (d) Create a PL/SQL block that uses the function. 1 CREATE OR REPLACE PACKAGE tax_pkg IS CURSOR peur_tax IS SELECT state, taxrate FROM bb_tax; FUNCTION ck_tax_pp 3 4 (p_state IN CHAR) RETURN NUMBER; END; 10 CREATE OR REPLACE PACKAGE BODY tax_pkg IS FUNCTION ck_tax_pp 11 12 13 14 (p_state IN CHAR) 15 RETURN NUMBER 16 IS lv_tax_num NUMBER ( 3, 3) := 0; 17 18 BEGIN 19 FOR pcur_rec IN pcur_tax LOOP IF pcur_rec.state = p_state THEN lv_tax_num := pcur_rec.taxrate; RETURN lv_tax_num; 20 21 22 23 EXIT; 24 END IF; 25 END LOOP; END; END; 26 27

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter7: Introduction To Structured Query Language (sql)

Section: Chapter Questions

Problem 13P: Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose...

See similar textbooks

Similar questions

Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT. b.Copy the matching EMP_2 values into the TEMP_1 table.
36-Create a SQL statement of a read-only view, name it as ViewE, that will contain Gender and the number of clients per gender in the CLIENTS table.
(a) What SQL statement would you use to create the table ”staff”, including specifying the primary key? (b) What SQL statement would you use to find out how many lecturers there are in the School of Computing? (c) What SQL statement would you use to list the lecturers of the modules COMP1121 and COMP1211? (d) Write an SQL statement, using the inner join construct, that will, for the lecturer John Smith, list in alphabetical order the students taking any module which he teaches. (e) What information does the output from the following SQL query provide? SELECT Lecturer, COUNT(DISTINCT Student) FROM class INNER JOIN staff ON class.Module = staff.Module WHERE Grade < 40 GROUP BY Lecturer; (f) Write an SQL query which would obtain the following information: for each lecturer, what is the average grade obtained by students across all of the modules which they have taught?
Hi, This is what I have, but I am stuck with what to write and not sure if my function is even correct, to begin with. Can someone show me a walk-through solution? Please read all directions and don't just apply any SQL syntax as I must use postgreSQL. MUST USE postgreSQL - LANGUAGE plpgsql The tables instructor and teaches have been created as I am working with an existing database. (SEE SCREENSHOT WITH TABLES) CODE CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25)); CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25))LANGUAGE plpgsqlAS$$BEGINSELECT name INTO instructor_course_nums FROM instructorWHERE ID = instructor.ID;SELECT COUNT(*) INTO instructor_course_nums FROM teachesWHERE instructor_course_nums.ID = teaches.ID;END;$$;
1) a. Explain the concept of ACID properties in DBMS in your own words? b. How is the pattern matching done in the SQL? c. Identify and with practical examples give the different types of languages that are available in the DBMS?
(a) Write the sql syntax to create a table name customer with the following restrictions;Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname and occupation do not accept null values.Payment_mode accepts only cash or credit entries.The default address is “Flacq”.customer is at least 18 years old.Salary is above Rs 25000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). ii. Write the SQL query to display the cid and gender of all employees. iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000. iv. Write the SQL query to set the salary of all administrators to Rs 50 000. v. write the SQL query to display details of customers whose names start with character 'e'. vi. Write the SQL code…
(a) Write the sql syntax to create a table name customer with the following restrictions;Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname and occupation do not accept null values.Payment_mode accepts only cash or credit entries.The default address is “Flacq”.customer is at least 18 years old.Salary is above Rs 25000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). ii. Write the SQL query to display the cid and gender of all employees.iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000.
1.10) As being a sub language of SQL, DML has select, insert, update, and delete operationsTrue False 1.11) SQL does not support creating or deleting database object and granting or revoking access rightsTrue False 1.12) Common Table Expression (CTE) is only used to develop recursive SQL queriesTrue False 
demonstrate how to connect to a sqlite database. HOW TO SUBMIT YOUR ASSIGNMENT At the top of each of your C++ programs, you should have at least four lines of documentation: Program name (the C++ file name(s)), Author (your name), Date last updated, and Purpose (a brief description of what the program accomplishes). Here is an example: /* Program name: jbtictactoe.cpp* Author: John Doe* Date last updated: 5/1/2017* Purpose: Play the game of Tic-Tac-Toe*/ ASSIGNMENT: Database Connection Fact Database ER Diagram Write a program that opens a connection to the FACT database factdb.db Download factdb.db. If the connection doesn't open successfully print an error message from the database and end the program, otherwise print a success message. Then use a callback function to print the results of a select query (any select query of your choice) and close the database. To submit your assignment: Submit your source code file (*.cpp)
Hey experts, please help me out on this :( xx Sample database: For all the implemented tasks, your report or output must include a listing of all PL/SQL statements processed. To achieve that put the following SQL*Plus commands in all your scripts:SPOOL file-nameSET ECHO ONSET FEEDBACK ONSET LINESIZE 100SET PAGESIZE 200SET SERVEROUTPUT ONat the beginning of SQL script andSPOOL OFFat the end of SQL script.
Answer the following questions 1.Explain by using a practical scenario what the difference between a variable and a parameter are. 2. Using a practical scenario explain the difference between Desktop databases and Server Databases. 3. You have been hired as a Database Developer and you have been given the option to use a trigger and a procedure. When would it be best to use procedures? 4. Write a SQL statement that will create a database named Namibian_Team that will store data for all sporting events represented in the country using the Master database in MS SQL Server. 5. As a database developer, you have to explain with visual representations the difference between a logical design and a physical design
Practice Question 1. Assume that the Users table has a plenty of records but only three colums: UserID, FirstName and LastName. Write the following: a) Write an SQL query to show the top 5 records of the Users table. (in order to test it populate your table with more than 5 records) in the PHP file and to display the result in well-readable format (table preffered) in the browser using parameters. b) Write a SQL query in the PHP file that will print details of all users excluding those with the FirstName “Will” and “Michael” from the Users table and to display the result in well-readable format (table preffered) in the browser using parameters. Hint: you can either write all your code in the same file or use two different files

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

SEE MORE TEXTBOOKS