Hidden tasks performed by DBMS when users update and retrieve data.

Question

Want to see more full solutions like this?

Answer 1

Question

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Please answer the JAVA OOP Programming Assignment scenario below: Patriot Ships is a new cruise line company which has a fleet of 10 cruise ships, each with a capacity of 300 passengers. To manage its operations efficiently, the company is looking for a program that can help track its fleet, manage bookings, and calculate revenue for each cruise. Each cruise is tracked by a Cruise Identifier (must be 5 characters long), cruise route (e.g. Miami to Nassau), and ticket price. The program should also track how many tickets have been sold for each cruise. Create an object-oriented solution with a menu that allows a user to select one of the following options: 1. Create Cruise – This option allows a user to create a new cruise by entering all necessary details (Cruise ID, route, ticket price). If the maximum number of cruises has already been created, display an error message. 2. Search Cruise – This option allows to search a cruise by the user provided cruise ID. 3. Remove Cruise – This op…

23 } 24 ain.cpp // Tasks: C tot Shore Run Task 1: Create a class "Student" with attributes name, age, and grade. Add methods to set and get these values. Task 2: Implement a class "BankAccount" with deposit and withdraw methods, ensuring balance does not go negative. Task 3: Develop a class "Circle" that calculates its area and circumference given the radius. Task 4: Implement a class "Book" that stores title, author, and price, and allows updating and displaying book details

42 व 2 = 16 25 32-5 Subnetting = 27 Problem 8 Number of needed subnets 5 Network Address 172.50.0.0/27 Address class B Default subnet mask 255.255.0. . Custom subnet mask 255.255.255.229 Total number of subnets Total number of host addresses Number of usable addresses Number of bits borrowed 3 8122 8120 What is the 4th subnet range? What is the subnet number for the 5th subnet? What is the subnet broadcast address for the 6th subnet? What are the assignable addresses for the 3rd subnet?

Answer 2

Question

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Question

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Question

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.

Answer 6

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.

Answer 7

Chapter 7, Problem 1RQ

To determine

Hidden tasks performed by DBMS when users update and retrieve data.

Answer 8

Expert Solution & Answer

Explanation of Solution

A DBMS is of no use to any user if it's not capable of providing some functions. Updation and retrieval are the fundamental job of a DBMS. Thus, a DBMS must provide to its users the ability to perform same. These tasks are solely the responsibility of a DBMS and a user needs not be aware of them.

The general steps followed in almost all operations are in diagram below:

EBK CONCEPTS OF <x-custom-btb-me data-me-id='1521' class='microExplainerHighlight'>DATABASE</x-custom-btb-me> MANAGEMENT, Chapter 7, Problem 1RQ

An operation contains instructions given by users and some tasks that are performed at the backend.

The difference usually occurs at step 2 and 3 where more than one sub operations might be needed to complete the task.

An updation operation can be performed by a user in the following way: by adding a new record, changing an existing records or it's deletion. All these consist of some instructions given by user and some task performed by DBMS.

Updation:

1. adding new records:

User enters an item and requests the DBMS to add a new item into database.

Following tasks are performed by DBMS following the request:

It checks whether the records already exist in Database
If not, it creates a new record and adds it to the database.
Informs the user that the operation is complete, and the record is now a part of the database.

2. Changing a record:

User requests the DBMS to change an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be changed.
It displays the current data to user so that new value can be provided for changing.
It changes the value as soon as new value is provided.

3. Deleting a record:

User requests the DBMS to delete an item from the database.

Following tasks are performed by DBMS following the request:

It reads the data from database that needs to be deleted.
It displays the current data to user so that user is able to see what will be deleted.
It deletes the value as soon as user confirms the deletion action.

Retrieval:

A user is capable of reading a value from database. Following are the steps performed by DBMS to complete the operation:

It finds and reads the record from database
It displays the record to user

Thus, an operation consists of both the task done by a user and the tasks performed by a user. The DBMs is fully capable of performing these sub tasks at backend without the user being aware of it.