Buy here: http:// homework. plus / info-321-paden-case-study /
Buy here: http:// homework. plus / info-321-paden-case-study /
You are a star consultant from " Databases R US " IT consulting and managing firm. Just graduated from APUS and this is your first critical job. You just got hired by " Home Solutions Inc " a construction and Parts Company to help them with their customer and parts data management. Unfortunately, the company has been depending on the owner ' s nephew for their data needs and Joe has done his best to come through for the family business. His lack of experience with data management is hurting the business as they have been unable to successfully keep track of their inventory system, customers and sales. Joe has put together a spreadsheet, see below, and they have been using it as a database of sorts, to track their customers and inventory.
Your specific tasks to help the business are in parenthesis are the percentage that correspond to the per item payment( grade weight):
1) Review the existing spreadsheet, and their sample data and make any assumptions you need about the company. Make any comments about the approach that you are going to follow, as you see fit. ( 10 %)
2) Redesign the spreadsheet into a database with tables, add any fields that you think could be useful, even though it is not absolutely necessary. Explain your actions as you go along.
3) Perform a functional dependency analysis, and include it as part of your deliverables, for every step of the normalization process( 25 %)
4) Clearly take the existing un- normalized structure through distinct 1NF, 2NF and finally 3NF stages, using the shorthand representation. All three stages of normalization have to be clearly