Make sure you to show all the detail around how you came to the 3NF 

Make sure to use MS ACCESS or equivalent to demonstrate your solution.

Your solution should show all Primary Keys, Foreign Keys, possible composite keys etc.
follow all the instructions provided in the image to answer the question 

Transcribed Image Text:

Mechanic Jim has been in business since 1979. His dad was a mechanic and so was his uncle. When his son took over the business in 2023 he realised how backward the business was and how there was no formal way of controlling the information of customers and bookings. He decided to hire you to work out what they can do? He was able in the interim to create a Spreadsheet using MS Excel, but this was clunky and seemed to keep getting slower and slower as more customer information was entered. He heard that it maybe better to retain information using a database. Required: You are required to normalise the data on the unnormalised worksheet provided below. You must show all working out. You need to explain the logic and how you got to the end (ie your total number of tables) Introduction: Mechanic Jim's multi-generational business has been a cornerstone in the community since 1979. However, despite its long-standing success, the lack of a streamlined system for managing customer information and bookings became apparent when Jim's son took the reins in 2023. Realizing the outdated practices, he seeks your expertise to revolutionize the business's data management. Task at Hand: Your job is to normalize the data provided in the unnormalized worksheet below. As a starting point, a spreadsheet using MS Excel was implemented, but its inefficiency and sluggish performance with increasing customer data led to the consideration of a more sophisticated approach-utilizing a database. Specific Requirements: 1. Normalization Process: Your primary objective is to normalize the data meticulously. The initial spreadsheet data needs to be restructured into a more organized and efficient database model. This process involves breaking down the information into smaller, interconnected tables to eliminate redundancy and improve data integrity. 2. Methodological Approach: Throughout your assignment, ensure you show your step-by-step methodology. Clarify the logic behind your decisions and demonstrate the thought process that led to your final design. Presenting your working out is crucial, showcasing each step of normalization to the ultimate determination of the total number of tables required. 3. Ultimately, you will present your normalized database structure, revealing the architecture composed of interconnected tables that will redefine how Mechanic Jim's business handles customer information and bookings. We expect that this will be done using MS ACCESS or Mechanic Jim has been in business since 1979. His dad was a mechanic and so was his uncle. When his son took over the business in 2023 he realised how backward the business was and how there was no formal way of controlling the information of customers and bookings. He decided to hire you to work out what they can do? He was able in the interim to create a Spreadsheet using MS Excel, but this was clunky and seemed to keep getting slower and slower as more customer information was entered. He heard that it maybe better to retain information using a database. Required: You are required to normalise the data on the unnormalised worksheet provided below. You must show all working out. You need to explain the logic and how you got to the end (ie your total number of tables) Introduction: Mechanic Jim's multi-generational business has been a cornerstone in the community since 1979. However, despite its long-standing success, the lack of a streamlined system for managing customer information and bookings became apparent when Jim's son took the reins in 2023. Realizing the outdated practices, he seeks your expertise to revolutionize the business's data management. Task at Hand: Your job is to normalize the data provided in the unnormalized worksheet below. As a starting point, a spreadsheet using MS Excel was implemented, but its inefficiency and sluggish performance with increasing customer data led to the consideration of a more sophisticated approach-utilizing a database. Specific Requirements: 1. Normalization Process: Your primary objective is to normalize the data meticulously. The initial spreadsheet data needs to be restructured into a more organized and efficient database model. This process involves breaking down the information into smaller, interconnected tables to eliminate redundancy and improve data integrity. 2. Methodological Approach: Throughout your assignment, ensure you show your step-by-step methodology. Clarify the logic behind your decisions and demonstrate the thought process that led to your final design. Presenting your working out is crucial, showcasing each step of normalization to the ultimate determination of the total number of tables required. 3. Ultimately, you will present your normalized database structure, revealing the architecture composed of interconnected tables that will redefine how Mechanic Jim's business handles customer information and bookings. We expect that this will be done using MS ACCESS or