Medical Practice Database & Business Rules and Business Data - IT Computer Science Assignment Help

Assignment Task

Task

Medical Practice database: Business rules and business data

Overview
The Medical Practice offers not only general medical services by doctors, but other services such as physiotherapy,podiatry, optometry, etc.Often, a patient may only want to see a nurse for the purposes of a blood pressure check, an electrocardiogram of their heart, immunisation, or other similar general health screening service that can be provided by a nurse.There are several practitioners employed by the Medical Practice including doctors (General Practitioners or GPs), nurses, physiotherapists, podiatrist, etc. (see the list of the different types of practitioners below). The database must also record details of pathology tests that are requested by practitioners for patients, including the type of test, the date and time that the test was requested, and which practitioner requested the test.Pathology tests are not necessarily requested during the patient’s appointment with the practitioner, and could be requested at any time.

The Medical Practice is open from Monday to Friday from 8:00 am till 6:00 pm and the practitioners are available at the Medical Practice on varying days of the week.For example, one of the nurses is only available for appointments on Mondays, Wednesdays, and Fridays while the podiatrist is available on Tuesdays and Thursdays of each week.The practitioners’ availability does not change from week to week and they’re available for the whole day, 8:00 am till 6:00pm, on the days that they work.
The Medical Practice Receptionist will make appointments for patients to see practitioners.The database is only required to provide tracking information of patients’ appointments with practitioners, and any pathology tests that the patient may be required to undertake.

Patient management
The database must store the patient’s current personal data as follows: 
• Title
• First name
• Middle Initial (if applicable)
• Last name.
• House, unit or lot number. e.g. 3/45
• Street/road name
• Suburb
• State
• Post Code
• Home Phone Number (if applicable)
• Mobile Phone Number (if applicable)
• Medicare Number (if applicable,Unique) 
• Date of Birth
• Gender

The patient’s current personal details must be updateable. For example, if a patient changes their name or their address, then the new name or address must be recorded in the database. All addresses recorded in the database must be within Australia. Only the patient’s current details need to be stored. Not all Patients will have a Medicare Number.

The database must allow for the following operations on patient data:
• Inserting the details of a new patient
• Retrieving the details of an existing patient
• Updating the details of an existing patient
• Patients’ records are never to be deleted.

Appointment rules

• An appointment can only be made with a practitioner if they’re available on the day of the desired appointment.
• Appointments are allocated in 15 minute increments commencing on the quarter hour. For example an appointment could begin at 10:00 am and finish at 10:15 am. Or, for a more complex consultation with a doctor an appointment may commence at 2:00 pm and finish at 2:45 pm. In this case, three 15 minute appointments are booked for the patient with the practitioner.
• Patients can make an appointment to see any of the practitioners.
• A patient cannot book more than one appointment on the same date and start time. That is, patients must not be ‘double-booked’.
• A practitioner cannot take more than one appointment on the same date and start time. That is, practitioners must not be ‘double-booked’.

The database must allow for the following operations on appointment data:
• Creating new appointments for patients with practitioners
• Retrieving the details of a patient’s appointments
• Retrieving the details of all the appointments for a practitioner
• Retrieving the details of all the appointments for a practitioner on any particular date. 
• Cancelling a future appointment of a patient or a practitioner
• Updating an appointment date or time
• Deleting an appointment.

This IT Computer Science Assignment has been solved by our IT Computer Science Expert at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. 

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.