Scenario: The Metropolitan Piano Association (MPA) is an organization of

 

Scenario: The Metropolitan Piano Association (MPA)  is an organization of piano teachers in the Global Springfield area.  Their purpose is to promote the education and performance of piano  students of all ages through hosting a variety of live student  performances and competitions. These competitions result in awards for  the top performers, those who improved the most, etc. The association  president Nick Rayapur has been keeping track of everything in Excel®,  but he knows it is time to build a real database. It will be hosted in  the cloud so that member teachers can input information from home and  check event schedules. While the cloud service will be responsible for  quite a few things, you are tasked with organizing the database and  explaining some potential database problems to Mr. Rayapur.

Choose two of the errors listed below and  research online and/or in the textbook to learn more about what they are  and how they can be mitigated.

Potential errors include (1) data input without validation, (2)  inconsistent naming conventions, (3) data redundancy, (4) hard deletes  instead of soft deletes, (5) reaching system capacity, (6) intentional  tampering, and (7) insufficient backup protection.

Your initial post is a formal business letter to your client. Make up  contact information for yourself so you do not share personal  information here. In your letter:

  • Explain each of the two potential errors: what it is, how it can  happen, and how you suggest to correct it. Remember that your client is  not tech-savvy, so your wording needs to be moderately simple.
  • Include all parts of a formal business letter as explained in the Reading PDF.
  • Provide just the URL(s) to your source(s) you used at the bottom of  the post. If you use the textbook, just type “Textbook” and the chapter  number(s).
 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Get 20% Discount: Coupon code [ SAVE20 ]