Database Analysis and Design Assignment |IT

Project Specification

Dr Zen Fuller is a chiropractor practicing in Churchill.  He started his practice in 2010, offering a variety of services including various types of adjustments, massages and health advices.  Due to Zen’s professionalism in offering effective and necessary treatments to his patients, his practice has grown substantially over the past few years.  To continue providing high quality services to his patients, Zen has decided to upgrade his current computer system, which is used for tracking the treatments for his patients and also other activities in his practice.

At the moment, when a patient turns up for a scheduled appointment, his/her information are retrieved using the patient’s name.  If this is the patient’s first appointment, the clerk will request the patient to fill up his/her personal information (i.e. name, address, contact number and drug allergies) on a patient information form.  A unique patient number will then be allocated to the patient.  If this is not the patient’s first appointment, the clerk will check with the patient if there is any change in his/her personal details and if he/she is covered by any health insurance.  All Australia citizens/permanent residents are covered by a public health insurance while private health insurance is optional.

Order Now

When Zen sees the patient, he first records the actual start time of the consultation.  After diagnosing the patient’s problem, Zen treats the patient with the appropriate service(s).  If required, Zen will also recommend some nutrition products to the patient.  If the patient is interested in purchasing these products from Zen’s clinic, the quantity of each product is specified.  If the patient is not interested, Zen will indicate the quantity as ‘zero’.  At the end of the consultation, all information on the diagnosis, treatment and products recommended to the patient are recorded.  The time, which the consultation is completed, is also recorded.  The patient is then directed to the clerk for payment.

The net amount to be paid by the patient is calculated based on the total price of the services/products acquired by the patient during the consultation, less the rebates on these services/products given by the health insurances of the patient.  Figure 1 shows a report detailing the information of a patient’s consultation

 


Patient Number

10

Consultation Number

20

Patient Name

Daren Anderson

Drug Allergy

þ Penicillins  ¨ Cephalosporins    þ Aspirin     ¨ Aztreonam

 

¨ Codeine      ¨ Sulfa Type Drugs þ Isoniazid  ¨ Nitrofurantoin

 

Tick all drugs which the patient is allergic to.

Consultation Date

30/11/2013

Scheduled Start Time

10.20 am

Actual Start Time

10.25 am

Actual End Time

11.15 am

Treatment

Service Code

Service Name

Health Insurance Classification

Unit Cost

Health Insurance  Covers *

Rebate

Diagnosis Description

S001

 

 

 

 

 

 

S015

 

 

 

 

 

 

S016

 

 

 

Spinal Adjustment

 

 

 

 

 

Foot Massage

 

 

 

 

 

 

Neck Massage

 

 

 

3

 

 

 

 

 

 

1

 

 

 

 

 

 

1

$150

 

 

 

 

 

 

$45

 

 

 

 

 

 

$50

OZ Public

 

Medibank Private

 

HBA Private

 

Medibank Private

 

HBA Private

 

NIB Private

 

HBA Private

 

NRMA Private

20%

 

30%

 

 

25%

 

10%

 

 

10%

 

15%

 

10%

 

15%

Back pain as a result of improper sitting posture in long period of studying

 

 

 

 

Back pain due to long term sports activities

 

 

 

 

 

Incorrect sitting posture

 

Recommended Nutrition Product

Code

Name

Quantity

Unit Cost

Supplier

Diagnosis Description

P001

 

 

P003

 

 

P005

Nature Back Support

 

Organic Relax Massage Oil

 

Nature Wild Berry Herbal Tea

2

 

 

0

 

 

1

$25

 

 

$12

 

 

$5

Nature Inc

 

 

Organic Inc

 

 

Nature Inc

 

Supplement for back pain

 

 

For back and neck massage

 

 

General exhaustion.  Tea to improve general health

 

Solution