Draw at a context diagram and a level-0 diagram

Assignment Help Database Management System
Reference no: EM13314289

Problem 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.

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

Problem 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.

Reference no: EM13314289

Questions Cloud

The triose phosphate isomerase and isocitrate dehydrogenase : Which of the following enzymes is used in both glycolysis and gluconeogenesis? A. hexokinase B. pyruvate carboxylase C. malate dehydrogenase D. triose phosphate isomerase E. isocitrate dehydrogenase
Determine corresponding increase in the diameter of vessel : a spherical pressure vessel has an outer diameter of 10 ft and a wall thickness of 0.5 in. knowing that for the steel used ?all= 12 ski, E= 29 x 10^6 psi, and v= 0.29, determine (a) the allowable gage pressure,
State all of the statements that are true for so2 : Check all of the statements that are true for SO2. The domain geometry is trigonal planar. The molecular geometry is bent. The bond angle is 90 degrees
Determine the maximum force p that can be applied : The coefficient of static friction between each crate and the ground is 0.25 The crates are next to each other connected by a rope and then from the other end one has a P force going up at an angle of 30 degrees
Draw at a context diagram and a level-0 diagram : 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.
Design a fraction class : Design a fraction class. The class should have 2 data members to represent the numerator and denominator. Both of these numbers should obviously be integers. It should be able to display a fraction and include an operator for performing multiplica..
Define assumptions are reasonable ksp is the as solubility : The molar solubility of AgCl in 6.5 x 10^-3 M AgNO3 is 2.5 x 10^-8 M. In deriving Ksp from these data, which of the following assumptions are reasonable? A) Ksp is the same as solubility.
How much quantity does each individual firm produce : How much quantity does each individual firm produce? Using your answers from a) and b), determine if an individual firm is making a profit or loss and calculate this amount.
Find the magnitude of the acceleration of the jogger : A jogger accelerates from rest to 2.12 m/s in 3.34 s. A car accelerates from 24.1 to 38.6 m/s also in 3.34 s.  Find the magnitude of the acceleration of the jogger

Reviews

Write a Review

Database Management System Questions & Answers

  Write an application that creates a database named phonebook

Write an application that creates a database named PhoneBook. The database should have a table named Entries, with columns for a person's name and phone number. Next, write an application that lets the user add rows to the Entries table,

  Explaining content of document in natural language

Explain the content of this document in natural language;Design the graph representation of document;

  Describes a suitable methodology from the literature

Describes a suitable methodology from the literature for the purpose of designing, constructing and testing of a commercial BIDW for a multinational company.

  Provide an expression in relational algebra

Provide expression in relational algebra for each of the following queries: Give all the managers in database a 10 percent salary raise. Give all the other employees a 5 percent salary raise.

  Explain relational database design and implementation

ISYS 224 Database Systems - Relational Database Design & Implementation

  Data entities of this enterprise

Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity.

  Number of leaf-level blocks needed if blocks are full

What is the order P of the B+-tree if B+-tree access structure on the key is constructed? What is the number of leaf-level blocks needed if blocks are approximately 69% full (round up for convenience)?

  Er diagram and database schema

To analyse and comprehend a provided ER diagram and Database Schema and implement a database based on the provided ER diagram and Database Schema

  Determine the relationship between those areas

For this question, need data mining analysis (using k-means clustering algorithm) shows the relationship between poverty area and violent crime rate (homicide) depending on any one of the datasets attached with this assignment.

  Explain why it is important to record information

You have just received a new computer at work. it runs fast and works great. thinking about the future and the day something might break explain why it is important to record this information.

  Create a database for a home-budgeting application

The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command line.

  Pharmacy designating database

Pharmacy systems today are more efficient and user friendly when compared to the systems 20 years ago.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd