Question

7. Review the example Hospital Physician Data Dictionary as found in your Lecture this week. Create a similar Data Dictionary for Patients, using the same format. Include at least 5 field names you think should be included in a Patient Data dictionary. Remember to use different data types for dates, text, and numbers. I have given you two examples to start. (10 points)

Field Name	Definition	Field Length	Data Type
Patient ID	Assigned ID code for patient	9	Numeric
Patient FName	Patient's First Name	25	Text

8. Which is the Primary Key in the above Data Dictionary? (2 points)

9 In your own words, explain the three step process of Data Modeling from Conceptual Model to Logical Model to Physical Data Model. (5 points)

10.         Name one of the challenges of compiling a Clinical Data Warehouse. (3 points)

Answer 1