Case Description
You have been introduced to the Mountain View Community Hospital (MVCH) case in the preceding chapters. This chapter continues the case, with special emphasis on logical design for the relational data model. Although the hospital will continue to evaluate newer technology (e.g., object-oriented databases, XML, and XML databases), it is expected that relational technology will continue to dominate its systems development over the next few years.
Dr. Z in the MS Center is using the MS Clinic Management System from an external vendor to keep track of clinical information regarding his patients. The application uses a relational database. Before seeing a patient, Dr. Z reviews a printout of the worksheet shown in MVCH Figure 4-6.
a. Diagram the functional dependencies for this worksheet and develop a set of 3NF relations for the data on this worksheet.
b. Draw the relational schema and clearly show the referential integrity constraints.
c. Draw your answer to part b using Microsoft Visio (or any other tool specified by your instructor).
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.