Case Description
Up to this point, you have developed the conceptual and logical models for Mountain View Community Hospital’s database. After considering several options, the hospital has decided to use Microsoft SQL Server, a relational DBMS, for implementing the database. Before the functional database is actually created, it is necessary to specify its physical design to ensure that the database is effective and efficient. As you have learned, physical database design is specific to the target environment and must conform to the capabilities of the DBMS to be used. It requires a good understanding of the DBMS’s features, such as available data types, indexing, support for referential integrity and other constraints, and many more. (You can alternatively assume that MVCH chose another DBMS with which you are familiar and then answer the following questions accordingly.)
Case Questions
This chapter discusses the 2002 Sarbanes-Oxley Act, which is not focused on not-for-profit providers such as many community hospitals.
a. Can you see how MVCH could benefit from voluntarily complying with SOX?
b. Specifically how can proper physical database design help with compliance and the following:
• Improving accuracy and completeness of MVCH data
• Eliminating duplicates and data inconsistencies • Improving understandability of MVCH data
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.