1. Two clerks at Pitt Fitness need to update an address in the Access database for the customer Min Jee Choi. One Clerk sees a note about updating the address and begins to edit Min Jee’s record. At the same time, another clerk receives a phone call from Min Jee about changing the address and opens the Customers table. She sees a pencil symbol next to the record for Min Jee Choi and cannot change the address. What is happening with the database?
2. The new DBA at Pitt Fitness is working on catalog services in Microsoft Access. This employee has published an internal report on the database schema, but the managers receiving this report are confused by the term “database schema.” What is database schema, and what does the report contain? Create a simple report for the DBA to send to managers about the schema, in a way that they will understand what it is, while explaining what is in the schema.
3. Pitt Fitness would like to analyze their options for an in-house database versus a cloud database-as-a-service. What are the benefits to moving their database to the cloud?
4. Pitts Fitness is looking to hire some new employees. Create a job add for one of the following positions (Outline in the ad duties and responsibilities for potential positions: Database administrator (DBA), Data Analyst, SQL Programmer, and CIO.
5. The database administrator at Pitt Fitness wants to develop and test new application. What is the safest way to do this, considering the company has customers reserving classes frequently?
6. Considering that Pitt Fitness is a small company, what type of backup site would be appropriate for their smaller budget?
7. Pitts Fitness has decided to archive some of the old data in their DB. Which laws presented in the chapter does Pitts need to adhere to and why?
8. Write the SQL to give permissions to the data entry operator at Pitts. Explain why the DBA might limit some privileges.
9. Regression Testing is one technique that quality assurance individuals use to test a database system. Use Computer Magazines, books, or the Internet to research regression testing. Then prepare a report that defines regression testing and explain its importance in the database system testing process. If you use information from the Web, use reputable sites. Do Not Plagiarize or copy from the web, Cite your sources.
10. Describe some of the Big data Pitt Fitness might collect and find useful?