please answer Question 2.1 and 2.2

PROJECT 2: INFORMATICS 2A QUESTION 1 (20) 1.1 Lock granularity specifies the level of lock use. List and explain the four levels of lock granularity. 1.2 Deadlock is also called a deadly embrace. Explain the three techniques to control deadlocks. (10) (10) QUESTION 2 (20) ABC Motors has requested you to design a database to store information on car sales and accessories The sales form is shown in the figure below: Sales Sales No: Date: Customer ID: Name: Address: City, State, Postcode: Employee ID: Name: Car Sale Carld Make: Model: Colour: C Price: CarSub Total: Item No: Description: Accessories Sale Category: APrice: QuantitySold: TotalltemSold: Accessories SubTotal: SubTotal: Tax: Total: 2.1 Identify all entities and attributes for each entity from the Sales form in the figure Provide your answer in the following format: Entity Attributes (10) 2.2 Using your answers in question 2.1 above, draw a complete conceptual Entity Relationship Model (ERM) to model the data in the Sales Form. Multiplicities and primary keys must be shown on your model. PROGRAMME HANDBOOK: JULY 2020 INTAKE (10) 36 PROJECT 2: INFORMATICS 2A QUESTION 1 (20) 1.1 Lock granularity specifies the level of lock use. List and explain the four levels of lock granularity. 1.2 Deadlock is also called a deadly embrace. Explain the three techniques to control deadlocks. (10) (10) QUESTION 2 (20) ABC Motors has requested you to design a database to store information on car sales and accessories The sales form is shown in the figure below: Sales Sales No: Date: Customer ID: Name: Address: City, State, Postcode: Employee ID: Name: Car Sale Carld Make: Model: Colour: C Price: CarSub Total: Item No: Description: Accessories Sale Category: APrice: QuantitySold: TotalltemSold: Accessories SubTotal: SubTotal: Tax: Total: 2.1 Identify all entities and attributes for each entity from the Sales form in the figure Provide your answer in the following format: Entity Attributes (10) 2.2 Using your answers in question 2.1 above, draw a complete conceptual Entity Relationship Model (ERM) to model the data in the Sales Form. Multiplicities and primary keys must be shown on your model. PROGRAMME HANDBOOK: JULY 2020 INTAKE (10) 36