23 December 2012
Unit 2 Labs
Lab 2.1 – Identify Business Rules, Attributes, and Candidate Keys
Do you have patient records in a computer system already?
How is patient info tracked and updated?
How do you process reports?
How do you separate the dropped patients from the ones still in the program?
Do you classify patients by health status?
Doctor must login to database and select patients’ records that he/she is seeing for that
Front Office workers and nurses are able to view medical history and enter patient
Doctors must complete form upon completion of appointment with patient.
Nurses can drop patients from program with doctors approval.
Last, First MI
Vitals, Doctors Notes
last name, date of visit, and time
Surrogate Key – Auto-Incremented numbers
Composite Key – a combination of patients’ last name, date of visit, and time
I chose Surrogate Key because it cannot be traced back to any of the patients’