Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. Draw a level 0 DFD for the university system in Exercise D, Chapter 4 and export it to PDF. Draw an entity relationship diagram

. Draw a level 0 DFD for the university system in Exercise D, Chapter 4 and export it to PDF.

image text in transcribed

image text in transcribed

Draw an entity relationship diagram (ERD) for the following situations: 1. Whenever new patients are seen for the first time, they complete a patient information form that asks their name, address, phone number, and insurance carrier, all of which are stored in the patient information file. Patients can be signed up with only one carrier, but they must be signed up to be seen by the doctor. Each time a patient visits the doc- tor, an insurance claim is sent to the carrier for payment. The claim must contain information about the visit, such as the date, purpose, and cost. It would be possible for a patient to submit two claims on the same day. 2. The state of Georgia is interested in designing a data- base that will track its researchers. Information of interest includes researcher name, title, position, university name, location, enrollment, and research interests. Each researcher is as sociated with only one institution, and each researcher has several research interests. 3. A department store has a bridal registry. This registry keeps information about the customer (usually the bride), the products that the store carries, and the products for which each customer registers. Customers typically register for a large number of products, and many customers register for the same products. Jim Smith's dealership sells Fords, Hondas, and Toyotas, The dealership keeps information about each car manu- facturer with whom it deals so that employees can get in touch with manufacturers casily. The dealership also keeps information about the models of cars that it carries from each manufacturer. It keeps such information as list price, the price the dealership paid to obtain the model, and the model name and series (e.g., Honda Civic LX). The dealer- ship also keeps information about all sales that it has made. (For instance, employees will record the buyer's name, the car the buyer bought, and the amount the buyer paid for the car.) To allow employees to contact the buyers in the future, contact information is also kept (e.g. address, phone number, e-mail)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost-Benefit Analysis

Authors: Euston Quah, E.J. Mishan

5th Edition

0415350379, 9780415350372

More Books

Students also viewed these Accounting questions