Introduction

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: 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

something similar.

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

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