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.it updates 1 row, changes code to 9 from 8it deletes 1 row from jobs where code=8This results into an error since value for id column is not supplied in the insert query. This is because primary key cannot be null. Hence 0 rows are affected.

Engineering

Computer Science

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
Task 5: Write and execute the command to retrieve the item ID, description, invoice number, and quoted price for all invoices in the ITEM_INVOICE VIEW for items with a quoted prices that exceed $100.
When a view is removed, what happens to the data it displayed?
10
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 9: Create the DELETE_INVOICE procedure to delete the invoice whose number is stored in I_INVOICE_NUM.
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