Question

6. In your own words, explain the difference between a flat file and a relational database. (5 points)

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

Differences between flat file and relational database

Flat file	Relational database
stores the data in single table structure	uses multiple tables and cross- referencing records between the tables
Resembles spread sheet more than any other database in old computers	common and versatile databases in existence
Small data involved	large data involved
Examples file containing simple documents, notepad etc	examples are Oracle database, Microsoft SQL server etc