Unit 2 Labs
Lab 2.1 – Identify Business Rules, Attributes, and Candidate Keys
Step2
Are your patient records in a computer system already?
How is patient info followed and updated?
How do you process your reports?
How do you separate the dropped patients from the ones still in the program?
Do you classify patients by their health status?
Step 3
Business Rules:
The doctor must login to database and select patient’s records that he/she is seeing for that day.
Front Office workers are able to view medical history.
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 the doctor’s 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
c) Surrogate Key – Auto-Incremented numbers
Composite Key – a combination of patients’ last name, date of visit, and time
d) I chose the Surrogate Key because it can’t be traced back to any of the patient’s personal information and it will always be unique but it offers less protection against repeating the number.
I chose the Composite Key for the PatientVisit entity because it is a combination of the patient’s last name and their visit which makes it easier for reports and to view the document.
Lab 2.2 – Identify Entities, Attributes, and Business Rules
Step 3:
List Data Requirements
1. Allow IT Staff to edit all the Types of Software to be tracked. This includes type of software, licensing dates, status, and location.
2. Allow IT staff to enter, edit, and delete New Software Requests.
3. Allow IT staff to view the different licensing agreements and types. This includes viewing the license pricing per agreement.
4. Allow IT staff to sign out software to users with administrative privileges.
5. Allow IT Staff to update the status of software licenses.
6. Allow users, assigned users,
Step2
Are your patient records in a computer system already?
How is patient info followed and updated?
How do you process your reports?
How do you separate the dropped patients from the ones still in the program?
Do you classify patients by their health status?
Step 3
Business Rules:
The doctor must login to database and select patient’s records that he/she is seeing for that day.
Front Office workers are able to view medical history.
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 the doctor’s 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
c) Surrogate Key – Auto-Incremented numbers
Composite Key – a combination of patients’ last name, date of visit, and time
d) I chose the Surrogate Key because it can’t be traced back to any of the patient’s personal information and it will always be unique but it offers less protection against repeating the number.
I chose the Composite Key for the PatientVisit entity because it is a combination of the patient’s last name and their visit which makes it easier for reports and to view the document.
Lab 2.2 – Identify Entities, Attributes, and Business Rules
Step 3:
List Data Requirements
1. Allow IT Staff to edit all the Types of Software to be tracked. This includes type of software, licensing dates, status, and location.
2. Allow IT staff to enter, edit, and delete New Software Requests.
3. Allow IT staff to view the different licensing agreements and types. This includes viewing the license pricing per agreement.
4. Allow IT staff to sign out software to users with administrative privileges.
5. Allow IT Staff to update the status of software licenses.
6. Allow users, assigned users,