The image shows a MySQL database query example with two tables: "employees" and "jobs." Tables:1. **employees**: Contains columns id (primary key), name, and job_code (foreign key referencing the jobs table).2. **jobs**: Contains columns code (primary key), title, and salary.### Employees Table Data:- **Columns**: - `id`: Employee identifier (integer). - `name`: Employee name (string). - `job_code`: Code referencing job titles (integer).- **Data**: ``` +----+---------------+----------+ | id | name | job_code | +----+---------------+----------+ | 1 | Captain Hook | 1 | | 2 | Tiger Lily | 1 | | 3 | Pocahontas | 1 | | 4 | Meeko | 4 | | 5 | Woody | 1 | | 6 | Flik | 3 | | 7 | Dot | 3 | | 8 | Sofia, the First | 3 | | 9 | Scully | 1 | | 12 | Olaf | 4 | | 14 | Aladdin | 3 | | 18 | Eeyore | 1 | | 19 | Pooh | 1 | | 20 | Piglet | 3 | | 25 | Scrooge | 1 | +----+---------------+----------+ ```- **Query**: ```sql SELECT * FROM employees; ```- **Output**: 15 rows returned, showing a list of employees' names paired with their respective job codes.### Jobs Table Data:- **Columns**: - `code`: Job code identifier (integer). - `title`: Job title (string). - `salary`: Salary for the job (decimal).- **Data**: ``` +------+---------+--------+ | code | title | salary | +------+---------+--------+ | 1 | author | 100.50 | | 2 | editor | **Database Operation Exercise**The table displayed represents a list of employees with their corresponding job title and salary. The table includes the following columns: `id`, `title`, and `salary`. Here are the entries:```+------+---------+--------+| id | title | salary |+------+---------+--------+| 1 | author | 100.50 || 2 | editor | 200.00 || 3 | manager | 150.00 || 4 | student | 0.00 || 8 | CFO | 250.00 |+------+---------+--------+```The exercise below is about understanding SQL commands and identifying how many rows each command affects. If a command causes an error, the number of affected rows is considered to be zero.**Commands:**a) `DELETE FROM employees WHERE id = 3;` - This command deletes the row where `id` is 3.b) `UPDATE jobs SET code = 9 WHERE code = 2;` - This command updates the rows in the `jobs` table, setting `code` to 9 where the current `code` is 2.c) `DELETE FROM jobs WHERE code = 8;` - This command deletes rows from the `jobs` table where the `code` is 8.d) `INSERT INTO employees (name, job_code) VALUES ('Pluto', 10);` - This command inserts a new employee with the name 'Pluto' and `job_code` 10 into the `employees` table.For each of the above commands, determine how many rows are affected and note your answer in the provided selection box.

It deletes 1 row from table employee where id is 3.

For each of the following commands, how many rows are affected (updated, deleted, or inserted)? If the command causes an error, the number of affected rows is 0 (zero). a) DELETE FROM employees WHERE id = 3; [ Select ] 9 WHERE code = 2; [ Select] b) UPDATE jobs SET code %3D [ Select ] 8; %3D c) DELETE FROM jobs WHERE code d) INSERT INTO employees (name, job_code) VALUES ('Pluto', 10); IColect1

For each of the following commands, how many rows are affected (updated, deleted, or inserted)? If the command causes an error, the number of affected rows is 0 (zero). a) DELETE FROM employees WHERE id = 3; [ Select ] 9 WHERE code = 2; [ Select] b) UPDATE jobs SET code %3D [ Select ] 8; %3D c) DELETE FROM jobs WHERE code d) INSERT INTO employees (name, job_code) VALUES ('Pluto', 10); IColect1

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

Similar questions

which of the following operator is not specified in triggers? 1. insert 2. Alter 3. update 4. Delete
q9
SQL
•We have to enter data to the employ class. • Add 3 TextView •Add 3 Edittext View to get input from user. •Add button. •Delete Button •Select Button •Update Button
I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES table that will set the commission amount to .4 whenever the department_id is 80. Test your trigger COMPLETELY for every event it is defined. (Sometimes, UPDATE statements must have UPDATE tablename on a separate line by itself to keep APEX from hanging). This should work both for new rows and existing rows that are updated. Scenerio: All employees who are in the sales department (80) will have their commission always set to .4. This trigger is to enforce this business rule automatically.
Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission rate from the commission for the corresponding sales rep.
Task 5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT.
Task 9: Create the DELETE_INVOICE procedure to delete the invoice whose number is stored in I_INVOICE_NUM.
Create Trigger for When a student marks are being inserted, if the marks that are inserted are greater than 50, allow the insertion, but update marks to 50. Marks(Id , Marks) -> Table Fill in the blanks: ___ triggerName Before ___ ON Marks REFERENCING _____ AS nrow FOR EACH ROW WHEN (nrow.marks>50) _____ nrow SET nrow.marks = 50;
Write a SELECT statement that returns the following columns from the PRODUCT_INFORMATION table. Sort the results by PRODUCT_ID in ascending order. 1. PRODUCT_ID 2. PRODUCT_NAME 3. LIST_PRICE ○ Use the TO_CHAR function to convert LIST_PRICE to a character string with the currency formatting Give this field an alias of PRICE
part A Attempt to violate the primary key constraint and observe the result. part B Attempt to violate the foreign key constraint and observe the result