Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 7, Problem 7.22PAE
Program Plan Intro
a. The balance that will be included for the customer after the last transaction was completed.
Program Plan Intro
b. Correct balance included for the customer after three transactions have been processed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Database Systems
Each branch of the Jaja restaurant has a mainstay menu that is very popular with customers, so information on the availability of the number of servings is needed to be able to serve orders. Here are two transactions that are ordering a food menu at the same time.
T1: Start the transaction at time t1, read 10 servings of food stock at t2. Because ordering one portion, the stock is reduced by 1 at t3. On t6, update the stock count, and commit to t7.
T2: Transaction T2 starts a transaction on t2, reads the number of stocks in t3 as many as 10. At t4 orders 3 portions. On t5 it updates the stock to 7 and then on t6 commits it.
As a result of the T1 and T2 transactions above, there was an error in the amount of food stocks. Make a solution with 2PL. What kinds of problems happened? Give a reason why choosing this type of problem! How much food is still available?
In the problem below, x and y are local application program values Read( ) and Writel ) fetch and stored the
persistent values in a database. The database values are read / written by two different transactions. The time
sequence of these operations is shown in the table below. You cannot change the time sequence.
Take the initial values of x and y to be x = 4, y = 2.
a) In this nart the transactions are operating with isolation level READ UNCOMMITTED (no locks)
Time
Transaction 1
Transaction 2
Read(y)
y=y+5
2
Read(y)
y=y+ 10
3
4
Write(y)
Read(x)
7
Read(x)
8
X=x+ y:
Write(y)
Commit
9.
10
11
x=x+y
Write(y)
12
13
Commit
For the execution order shown above, what are the final values of x and y?
Answer: x=
b) There is a problem with the interleaved execution plan for these transactions.
What is the problem, i.e., which concurrency problem does this demonstrate?
Answer:
c) Rewrite the sequence of operations using the standard technique for dealing with concurrency
problems of this type for…
To access a database, we need to open a connection to it first and close it once our job is done. Connecting to a database depends on the type of the target database and the database management system (DBMS). For example, connecting to a SQL Server database is different from connecting to an Oracle database. But both these connections have a few things in common: •They have a connection string •They can be opened•They can be closed•They may have a timeout attribute (so if the connection could not be opened within the timeout, an exception will be thrown).Your job is to represent these commonalities in a base class called DbConnection. This class should have two properties: ConnectionString : stringTimeout : TimeSpanA DbConnection will not be in a valid state if it doesn’t have a connection string. So you need to pass a connection string in the constructor of this class. Also, take into account the scenarios where null or an empty string is sent as the connection string. Make sure to…
Chapter 7 Solutions
Modern Database Management
Ch. 7 - Prob. 7.1RQCh. 7 - Prob. 7.2RQCh. 7 - Prob. 7.3RQCh. 7 - Prob. 7.4RQCh. 7 - Describe the advantages and disadvantages of...Ch. 7 - Describe the common components needed to create a...Ch. 7 - What are the six common steps needed to access...Ch. 7 - Prob. 7.8RQCh. 7 - Prob. 7.9RQCh. 7 - Prob. 7.10PAE
Ch. 7 - Prob. 7.11PAECh. 7 - Prob. 7.12PAECh. 7 - Prob. 7.13PAECh. 7 - Find some dynamic Web site code, such as that...Ch. 7 - Prob. 7.15PAECh. 7 - Prob. 7.16PAECh. 7 - Prob. 7.17PAECh. 7 - Consider the example code shown in Figure 7-10....Ch. 7 - Prob. 7.19PAECh. 7 - Prob. 7.20PAECh. 7 - Prob. 7.21PAECh. 7 - Prob. 7.22PAECh. 7 - Prob. 7.23PAECh. 7 - Prob. 7.24PAE
Knowledge Booster
Similar questions
- 15 Suppose that Distributed Database System(DDB) has three sites; Sitel:Students table: 1000 rows, 10 Byte row size, Site2: Grades table: 2000 rows, 50 Byte row size, and Site3: Request a query with the result 100 rows, 30 bytes row size; What is the amount of data transfer in bytes after processing the following strategy(Transfer Student table and Grades table to site 3)7 Note: (insert only final result(number) without the equation) Enter your answerarrow_forwardIn a relational database, a select operation reduces the size of a table by removing columns that meet certain requirements.Is it accurate or inaccurate?arrow_forwardA File was sorted by key field, and then 10 records were stored in each block. Multi-level Indexing is made here, and 100 indexes are stored in each block. To find a specific record, the total number of block accesses is less than 4. Calculate the maximum number of records that make up this file.arrow_forward
- Answer the following prompts 1The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. 2The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID…arrow_forwardWrite a Java or PHP program that connects to a MySQL database and fetches all records from the Doctor relation (see appendix) and prints out the records in tabular form, with appropriatenames as column headings.arrow_forwardAssume you have a database table with 10,000 records and you want to retrieve all records that satisfy a certain condition using a binary search algorithm. On average, how many comparisons would be needed to retrieve all the records?arrow_forward
- The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.arrow_forwardThe InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team. Create a new table to store car maintenance types.arrow_forwardPLZ HELP WITH THE FOLLOWING: We will assume that the Computer Science Department at a university has an agreement with the publishers to allow faculty and students to have free exclusive access to the e-books online through their website. They need you to design a database for them using the following business rules: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have never been checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book…arrow_forward
- In a relational database, a select operation reduces the size of a table by eliminating columns that meet specified specifications.Is this statement accurate or incorrect?arrow_forwardQuestion Completion Status: QUESTION 23 The first readers-writers problem OA) requires that, once a writer is ready, that writer performs its write as soon as possible OB) is not used to test synchronization primitives OC) requires that no reader will be kept waiting unless a writer has already obtained permission to use the shared database OD) requires that no reader will be kept waiting unless a reader has already obtained permission to use the shared database QUESTION 24 What is the correct order of operations for protecting a critical section using mutex locks? OA) release () followed by acquire() OB) acquire () followed by release () OC) wait () followed by signal () OD) signal () followed by wait () Click Save and Submit to save and submit. Click Save All Answers to save all answers. Search 喝苦arrow_forwardDescribe the concept of "lazy loading" in the context of database connectivity.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education