We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: [email protected] after completing this order process.
Important Note: Your order at Assignment Experts is protected by Consumer Law UK; also, we use 3rd party merchant support “PayPal” for all online transactions to provide you with the most protected online buying experience.
100% Pass and No Plagiarism Guaranteed
In this assignment, youneed to perform the followingtasks for the given 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.
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.
Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.
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.
Provide assumptions and business rules relevant to your ERD.
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:
Invoice (InvoiceNumber,invoiceDate, Total, CustomerId)
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:
Yourdocumentshouldcontainappropriateidentifyinginformation(yourstudentnumber,name,unit number, etc.) and should contain appropriate headings for eachsection.
International House, 12 Constance Street, London, United Kingdom, E16 2DQ
UK Registered Company # 11483120
View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains
If your assignment is plagiarised, we will give you £ 2999 in compensation