PERFORM SPECIAL MEDICAL PROCEDURES TO THE PATIENTS

  100% Pass and No Plagiarism Guaranteed

PERFORM SPECIAL MEDICAL PROCEDURES TO THE PATIENTS

Objectives

• To develop a conceptual data model diagram
• To perform logical design

Assignment Specification

In this assignment, youneed to perform the followingtasks for the given case study:

• Draw an Entity Relationship (ER) diagram
• Perform logical design
• Create3NF Relations

Case Study

Many medical specialists offer their medical consultations and perform special medical procedures to the patients at CQ Specialist Medical Center (hereafter called as CQMC).  Patients generally book their appointments through a telephone call or by personal visits to the center.  Sometimes, the General Medical Practitioners (GPs) contactCQMC directly on behalf of their patients for the specialist appointments.

The patient details, such as name, gender, etc., are collected and stored at CQMC. Since the name of the patient is not going to be unique, each patient is identified by a unique patient ID.  The details of patient’s medical history (past surgeries undertaken), details of current medications (medicines and dosages) and other medication-allergies, if any, have to be maintained by CQMC. The referral letter from a GP is not a requirement at the time of booking for an appointment with the specialist but it is compulsory at the time of actual patient’s consultation.  Just prior to the consultation, CQMC collects the referral letter from the patient and notes down the details of date of referral and the GP (identified by unique Medical Provider Number) who issued that referral letter.  Based on the necessity, the same GP may refer the same patient to the same specialist many times over a period of time.  During the consultation, a specialist may conduct various medical tests and procedures on the patient; may prescribe multiple prescriptions to the patient.  After each appointment, the name of the standard tests and procedures performed along with the medical prescription details are stored and maintained by CQMC.

The following table provides the details of consultation and other charges applicable for the specialist’s appointments.   The charges can be assumed to be constant values.

After each appointment, the patient pays the entire appointment charges to CQMC.  Each appointment charges include the consultation fees and additionally may include multiple other charges from the above table.  Sometimes, some specialists offer discount amount to some appointments on special grounds such as Pensioner, Veteran etc.,

Some GPs and patients often would like to know the details of qualifications and number of years of experience of the specialists.  Hence, CQMC maintains and updates those details periodically. You may note that a medical specialist may have multiple qualifications.

The attributes of the possible entities have not been mentioned clearly.  Hence, you need to assume at least three and at most seven relevant attributes for each of the entities that you will identify for your ER diagram.

Assignment Requirements

In this assignment,you need to create an Entity Relationship (ER) diagram relevant to the above case study and perform logical design to produce appropriate3NF Relations.

The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.

• Draw an appropriate ER diagram

Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study. 

Your ERDmust

• show all necessary entities, attributes andrelationships
• show identifiers/identifying attributes as necessary
• show multi-valued attributes, ifany
• show participation andcardinality
• show associative entities, ifappropriate
• show weak entities, if any
• use the notation described in the settext
• use consistent and appropriate naming for entities and attributes as specified in the unit text book

Somebusinessrulesorotheraspectsofthecasestudymaynotbecleartoyouwhenyoureadthecase study.Ifthisisthecase,thenyoushouldeitherapproachyourlecturerortutorforclarification,oryou maysimplymakeanassumptionandthendevelopyourERD accordingly.Forexample,thecase study might not mention all relevant participation information (also called minimum cardinalities). Ifso, you may make an assumption about what the minimum cardinalities might reasonably be, and thenshow theminyourERDaccordingly.Youshouldjustifyeachassumptionintermsofthebusiness,for example:itisassumedthateachcustomermusthaveatleastoneorderbecauseitisassumedthatthe business does not record customer details until the customer places anorder.

Togetyourselfstarted,askyourself,`IfIwererunningthisbusiness,whatthingsIneedtokeepa list of?`  Write those things down.  For each thing, what information would you need to record aboutit? How can it be identified? The answers to these questions will help you to develop your ERD.

• Assumptions and Business rules

Provide assumptions and business rules relevant to your ERD.

• Create Logical Design:

Map your Entity Relationship diagram (ERD) into relations and make sure that all the relations are in 3NF.  Provide all the relationsin the following format:

Customer (CustomerId,customerName,Street,Suburb,State,PostCode,Email)

Invoice (InvoiceNumber,invoiceDate, Total, CustomerId)

foreignkey(CustomerId)referencesCustomer(CustomerId)

Howandwhattosubmit:

You must make an electronic submission for this assignment using the appropriate assignment submission link in the unit web site. 

You should submit a Microsoft Word documentcontaining:

• A copy of your ERD.
• A list of business rules and assumptions including theirjustifications.
• 3NF Relations

Yourdocumentshouldcontainappropriateidentifyinginformation(yourstudentnumber,name,unit number, etc.) and should contain appropriate headings for eachsection.

Important points

• You must work individually on thisassignment.
• ThemodelsolutiontothisassignmentwillbereleasedapproximatelyTWO(2)weeksafterthe due date.
• Assignments that are submitted after the release of the model solution will receivezero marks.
• Youmuststateinyourassignment(attheendundertheheadingAcknowledgementsisagood place) all materials and sources you used. This may be as simple as `This assignmentwas completed using only the COIT20247unit materials` to mention that you have used only the items provided by the unit COIT20247.
• Beforesubmittingyourassignment,reviewthemarkingcriteriathat are available in the assignment specification.Ensurethatallthecriteriaareaddressedin your submission.
• After submitting your assignment, please verify that your submission was successful,i.e. download your submitted files to ensure that they are correct.
• Penalty related to late submission and plagiarism is handled as per the university policies.