BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 10, Problem 7P
Textbook Problem
1271 views

Create a simple transaction log (using the format shown in Table 10.14) to represent the actions of the transactions in Problems 6a and 6b.

Program Plan Intro

Transaction log:

It is a feature used by the DBMS (Database Management System) software to keep track all of the information that contains a description of all database transactions executed by the DBMS. This transaction plays the major role for database maintenance.

Explanation of Solution

Transaction log to represent the actions of the transactions in Problems 6a and 6b:

The “Trans_Num” used to represent transaction number. The transaction number “T1” used to demonstrate the problem “6a” and “T2” used to demonstrate the problem “6b”.

Trans_ID Trans_Num Prev_ptr Next_ptr Operation Table Value_ID Attribute Before_trans After_trans
1 T1 NULL 2 START **START TRANSACTION
2 T1 1 3 INSERT INVOICE 1098310983, 10010,11-May-2018, 118.80, 30, OPEN
3 T1 2 4 INSERT LINE 10983,110983, 1, 11QER/31, 1, 110.00
4 T1 3 5 UPDATE PRODUCT 11QER/31 P_QTYOH 47 46
5 T1 4 6 UPDATE CUSTOMER 10010 CUS_BALANCE 345.67 464.47
6 T1 5 7 UPDATE CUSTOMER 10010 CUS_DATELSTPUR 5-May-14 11-May-18
7 T1 6 NULL COMMIT **END TRANSACTION
8 T2 NULL 9 START **START TRANSACTION
9 T2 8 10 INSERT PAYMENT 34283428, 3-Jun-2018, 10010, 100.00, CASH, None
10 T2 9 11 UPDATE CUSTOMER 10010 CUS_BALANCE 464.47 364...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 10 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
How do you translate business rules into data model components?

Database Systems: Design, Implementation, & Management

What is the difference between an included angle and a centerline angle?

Precision Machining Technology (MindTap Course List)

Identify the six basic components of any computer-based information system.

Principles of Information Systems (MindTap Course List)

What is the major difference between an indicator lamp and a warning light?

Automotive Technology: A Systems Approach (MindTap Course List)

For problems 15.33 through 15.40, go through each line of MATLAB code and show the result, or indicate if an er...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

What is stored in the data dictionary?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

List the things that should be inspected on a ladder.

Welding: Principles and Applications (MindTap Course List)