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

Related questions

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Name of the procedure - ADD_INVOICE Name of relation - INVOICES Suppose datatype of INVOICE_NUM,…

Q: Task 7: Create a view named INVOICE_TOTAL. It consists of the invoice number and invoice total for…

A: Actually, database is a used to stores the data\information.

Q: Computer Science Establish the input, processing, and output of airline and hotel reservation…

A: Establish the input, processing, and output of airline and hotel reservation credit card…

Q: What happens to the data displayed by a view when the view is deleted?

A: Nothing will happen to the data displayed by a view, if the view is deleted.

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table: INSERT INTO OWNER…

Q: Some rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902…

A: Names and phone numbers are among the details about different users that are included in the User…

Q: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…

A: It enables to save query with a name so that it can be executed whenever required rather than…

Q: Write a script that creates and calls a stored procedure named insert_category. First, code a…

A: The question requires us to write a script that creates and calls a stored procedure named…

Q: Consider the following TWO relations: Instructor(ID, name, dept_name, salary) Teaches (ID,…

A: SQL stands for Structured Query Language.

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: Create the ADD_INVOICE procedure to add rows to the INVOICE table. (

A: A SQL Procedure is created by writing the keyword "CREATE PROCEDURE" then procedure name i.e.,…

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Attached handwritten Image of the procedure to add a row to the INVOICES table.

Q: When should you use the %ROWTYPE attribute in creating a record variable? Answers: a. when using…

A: Required: when use %ROWTYPE

Q: Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: Views in SQL correspond to a virtual table consisting of rows and columns. It represents result set…

Q: firstthree (my_seqid in varchar2) as cursor c1 is select sname, grade from student s join…

A: Below are the steps needed

Q: Task 9: Create the DISP_PROPERTYS procedure to retrieve and output the office number, address,…

A: Given Procedure name is DISP_PROPERTYS Suppose the relation name is PROPERTY and the attribute…

Q: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…

A: We need to create an UPDATE_INVOICE procedure to change the date of the invoice whose number is…

Q: Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of…

A: We need to Create a view named MONTHLY_RENTS from PROPERTY table CREATE VIEW MONTHY_RENTS AS…

Q: Q2:Write a row-level trigger that executes before updating a project’s location in the project…

A: The question is to write the SQL query for the given problem.

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

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.

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

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 4 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

which of the following operator is not specified in triggers? 1. insert 2. Alter 3. update 4. Delete
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.
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