- Happy And Health Furniture Is A Company Making Different Furniture They Plan To Build A Database To Keep Track The Inve 1 (60.05 KiB) Viewed 31 times
Assume the number of Table to be added is 45
**Assume that the database starts with the values in the given
tables above. Write the transaction log for adding new
highchairs and then new tables in the
database, using template given below. The number of
highchairs to be added is according to the following formula:
TRL
ID
TRX
NUM
PREV
PTR
NEXT
PTR
OPERATION
TABLE
ROW
ID
ATTRIBUTE
BEFORE
VALUE
AFTER
VALUE
1
1A3
NULL
2
START
**START
TRANSACTION
2
1A3
1
3
3
1A3
2
4
4
1A3
3
5
5
1A3
4
6
6
1A3
5
7
7
1A3
6
8
8
1A3
7
9
9
1A3
8
10
10
1A3
9
NULL
COMMIT
** END
TRANSACTION
Happy and Health Furniture is a company making different furniture. They plan to build a database to keep track the inventory of the furniture they made and the stock of the parts. Each furniture is made of different parts. Each time a new furniture, for example a highchair, is created, the inventory needs to be updated. The PROD QOH (Quantity on Hand) in PRODUCT table needs to be added as it records the number of each furniture. The Part_QOH in PART table needs to be reduced for the used parts as it records the number of each part. For example, 1. one highchair needs 3A, 2B and 1C to make 2. one table needs 4A, 1B and 2C to make Table name: PRODUCT Table name: PART PART_CODE PROD CODE Highchair Table PROD_QOH 43 A PART QOH 878 736 655 5 B с