Database Design Assessment Group 4: David walbancke, Connor Geary, sy Schaeffer, Steven o'neil.

Scenario

HealthOne Medical Database

Small database consulting company specializing in developing databases for the medical industry. Awarded contract to develop a data model for a database app for a midsized insurance company.

Essentials

Keep track of health claims including Patient info, Doctor info, info on Patient visits as well info on prescribed drugs.

Info such as:

  • Patient Name
  • Address
  • Phone
  • Email
  • Primary care doctor
  • Insurance ID number
  • Insurance company name

Info on Doctor

  • Specialty
  • Hospital Affiliation
  • Phone number
  • Address
  • etc.

Hospital

  • Location
  • Contact Details

Prescriptions

Need to be tracked to determine claim eligibility including basic info of prescribed drugs so there is no conflicts. As a result of this the following info will be required on prescriptions

  • Drug name
  • Purpose/Use
  • Possible Side Effects

Extra Info

Application will be available in English for the time being. However there are plans to develop it in multiple languages at a later date.

Business Rules and Assumptions

A HOSPITAL may be affiliated by an AFFILIATION

An AFFILIATION is a source of affiliation from HOSPITAL

PRESCRIPTIONS can contain DRUGS

DRUGS may be prescribed by PRESCRIPTIONS

PATIENTS may have had PREVIOUSDR

DREVIOUSDR may have been assigned PATIENTS

PATIENTS may have INSURANCE

PATIENTS may be policyholders of INSURANCE

PATIENTS may be on a policy of INSURANCE

INSURANCE ar the insurer for PATIENTS

PATIENTS may have DOCTORS

DOCTORS are assigned PATIENTS

PATIENTS may have VISITS

VISITS may have PATIENTS

DOCTORS may have VISITS

VISITS are assigned to DOCTORS

DOCTORS may prescribe PRESCRIPTIONS

PRESCRIPTIONS are prescribed by DOCTORS

DOCTORS are affiliated by AFFILIATION

AFFILIATION source of affiliation of DOCTORS

ERD Diagram/Table Diagram

How will the Database will meet needs of Client?

  • The database will completely change how the hospitals are run and modernize it by doing the following.
  • Save space
  • Save energy
  • Save usage of equipment
  • Mean the hospitals need less staff
  • It will save the need to travel from one hospital to another to see physical patient records
  • Save money (maintenance after initial cost will be very low)

Made with Adobe Slate

Make your words and images move.

Get Slate

Report Abuse

If you feel that this video content violates the Adobe Terms of Use, you may report this content by filling out this quick form.

To report a Copyright Violation, please follow Section 17 in the Terms of Use.