The following question is based upon a Car-Service relation which records the details of transactions occurring in an Automotive Mechanic and Repair business. You may assume the data are representative.

 

You have been asked to design a relational database for this system. You know that there are problems with the current design and that it will need to be modified in order to work effectively.

You need to write a 1-2 page report that addresses the following:

1. What are the specific problems associated with the current design and why do they arise?
2. How would you change the current design and how does your new design address the problems you have identified with the current design.

Transcribed Image Text:

Customer Customer Customer Number NAME DOB 008 123 852 159 008 101 999 101 Justin Case Liv Long Justin Case Corey Ander Walter Melon 8/08/1999 Corey Ander 8/08/1999 Service DATE Sonny Day Olive Hoyl 29/03/1998 2/10/2022 9/5/2023 8/4/2022 20/10/2004 9/5/2023 03/01/1991 15/9/2022 Car Rego NUMBER 1h568 30/01/2001 8/4/2022 1h985 1h895 8/08/1999 13/8/2023 1h458 1h325 1h854 Car made 1h127 Kia 03/01/1991 15/8/2019 1h325 BMW Z4 Toyota Corolla Car Model BMW Z4 Fiat Haval H6 Soul Red 500e Holden Astra 500e Service FEE 200 400 200 Fifty 200 150 One fifty 260 Staff NAME Ali Chip Ali Holly Ali Chip Ali Ali Staff speciality General Auto body General Service tech General Auto body 99999 General Customer Customer Customer Number NAME DOB 008 123 852 159 008 101 999 101 Justin Case Liv Long Justin Case Corey Ander Walter Melon 8/08/1999 Corey Ander 8/08/1999 Service DATE Sonny Day Olive Hoyl 29/03/1998 2/10/2022 9/5/2023 8/4/2022 20/10/2004 9/5/2023 03/01/1991 15/9/2022 Car Rego NUMBER 1h568 30/01/2001 8/4/2022 1h985 1h895 8/08/1999 13/8/2023 1h458 1h325 1h854 Car made 1h127 Kia 03/01/1991 15/8/2019 1h325 BMW Z4 Toyota Corolla Car Model BMW Z4 Fiat Haval H6 Soul Red 500e Holden Astra 500e Service FEE 200 400 200 Fifty 200 150 One fifty 260 Staff NAME Ali Chip Ali Holly Ali Chip Ali Ali Staff speciality General Auto body General Service tech General Auto body 99999 General