saint gba327 module 3 assignment 3 -Case Study 7 latest 2015 winters

Case Study 7: Using the Pride Database

7-6. Explain the advantages of locating the PRIDE database in the cloud. Dr. Flores and his partners could place it on one of their own servers in the practice. Give reasons why it would be unwise for them to do so.

7-7. Explain the origin of Figures 7-23 and 7-24. What application created each? Where did the data for constructing the tables in Figure 7-24 arise? Using your intuition and database knowledge, explain how the relationship between Person and Workout is defined in Figure 7-23. What coding in Figure 7-23 ensures that every row in Workout will correspond to some row in Person?

7-8. Explain how the Store Exercise Prescriptions application in Figure 7-19 will use the tables shown in Figure 7-25.

7-9. Explain how the Store Exercise Data application in Figure 7-19 will use the tables shown in Figure 7-25.

7-10. Explain how the Report Patient Exercise application in Figure 7-19 will use the tables shown in Figure 7-25.

7-11. Data in the Person table most likely duplicates data in health clubs’ membership databases as well as data in healthcare providers’ patient database. Will this duplication create problems for the health clubs, healthcare providers, and PRIDE users? If not, say why not. If so, give two examples of problems and suggest ways that those problems can be solved.

7-12. Explain the ways in which the PRIDE database eliminates possible enterprise-level information silos. Explain ways that it might create another form of information silo.

7-13. Given what you know so far, do you think the PRIDE system is likely to be successful? Explain your answer.