EMPLOYEEFK: EmpIDSupervisorFK: PROJECT.Proj IDProject IDPKNameJohnsonEmpIDAddressSalary1LR7000021002.LeeLR80000100ParkHopsonKant3NLR900008200450000NLRCWY53005600008300ParkCWY120000300....-...PROJECTPKStartDate11/21/02ProjIDEndDate11/20/0310/30/024/27/0412/30/03PNameB11Budget1000000100900000950000800000200B129/1/01300B133/28/03400C148/1/03-.. (Data Update)7) Write SQL statements to increase by 100000 the budget of the project whose nameis starting with 'B'.48) Write SQL statements to delete the rows for the LR (Little Rock) employees whoare under the supervision of supervisor 8.

I have answered both the parts and you can directly copy from here to run on your terminal. In…

7) Write SQL statements to increase by 100000 the budget of the project whose nam is starting with 'B'. e 4 8) Write SQL statements to delete the rows for the LR (Little Rock) employees who are under the supervision of supervisor 8.

7) Write SQL statements to increase by 100000 the budget of the project whose nam is starting with 'B'. e 4 8) Write SQL statements to delete the rows for the LR (Little Rock) employees who are under the supervision of supervisor 8.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: This is a database system question regarding SELECT: Which of the following statements is true for…

A: The above question is solved in step 2:-

Q: Student Name: Student Number: Write a PL/SQL Program to do the following Your Program should request…

A: Answer is given below-

Q: Using SQL Write a function called ValidSupplier(SupplierID) that takes as its only input a…

A: The ask is to write a SQL function which does the following: - take a Supplier Id as input - Check…

Q: You should use an Oracle function to determine how many days have transpired between your birthday…

A: Oracle functions can be accessed through different SQL queries built within the Oracle Database.…

Q: Q1 Write a program in PL/SQL to print a list of names employees and the names of the departments to…

A: Textual PL/SQL Code :- -- create a table --CREATE TABLE Employees ( id INTEGER PRIMARY KEY, Name…

Q: | 7. Which one of the following should be specified in the statement if an SQL SELECT statement…

A: As you have multiple questions here we will solve the first one for you if you want any specific…

Q: Write a PL/SQL code to print 'PASS' if the student has scored above 40. Choose an answer A declare…

A: C is the correct option Declare m number:= 80;begin if m>40 dbms_output.put_line('Pass') ; end…

Q: table name: Accounts columns: account_num char(9) which is the primary key name varchar (20)…

A: SQL: CREATE TABLE Accounts ( account_num char(9) PRIMARY KEY, namevarchar(20), balance double );…

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: The given PL SQL program uses a cursor to process a multi-row query. A cursor is a work area which…

Q: Suppose a database in SQL write IF THEN ELSE Statement in PL SQL Block to check if the quantity in…

A: IF Product 2319.QuantityOnHand <= 120 THEN MESSAGE 'Stock is getting less.'; ELSEIF Product…

Q: Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: QI/ By Using the following schema, answer the following SQL queries and commands:…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Online shopping system & online book store: Rebuild View/Edit cart and checkout pages using PL/SQL…

A: {"generalGuidance"::"sections":[{"sectionId":"50c4cd6a-2383-4c53-b65d-4c2b1304a00d","title":"","text…

Q: What will be displayed when the following SQL statement is executed? SELECT * FROM Employee: Group…

A: Introduction: SELECT: The select statement in SQL is used to select data from the database. The data…

Q: ***Using SQL*** Assume you have a table as follows table name: Accounts columns: account_num char(9)…

A: Find the answer given as below :

Q: 4) Write a PL / SQL block to display the details of clients who have made a loan with an amount more…

A: Please find answer to the above question below:

Q: It's best to utilize an Oracle function to determine how many days have passed since your birthday.

A: Introduction: Oracle functions may be accessed through different SQL queries and are built within…

Q: use the picture below (the data has been shown) to create a sql statement that will enter the…

A: To create a SQL statement to enter the record into the table named PART. The attributes of the…

Q: 3.Write a program in PL/SQL to display sum of odd numbers from 1 to n.

A: CODE: DECLARE num NUMBER(3) := 1; tot NUMBER(4) := 0; BEGIN dbms_output.Put_line('Odd numbers…

Q: You should use an Oracle function to determine how many days have transpired between your birthday…

A: Oracle's date functions may be characterized as a collection of functions that work on dates and…

Q: Guideline: Pls create employees table and populate it with the scripts provided for you (if the…

A: Answer: Our instruction is answer the first three part from the first part and I have given SQL…

Q: Write the following PSM functions or procedures a) Take a price as argument and return the model…

A: Sample data:- The sample data for relations of question 1. These data are not used tocalculate…

Q: 4a) Write an SQL command that will create Customer table which shown in below. Customer custID…

A: Hello Student Greetings Hope you are doing great. I will try my best to answer your question. Thank…

Q: IN SQL ** 1- Write a query clause to display the internal structure of the departments table, then…

A: As per our guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: Write SQL queries for the following statements. 1) Write a stored procedure which takes an integer…

A: Create proc using create command Create a variable as input parameter Declare incrementation…

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: Ans:) In this PL/SQL block there are some errors in the syntax. The correct syntax for the…

Q: DEFAULT STORAGE (INITIAL 500K NEXT 200K MAXEXTENTS 20 PCTINCREASE 15) Excel's Future Value financial…

A: The EXCEL financial function FV (rate, nper, pmt, [pv], [type]) can be used to calculate extent size…

Q: Write SQL queries for the following database: id Customers name email Categories id name id…

A: Since there are multiple parts to a single question, the first three subparts are answered for you.…

Q: 1) Write the SQL code that will create the table structure for a table named EMP. This table is a…

A: For auto generated id's we have to start from 101 and increment by 1 For checking JOB_CODE we can…

Q: Part I: Problem 1. Write a stored procedure that adds a new employee to lgemployee table. Pass the…

A: A stored procedure is a program that you can create in the Database and also it have different…

Q: 2) Create in PL/SQL a stored procedure called 'Del Details' to delete the record of orderedProduct…

A: 2. The SQL query is given below: CREATE PROCEDURE [dbo].[Del Details] -- Add the parameters for the…

Q: IN SQL ** Write a query sentence to display the names, jobs, dates of appointment and employee…

A: Given Columns to display: name, job, appointmentDate,empNo Condition: First column has to be empNo…

Q: 17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine',…

A: Using self join between these two table we will get the results for George and Lorraine and to…

Q: Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit)…

A: A Sales Database consisting of three tables: Customers, Orders, and Items. The table structures and…

Q: Instructor (Instructor_Id, Instructor_Name, specialization, Address, #Department_Id) Write in…

A: First we have to create a table Instructor with details such as Instructor_name, Specialization,…

Q: QUESTION Given the sample of the GPADatabase in a file, write SQL Stored function called…

A: Steps to create a SQL stored function to calculate the semester GPA: Step – 1: Connect to your SQL…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: It's best to utilize an Oracle function to determine how many days have passed since your birthday.

A: Step 1 A server-less platform called Oracle Functions allows developers to design, execute and grow…

Q: From the Salesman and Customer tables below, write SQL statements to do th following: a) List the…

A: Actually, SQL stands for Structured Query Language.

Q: NFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in…

Question

EMPLOYEE
FK: EmpID
Supervisor
FK: PROJECT.Proj ID
Project ID
PK
Name
Johnson
EmpID
Address
Salary
1
LR
70000
2
100
2.
Lee
LR
80000
100
Park
Hopson
Kant
3
NLR
90000
8
200
4
50000
NLR
CWY
5
300
5
60000
8
300
Park
CWY
120000
300
....
-...
PROJECT
PK
StartDate
11/21/02
ProjID
EndDate
11/20/03
10/30/02
4/27/04
12/30/03
PName
B11
Budget
1000000
100
900000
950000
800000
200
B12
9/1/01
300
B13
3/28/03
400
C14
8/1/03
-..

(Data Update)
7) Write SQL statements to increase by 100000 the budget of the project whose name
is starting with 'B'.
4
8) Write SQL statements to delete the rows for the LR (Little Rock) employees who
are under the supervision of supervisor 8.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

The following is a table of applicants to be considered for admission into 07BSAM: POINTS MATH SYMBOL 123 450 NAMES STUDENT NUMBER ENG SYMBOL To qualify for admission, an applicant should have at least 25 points, minimum of B symbol in Mathematics and a minimum of E symbol in English. If an applicant has a C symbol in Mathematics, then the applicant must pass an entrance test to be considered for admission. Hints: There are three modes of study: The Full-time mode, the Part-time mode and the Distance mode. Applicants can choose which mode they want provided there is space in that mode. Each of the Full- time and the Part-time modes cannot accommodate more 30 admitted students. After these two modes are full, every other qualified applicant is admitted in the Distance mode. The admission exercise is first come first served. Write a pseudocode that identifies the applicants that qualify for admission and outputs their names, student numbers and modes of study. Use a FOR-LOOP /…
• Data Manipulation Language (DML): Develop the following SQL statements: o UPDATE statements to mark any previously unavailable products as "shipped" and any orders not previously completely shipped as "completely shipped" Be sure to provide a rationale for your approach to the SQL statements. All sources, both in-text and in the References section, should be cited using APA format. N N N Orders -order_id [PK] (int) - customer_id [FK) (int) - date (datetime) - shipment_status (varchar) Products -product_id [PK] (int) -name (varchar) - description (varchar) -price (decimal) -vendor_id (int) Vendors -vendor_id [PK] (int) -name (varchar) - email (varchar) -address (varchar) Purchase Details -purchase_details_id [PK] (int) -purchase_id [FK) (int) -product_id [FK] (int) -quantity (int) -price (decimal) N N N N Customers customer_id [PK] (int) - name (varchar) - email (varchar) - address (varchar) N N Order Details -order_details_id [PK] (int) -order_id [F] (int) -product_id [FK] (int)…
Oracle sql Task 2: Write a function that returns how old a book is Published before 2000 ->Book X by author Y is an old book Between 2000 and 2020 -> Book X by author Y is modern 2020 and later -> Book X by author Y is recently published X: book name Y: author name
Database
Write the SQL statements to perform the following operations: a. Create a new course “CS-001”, titled “Weekly Seminar”, with 0 credits. b. Create a section of this course in Fall 2017, with sec id of 1, and with theclocation of this section not yet specified. c. Enroll every student in the Comp. Sci. department in the above section. d. Delete enrollments in the above section where the student’s ID is 12345. e. Delete the course CS-001. What will happen if you run this delete statement without first deleting offerings (sections) of this course? f. Delete all takes tuples (i.e., rows) corresponding to any section of any course with the word “advanced” as a part of the title; ignore case when matching the word with the title.
It is necessary to use an Oracle function in order to determine the number of days that have elapsed between your birthday and the current date.
Write SQL code for the following: Create a stored procedure “setRelocationFee” to set the relocation fee for a givenemployee. If the employee’s office is in San Francisco, the relocation fee is $10000; ifthe employee’s office is in Boston, the relocation fee is $8000; if the employee’s officeis in London, the relocation fee is $20000; if the employee works in other offices, therelocation fee is $15000. (see image for table structure) I am stuck for the part that I have to select employeeNumber and officeCode and set the relocationFee to be able to obtain the result but I do not know how. Bellow is what I have gotten. Delimiter| CREATE PROCEDURE setRealocationFee(IN EmployeeID INT(11), OUT realocationFee INT(5))
True or false, and briefly explain your answer to each of the following questions. When the window widths of both the transmitter and receiver are 1, the alternating-bit protocol and the SR protocol are identical.
You should use an Oracle function to determine the number of days since your birthday.
Create a function to insert a new product into an existing order, include the product id, unit price, quantity. The output of the function is the message to notify the calling program whether the update succeeded or not. note : Note: Sql code need not java don't waste my time by giving java code
If you write PL/SQL program contains a cursor; which of the following statements can be written inside the loop? Nots: You may have many answers. (2 Points) *: open x; close x exit when x%notfound; fetch x into rec13B x integer:=673; rec1 employees%rowtype;
You should use an Oracle function to determine how many days have transpired between your birthday and the present day.