Answered step by step
Verified Expert Solution
Link Copied!

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

imageimage

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 


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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

More Books

Students also viewed these Algorithms questions

Question

Describe four different definitions of quality.

Answered: 1 week ago

Question

why paying bribe is unethical ?

Answered: 1 week ago

Question

What is cultural tourism and why is it growing?

Answered: 1 week ago