Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started