Unit 5 - Westlake Hospital Example
pdf
keyboard_arrow_up
School
Columbia Southern University *
*We aren’t endorsed by this school
Course
ITC4302
Subject
Information Systems
Date
Apr 3, 2024
Type
Pages
3
Uploaded by searight21
ITC 4150, Database Design and Implementation Unit V: Westlake Hospital Sample Answers to Scenario Questions 1. Review the diagram you made from the previous chapter for all three levels of normalization. Here is the diagram from last chapter:
ITC 4150, Database Design and Implementation Change the diagram to reflect the fully normalized design. The diagram above needs several changes to conform to First Normal Form. In the PatientMedicalHistory entity there are several multivalued attributes—specifically medicines, allergies, and symptoms. Each of these requires new entities and linking entities. You may want to break up the medical history entity more. It is possible to see the depression attributes as a separate theme from the physical issues and symptoms. If so, you could create a separate depression entity. The example below, though, does not. m atientMedicalHistory atientAllergy ' Al ergy ‘ . PatientKey . PatientKey . . Patientkey ;o_l_"_. AllergyKey PatientLastName LungDisorder . . AllergeryKey AllergyName PatientFirstName HighBloodPressure PatientPhone HeartTrouble PatientEmail NervousDisorder —H i . . . PatientKey >O—H—. MedicineKey PatientAddress DigestiveTrack . . MedicineKey s PatientState Kidney Disorder MedicineName Patientzip Diabetes PatientBirthDate Hepititatus ymptom ’ PatientSymptom ‘ GrouplD Malaria SymptomKey S0———H# . . . PatientKey . PatientDoctorKey BloodDisorder SymptomName . . SymptomKey PhysicaDeformity LifeThreateningCondition Doctor Contagious . DoctorKey DepressionLevel DoctorlastName DepressionBeginDate DoctorFirstName FamilyHistory DoctorPhone 1 Notes Appointment W . AppointmentKey . AppointmentDetailKey L—o0¢ AppointmentDate . AppointmentKey . DoctorKey DepressionRating . PatientKey SleepDifficulties I LossOf Appetite N InabilityToLeaveHome Anxiety SuicidalThoughts BloodPressure Weight Pulse DoctorsNotes
ITC 4150, Database Design and Implementation 3. Document in writing why you made the changes you did, or why you did not need to make changes. Explain your diagram in terms of each of the three levels of normalization. Are there any repeating groups or multivalued attributes? If there are, how were they broken into entities and related to the existing entities? For Second Normal Form, you should note any additional themes and functional dependencies and what new entities resulted. The same for transient dependencies and Third Normal Form. If no changes were made, you should still explain how it conforms to each of the three normal forms. Review the normalized diagram for completeness. Do the entities capture all the data needed to meet the business rules and needs of the clinical trial? This involves a comparison with previous documents and notes. If anything is discovered as left out, it should be added and the diagram adjusted to reflect the additions. Documentation: Save the normalized diagram with notes about changes made during the normalization process to your database notebook. General Guidelines for this Assignment It may be that reviewing the diagrams for normalization results in few or no changes. The important point is that you can justify your changes or lack of them. The review for completeness in task 4 also involves judgment and depends largely on the discussions and decisions made in previous chapters. The guidelines below provide a general comparison rather than a task-by-task comparison. Poor Okay Good Final diagram and explanation do not show a clear analysis in terms of the three normal forms. The diagram may not completely capture all the requirements. Final diagram and explanation show an analysis in terms of the three normal forms. The diagram captures most of the requirements. There may be some small aspects missed or missing. Final diagram and explanation show clear evidence of systematic review for each of the three normal forms. The diagram captures all the requirements.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help