country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Question:

Discuss about the CQ  Implementing System.
 
 

Answer:

Introduction

CQ is implementing a system for its medical center. This document illustrates how the system is model based on the case study provided and then a logical design of the system is derived from the ERD. All the relations in the logical design are in 3NF.

Entity Relationship Diagram

The following is the relationship diagram for the CQMC system.

Business rules and assumptions

For CQMC to be operational, the following business rules are followed.

  • A customer visits a general medical practitioner and is referred to a CQMC specialist using a referral letter.
  • The customer visits or calls CQMC to make an appointment. The customer does not need to have the referral letter from the general medical practitioner to make an appointment if they go to the center.
  • When the patient makes an appointment, their details are captured in the system. These details include, the name, gender, age and address.
  • After making an appointment a consultation is created and the patient is informed the date. If the patient has the referral letter, details are recorded. These details include the date of the referral, and details of general medical practitioner who are identified by their unique number.
  • The patient visits CQMC on the day of his/her consultation and presents the referral letter from the general medical practitioner if he had not presented it during the day of making an appointment.
  • The specialist attending to the patient gets detail of the consultation from the referral letter from where the specialist conducts procedures and tests on the patient. These tests and procedures have to be recorded.
  • Based on the results the specialist may prescribe multiple prescriptions to the patient. The prescriptions are given after the specialist has checked the history of the patient for cases of allergic reactions to certain drugs. The prescribed medications are recorded in the system.
  • After treatment, the patient makes payments. The patient pays a consultation fee of $120. The other payments are based on the services provided by the specialist. There is a standard price for every service as shown in the table below.

Type

Fees/Charges

Biopsy

$75

Excision

$175

Laser

$250

  • Other additional charges on the patient are for the medication if any were prescribed.
  • The specialist may offer a discount to the patient.
  • If a patient would like to know the qualifications of the specialist they can get the details from the system.
 

From the case study a number of assumptions were formulated while creating the ERD. These assumptions are justified in the points below;

  • A patient can only visit CQMC with a referral letter from a general medical practitioner. This is rule only applies during the consultation day patients can make appointments without a referral letter but for the to see a specialist they have to present their referral letter.
  • The general medical practitioners who refer patients to CQMC are known and their details exist in the CQMC system thus to identify them a practitioner number is used. This is why a practitioner number is used to identify a referral letter from a patient during a consultation.
  • Tests and procedures done on a patient are solely based on the referral letter presented by the patient. This is because the referral letter always acts as the guide to the specialist
  • If the patient is visiting CQMC for the first time and no details of their history in the system, the specialist has to ask from the patient without referring to the system from where they can update the system. This is because the specialist cannot refer to the system for the patient history if the patient is on first time visit.
  • The specialist decides who gets a discount during payment. This is to enable discounts to be attributed to a specific specialist based on the specialist ID. This will give CQMC accountability over issuance of discounts.
  • Payment for the test and procedures is done based on the table shown above. There are no other prices for those services.
  • The patient gets medication at CQMC for the diagnosis so payment is inclusive of the medication. This helps in totaling the total payment the patient owes CQMC.

Justifications.

For the business rules and assumptions to work in a real-world application all the rules must work as defined for the system to work correctly. For referrals, every customer must present a referral letter. This makes it easy to create consultations. For discounts, a specialist is responsible for the discounts they give. This ultimately makes everyone responsible on how they issue the discounts as they will be accountable. For the general medical practitioners, it makes much more sense for CQMC to have their details so that a referral letter can be identified based on the practitioners unique ID. All the rules are justified as they facilitate to a correct logical design of the system

 

Logical design

From the entity relationship diagram the following relations are gotten.

Patient (patientID, name, age, gender, address, phone,email)

Appointments (appointmentID, patientID, date, type) foreign key (patientID) references patient (patientID)

generalPractioner (GPID, name, phone, address, postalCode)

patientAllergyHistory (allergyID, patientID, allergyName) foreign key (patientID) references patient (patientID)

patientSurgeryHistory (surgeryID, patientID, name, dateConducted) foreign key (patientID) references patient (patientID)

patientHistoryMedications (medicationID, patientID, name, amount) foreign key (patientID) references patient (patientID)

consultations (consultationID, patientID, referralID, date, specialistID) foreign key (patientID) references patient (patientID), foreign key (referralID) references referrals (referralID), foreign key (specialistID) references specialists (specialistID)

referrals (referralID,GPID,date,patientID) foreign key (GPID) references generalPractioner (GPID), foreign key (patientID) references patient (patientID)

specialist (specialistID, name, phone, age, address, postalCode, experienceYrs)

patientTests (tID, testID, patientID, consultationID, specialistID) foreign key (testID) references tests (testID), foreign key (patientID) references patient (patientID), foreign key (consultationID) references consultations (consultationID), foreign key (specialistID) references specialist (specialistID)

patientProcedures (pID, procedureID, patientID, consultationID, specialistID) foreign key (procedureID) references procedures (procedureID), foreign key (patientID) references patient (patientID), foreign key (consultationID) references consultations (consultationID), foreign key (specialistID) references specialist (specialistID)

tests (testID, name)

procedures (procedureID,name)

payments (paymentID, consultationID, amount,type, date) foreign key (consultationID) references consultations (consultationID)

discounts (discountID, amount, paymentID), foreign key (paymentID) references payments (paymentID)

specialistQualifications (qID, details, specialistID) foreign key (specialistID) references specialist (specialistID)

All the relations are in 3NF because they’re already in 2NF and all non-key attributes are dependent on the key attribute for every relation.

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2018). CQ Implementing System . Retrieved from https://myassignmenthelp.com/free-samples/cq-implementing-system.

"CQ Implementing System ." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/cq-implementing-system.

My Assignment Help (2018) CQ Implementing System [Online]. Available from: https://myassignmenthelp.com/free-samples/cq-implementing-system
[Accessed 15 July 2020].

My Assignment Help. 'CQ Implementing System ' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/cq-implementing-system> accessed 15 July 2020.

My Assignment Help. CQ Implementing System [Internet]. My Assignment Help. 2018 [cited 15 July 2020]. Available from: https://myassignmenthelp.com/free-samples/cq-implementing-system.


For years, MyAssignmenthelp.com has been operating as one of the cheap assignment help providers in the USA. We are one of the best college paper writing services that keep service price minimal. We do not let the affordability of our service to hamper the standard of our work. We have separate teams of experts to provide report writing help . At MyAssigenmnthelp.com, we believe in earning credibility, so students can pay for assignments only after getting satisfied solutions. Tough assignments bother you? Trust us with your project. You will not regret paying us to write assignments for you.

Latest Database Samples

ITAP3009 Software Analysis Design And Architecture 2

Download : 0 | Pages : 9
  • Course Code: ITAP3009
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Introduction Social Services are activities which are focused on the creation of a strong community, effective organization while endorsing equity in opportunities and transparency in transactions. Some of the services rendered include, but not limited to, job training, education, policy research, adoption, health care and food subsidies. The social service system aims at providing happy and comfortable life for individuals around a g...

Read More arrow Tags: Australia 47 software analysis  design and architecture Victorian Institute of technology 

ICT700 Systems Analysis

Download : 0 | Pages : 10

Answer: Introduction: System analysis and design is a high level process that consist of methodologies to develop a high quality system. System analysis and design helps in understanding the logics behind the system and the best possible ways to turn those logics into functional components of the system. Information requirement techniques and system requirements are parts of the system analysis phase. The use cases, UML modelling are part of ...

Read More arrow Tags: Australia Rochedale 47 system analysis University of the Sunshine Coast 

ITECH2306 Agile Coding

Download : 0 | Pages : 4
  • Course Code: ITECH2306
  • University: Federation University
  • Country: Australia

Answer: UML Class Diagrams Before   After   Screenshots demonstrating that your JUnit tests prove that the system has worked as expected Screenshot 1:   Screenshot 1 represents passed JUnit test cases of the 7-property rate calculation when each of the ratepayer did not do any charitable work. Screenshot 2:   Screenshot 2 represents passed Junit test cases of the 7-property rate calculation when each of the ratep...

Read More arrow Tags: Australia Arlington Management University of New South Wales 

COIT20247 Database Design And Development 3

Download : 1 | Pages : 2

Answer: Entity Relationship Diagram   (Smartdraw, 2016) Assumptions and Business Rules Following business rules and assumptions are put into practice into the CQI database- A customer can insure more than one property. Each property should be attached with addresses. Each claim should be belonged to one customer. The policy premium will be on yearly basis in CQI. The policy types available at CQI are- ‘Home’, &lsquo...

Read More arrow

TCC 233 Database Management Systems

Download : 0 | Pages : 7
  • Course Code: TCC 233
  • University: Wawasan Open University
  • Country: Malaysia

Answer: About Attributes and Tuples:  In the Student Relation of figure 1, tuple is a row. Here, it has 5 tuples with 6 values that is called as 6 tuples. In general, n- tuples has a list ordered of values n.  If t1 is refer to first tuple variable for the relation STUDENT, then t1 = <S10010, Chan Wai Yee, 56A, Jalan 2/14, Taman Midah, kuala Lampur, 012-3256780, F, wai99@yahoo.com>, similarly for the other.  Tuples may ap...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,362,109

Orders

4.9/5

Overall Rating

5,082

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 4/5

3076 Order Completed

99% Response Time

Emily Wei

Doctor of Philosophy (Ph.D) in Civil Engineering

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

93 Order Completed

100% Response Time

Jackson Mitchell

MiM (Masters in Management) in Supply Chain Management

New Jersey, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

1309 Order Completed

100% Response Time

Gemmie Chen

MSc in Nursing

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

THIS IS PERFECT . CAN I KNOW THE NAME IF THE EXPERT I WOULD LIKE TO MADE MY ALL THE ASSIGNMENTS WITH HIM OR HER.

flag

User Id: 283077 - 15 Jul 2020

Australia

student rating student rating student rating student rating student rating

Paper was written well and completed before my deadline, so I was able to review it with time.

flag

User Id: 459660 - 15 Jul 2020

Australia

student rating student rating student rating student rating student rating

The expert read through the document I provided carefully and gave great details on the proposal. A job well done.

flag

User Id: 332269 - 14 Jul 2020

Australia

student rating student rating student rating student rating student rating

Excellent work. Good job. I really Satisfied from your work. I appreciate for your efforts.

flag

User Id: 451973 - 14 Jul 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?