Unit 2_Week2 Labs - <NAME> PT2520 23 December...

Download Document
Showing pages : 1 of 4
This preview has blurred sections. Sign up to view the full version! View Full Document
<NAME> PT2520 23 December 2012 Unit 2 Labs Lab 2.1 – Identify Business Rules, Attributes, and Candidate Keys Step2 - 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? Step 3 Business Rules: - Doctor must login to database and select patients’ records that he/she is seeing for that day. - Front Office workers and nurses are able to view medical history and enter patient vital signs. - Doctors must complete form upon completion of appointment with patient. - Nurses can drop patients from program with doctors approval. Step 4 Security Rules: Patient entity PatientVisit entity a) Last, First MI Vitals, Doctors Notes b) Last Name last name, date of visit, and time PatientVisit c) Surrogate Key – Auto-Incremented numbers Composite Key – a combination of patients’ last name, date of visit, and time d) I chose Surrogate Key because it cannot be traced back to any of the patients’
Background image of page 1
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Create a FREE account now to get started. Log In

The email address you entered is not valid. The email address you provided is already in use.
Your username must be at least 5 characters. Your username must consist of only alphanumeric characters. Your username must contain at least one letter. Your username contains inappropriate language. Another user has already claimed this username.
Your password must be at least 6 characters in length.
{[ $select.selected.label ]} Please select a valid school.
By creating an account you agree to our Privacy Policy, Terms of Use, and Honor Code.
Create my FREE account Processing...
Sign Up with Facebook

We will never post anything without your permission.

Already on Course Hero? Log In