TO GET YOURSELF STARTED, ASK YOURSELF.”IF I WERE RUNNING THIS BUSINESS, WHAT THINGS I NEED TO KEEP A LIST OF?” WRITE THOSE THINGS DOWN. FOR EACH THING. WHAT INFORMATION WOULD YOU NEED TO RECORD ABOUT IT?” HOW CAN IT BE IDENTIFIED? THE ANSWERS TO THESE QUESTIONS WILL HELP YOU TO DEVELOP YOUR ERD.

TO GET YOURSELF STARTED, ASK YOURSELF.”IF I WERE RUNNING THIS BUSINESS, WHAT THINGS I NEED TO KEEP A LIST OF?” WRITE THOSE THINGS DOWN. FOR EACH THING. WHAT INFORMATION WOULD YOU NEED TO RECORD ABOUT IT?” HOW CAN IT BE IDENTIFIED? THE ANSWERS TO THESE QUESTIONS WILL HELP YOU TO DEVELOP YOUR ERD.

Length: N/A
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.
Type Fees/Charges
Consultation $120
Biopsy $75
Excision $175

Having Trouble Meeting Your Deadline?

Get your assignment on TO GET YOURSELF STARTED, ASK YOURSELF.”IF I WERE RUNNING THIS BUSINESS, WHAT THINGS I NEED TO KEEP A LIST OF?” WRITE THOSE THINGS DOWN. FOR EACH THING. WHAT INFORMATION WOULD YOU NEED TO RECORD ABOUT IT?” HOW CAN IT BE IDENTIFIED? THE ANSWERS TO THESE QUESTIONS WILL HELP YOU TO DEVELOP YOUR ERD. completed on time. avoid delay and – ORDER NOW

Do My Paper

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Order Now and we will direct you to our Order Page at Litessays. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.