prj_case5-mvch - Mountain View Community Hospital DATABASE...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Mountain View Community Hospital DATABASE DESIG Chapter 5 Project Case Chapter 6 Project Case Turgut Tezir CS 504.2354
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Mountain View Community Hospital  Project Case 5 Project Questions:   1  Why will Mountain View Community Hospital continue to use relational technology for  system development, despite the continuing emergence of never technology?      Because their employee has some experience with using relation technology. Even  though new technology is better for the hospital it is still risky. Sometimes, it is difficult  to adopt new technology in a system. It is expensive, takes time and might not fit the  hospital operation like relational technology.  2  Should Mountain View Community Hospital use normalization in designing its  relational database? Why or Why not? Yes, they can use normalization in designing its relational database because  normalization helps to produce well-structured relations and reduce anomalies. 3 . Why are entity integrity and referential integrity constraints of importance to the  hospital? Entity Integrity helps user to not confuse between two entities. (Entity Integrity rules:  No primary key attribute can be null)  Referential integrity helps user to not lost relationship between entities like Treatment  and patient. (Referential Integrity Constraint: A rule that states that either each foreign key value  must match a primary key value in another relation or the foreign key value must be  null) 
Background image of page 2
4 Who in the hospital should be involved in data normalization? All users in the hospital should be involved during the normalization process.  Therefore, they will understand the data and how to use this data. Project Exercises: 1. Map the E-R (and/or EER) diagram to a relational schema, using the technique  described in this chapter. Be sure underline all primary keys, include all necessary  foreign keys, and indicate referential integrity constraint? Relational schemas for Mountain View Community Hospital: (A). Chapter 3 Schema for  E-R diagram. B) - Chapter4 Schema for EER diagram. 2. Diagram the functional dependencies in each relation. 3. If any relation is not in 3NF, decompose that relation into 3NF relations and revise  the relational schema. All of the relations are 3NF.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 15

prj_case5-mvch - Mountain View Community Hospital DATABASE...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online