Case Study: Database Development

Read the following articles available in the ACM Digital Library:

Note: The ACM Digital Library is a Strayer Library database located in iCampus > Campus & Library > Learning Resource Center > Databases. Go to https://research.strayer.edu to access A-Z Databases > ACM Digital Library or use the direct link to the database: https://libdatab.strayer.edu/login?url=http://dl.acm.org.

• Dual Assessment of Data Quality in Customer Databases, Journal of Data and Information Quality (JDIQ), Volume 1 Issue 3, December 2009, Adir Even, G. Shankaranarayanan. 
• Process-centered review of object oriented software development methodologies, ACM Computing Surveys (CSUR), Volume 40 Issue 1, February 2008, Raman Ramsin, and Richard F. Paige. 

Write a two to three (2-3) page paper in which you:

1. Recommend at least three (3) specific tasks that could be performed  to improve the quality of datasets, using the Software Development Life  Cycle (SDLC) methodology. Include a thorough description of each  activity per each phase. 
2. Recommend the actions that should be performed in order to  optimize record selections and to improve database performance from a  quantitative data quality assessment. 
3. Suggest three (3) maintenance plans and three (3) activities that could be performed in order to improve data quality. 
4. From the software development methodologies described in the  article titled, “Process-centered Review of Object Oriented Software  Development Methodologies,” complete the following.
   1. Evaluate which method would be efficient for planning proactive  concurrency control methods and lock granularities. Assess how your  selected method can be used to minimize the database security risks that  may occur within a multiuser environment.  
   2. Analyze how the method can be used to plan out the system  effectively and ensure that the number of transactions does not produce  record-level locking while the database is in operation.