Topic: Normalization & Entity Relationships
Learning Module Objectives:
After completing the activities in this section, you should be able to:
Teach One Assignment
If you are supposed to teach about this section of the course, select one of the assignments, do the assignment and show it to the instructor to make sure you have done it correctly. Prepare your slides, narrate your slides, remove excess words from narrated slides, convert narrated slides to a file format that can be uploaded, upload your file, email everyone in the class the URL of your file. Make sure that all these tasks are done ahead of scheduled class session. Your peers will appreciate receiving your advice on how to solve a class assignment as soon as possible and well before last day prior to class session.
No individual assignment should be completed in teams. Submit your work in Blackboard. Do not discuss the work with other students.
Question on ER Diagrams: Create a many to many relationship between patient table (Patient_Id, first name, Last name) and address table (Address_Id, Apartment, Street, Number, Zip code). Enter 5 rows of data into each table showing that two individuals can live at the same address and one individual can have two addresses, one current and the other previous address. Draw the diagram. Microsoft Access has an easy way to do the drawing or you can use any other software. Submit the drawing and all 3 tables with at least 5 rows of data entered.
Questions on Normalization: Please answer the following 7 questions:
Question 1: Good database design requires:
a. Present data in the sequence collected so that it is convenient to use it.
b. Non-key fields should be facts about the foreign key.
c. Primary key should uniquely identify the individual occurrences of the entity or relationship
e. None of the above.
Question 2: When a table is in
First Normal Form:
a. Fields consist of atomic data
b. Fields are repeated in a row.
d. Both A&B
e. None of the above
Question 3: If knowing Physician
Name is enough for knowing Physician ID, then which one of the
following statements is true:
Question 4: If the field,
‘Employee_Name’ is fully functionally dependent on the field
‘Employee_Number’ then which one of the following statements is
Question 5: When we talk about
tables in Second Normal Form, we can say that:
Question 6: Which of the following are good rules of design for normalization:
Question 7: A good database
designer might not put the field ‘Visit_Date’ in the Patient
Ongoing Question: This question is an individual project. Each week a portion of the work is done. This week explore various components of the predictive model for diabetes. Make separate predictions for detecting undiagnosed diabetes and forecasting upcoming diabetes.
There are no team assignments this week.
Copyright © Farrokh Alemi, Ph.D. First created on January 9th 2005. Most recent revision 08/29/2018. This page is part of the course on Healthcare Databases.