Draw at a context diagram and a level-0 diagram in drawing


1. Case - Dr Frank's Walk-In Clinic

Dr Frank's walk-in clinic has decided to go paperless and will use an information system to help move patient through the clinic as efficiently as possible. Patients enter the system at the front desk by providing demographic information to the personnel. If this is the first time the patient has been seen, insurance and basic demographic information is collected from the patient. If the patient has been seen previously, the patient is asked to verify the information pulled from the patient registry. The front desk person then updates the patient registry and ensures that the patient has a chart in the electronic medical records system; if not, a new medical record is started by placing formatted demographics into a blank medical record. The front desk person then enters the medical record ID into the system. Next, a medical technician collects the patient's health history, weight, height, temperature, blood pressure, and other medical information, and combines this information with any information from the patient's medical record, summarizing the information into a health trend. A doctor then sees the patient, prescribes medication or treatment where appropriate based on the medical trend, and sends the patient to checkout. The employee at checkout updates the patient's electronic medical record and provides prescriptions for medications or treatments and a printed record of the health services received.

You must draw at a context diagram and a level-0 diagram. In drawing these diagrams, if you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Provide these extra explanations along with the diagrams.

2. Case - Jumpstart Technologies

Jumpstart Technologies receives thousands of applications per day from software engineers who hope to work for that company. To help manage the constant flow of applications, a process has been created to streamline identifying applicants for specific openings as they occur. Those applications that are not in an approved file format are discarded and not processed in any way. All applications are first fact-checked automatically by detecting any inconsistencies with the application and the resume, as well as other resume sites available online. For any applications with more than one inconsistency, the application is automatically rejected as untruthful. Next, the application is checked against the database of other applications already in the system. If such an application exists, the older application is purged and the new application continues processing. Any applications that do not contain at least 15 of the top 200 keywords that the company is looking for are rejected. Next, the phone numbers of references are checked to ensure they are a valid, working phone number. These applicants are then retained in a searchable database. When managers send a hiring request, the fifty best applications that most closely match the desired attributes are sent to the manager. That manager selects the top 10 applications, which are then screened for bad credit, with credit scores below 500 eliminated from the hiring process. If there are at least 5 remaining candidates, they are all invited to participate in phone interviews. If there are fewer than 5 remaining candidates, the next 10 best matches are added to the pool and screened for poor credit, and any remaining candidates are invited to participate in phone interviews. Present this logic in a decision table. Write down any assumptions you have to make.

Solution Preview :

Prepared by a verified Expert
Database Management System: Draw at a context diagram and a level-0 diagram in drawing
Reference No:- TGS0652969

Now Priced at $40 (50% Discount)

Recommended (97%)

Rated (4.9/5)