So, the last tutor flaked out and I only have about 12 hours to complete this. Is there anyone out there that can help? Thanks in advance

 

Case Study Week 6DUE: May 15, 2016 11:55 PMGrade DetailsGradeN/AGradebookCommentsNoneAssignment DetailsOpen DateMay 9, 2016 12:05 AMGraded?YesPoints Possible100.0Resubmissions Allowed?NoAssignment InstructionsCase Study - week 6 - (18%):You are a star consultant from "Databases R US" IT consulting and managing Frm. Just graduated fromAPUS and this is your Frst critical job. You just got hired by "Home Solutions Inc" a construction andparts company to help them with their customer and parts data management. Unfortunately, thecompany has been depending on the owner's nephew for their data needs and Joe has done his best tocome through for the family business. His lack of experience with data management is hurting thebusiness as they have been unable to successfully keep track of their inventory system, customers andsales. Joe has put together a spreadsheet, see below, and they have been using it as a database ofsorts, to track their customers and inventory.Your speciFc tasks to help the business are in parenthesis are the percentage that correspond to theper item payment (grade weight):1) Review the existing spreadsheet, and their sample data andmake any assumptionsyou needabout the company. Make any comments about the approach that you are going to follow, as you seeFt.(10%)2) Redesign the spreadsheet into a database with tables, add any Felds that you think could be useful,even though it is not absolutely necessary. Explain your actions as you go along.3) Perform afunctional dependency analysis, and include it as part of your deliverables, for everystep of the normalization process (25%)4) Clearly take the existing un - normalized structure throughdistinct1N±, 2N± and Fnally 3N±stages, using the shorthand representation. All three stages of normalization have to be clearly deFnedand depicted for full payment by the proprietor. Do not forget Primary keys assignment.(25%)5) ±inally, create anMS Access prototype (actual database), including the data provided, with thenewly designed tables. Upload the prototype to the assignment area as part of the deliverables(5%).6) Create aQuery(In MS Access) that may include one or more tables, as needed, that provides theanswer to the following request: List the Invoice number, Customer Name, and Parts Description forpurchases by Customers that have an Account Balance of $3,000 or higher. Short them with thehighest balance being displayed Frst (Descending values)(5%)

 

• 1495597558-Case Study Week 6.docx

ComputerScienceExpert

(11)

Status NEW Posted 24 May 2017 03:05 AM My Price 9.00

-----------

Attachments

file 1495597561-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer