Database management system exercise

- Suppose you are a car manufacturer. - A car is composed of the following parts: 4 tires, 1 body frame, and 1 engine. - Each time a new car is created, it must be added to the car inventory, using the PROD_QOH in a table named CAR. - At the same time, the parts inventory, using PART_QOH in a table named PART, must be reduced accordingly. - The sample database contents are shown below: Table name: CAR Table name: PART - Your task is to: - Write the complete transaction (T1) for the database requests (i.e., using SQL) to update the CAR and PART table each time a new car is created. - Complete the following transaction log below based on the transaction that you have defined above. Based on Question 1A, complete the following chronological list for T1 and T2 to demonstrate problem with lost update: Based on Question 1B, use the two-phase locking protocol as concurrency control to address lost update