Answered: 3. Write the transaction log using…

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

Concept explainers

Question

3. Write the transaction log using Table 10.1 from the textbook as your guide. Assume that product ‘ABCD’ has a PROD_QOH = 1,214 at the start of the transaction and that the transaction is representing the addition of 1 new product. Also assume that PART components “AAAA”, “BBBB”, “CCCC” and “DDDD” have a PROD_QOH equal to 547, 108, 249, and 89 respectively.

4. Using the transaction log you created in Step 3 above, trace its use in a database recovery. Do this in a similar table format (see Table 10.16 in book) by backing out each transaction and resetting the BEFORE and AFTER values accordingly. Begin with the last id for the transaction and work backward using the prev_ptr to identify the next step to undo moving from the end of the transaction back to the beginning.

ACTION ITEMS
Suppose you are a manufacturer of product ABCD, which is composed of parts AAAA, BBBB,
CCCC and DDDD. Each time a new product is created, it must be added to the product
inventory, using the PROD_QOH in a table named PRODUCT. And each time the product
ABCD is created, the parts inventory, using PART_QOH in a table named PART, must be
reduced by one each for parts AAAA, BBBB, CCCC and DDDD. The sample database contents
are shown below for these items:
Tablename: PRODUCT
Tablename: PART
PROD_QOH
1,214
PROD_CODE
PART_CODE
PART_QOH
АВCD
AAAA
547
BBBB
108
CCCC
249
DDDD
89

Expert Solution

Trending now

This is a popular solution!

Step by step

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