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

  Create a data warehouse conceptual design

Create a Data Warehouse conceptual design using Star Schema Modelling and document all steps during the design process

  Graph the bond yield to maturity

Identify two possibly mispriced bond issues, one overpriced and one underpriced. and graph the bond yield to maturity (YTM) on the y-axis of an XY-scatter plot, with the bond to maturity in years on the x-axis.

  Create relational schema of database in 3nf

A Relational schema of your database in 3NF, clearly indicating attributes, the data type of each attribute, primary and foreign keys, candidate keys, and which attributes are nullable, giving reasons. List any assumptions you need to make.

  What functional dependencies can you identify

Suppose you have a relation schema about teaching classes that has the following attributes: Class, Instructor, Time and Room - based on your understanding of this scenario, what functional dependencies can you identify that hold on this relation?

  Review of object oriented software development methodologies

Analyze how the verify method can be used to plan out system effectively and ensure that the number of transactions do not produce record-level locking while the database is in operation.

  Create an update query to select all records in the tbl over

Create an update query to select all records in the tblOverPriced, decrease the Price field values by 10%, run and close the query.

  Write functional dependencies in table concerns invoicing

Write the functional dependencies in the following table that concerns invoicing (an application Premiere Products in considering adding to its database), subject to the specified conditions.

  Calculate canonical cover for set of functional dependencies

Calculate a canonical cover for above set of functional dependencies (show each step of your derivation with an explanation).

  Optimize the query in the select script using alter table

optimize the query in the select script using Alter Table to add appropriate indexes. Also use Optimize and Explain to show how the performance of this query has improved.

  Draw inheritance hierarchy to represent shoe object

Draw an inheritance hierarchy to represent a shoe object. The base class should have derived classes of Dress Shoes, Tennis Shoes and Boots.

  Create mock-up report to make the monthly claim

He wishes you to group data by insurance company number, with subtotals by company and grand totals for each numeric field.

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

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