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.

OR

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 30 March 2020].

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

My Assignment Help. CQ Implementing System [Internet]. My Assignment Help. 2018 [cited 30 March 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

ISY00243-You Can Fit In Information System-Case Study

Download : 0 | Pages : 9

Answer Fact findings Fact finding is a methodology used to carry out the research for this project and is comprising of  the following strategies like carrying out questionnaires, using sampling of the existing files, forms and document to analyze the system, carrying out research either from the book or from the internet, direct observation and prototyping. This requires to be done so that the data can be collected in a well and organiz...

Read More arrow

MITS5501 Software Engineering Methodology

Download : 0 | Pages : 6
  • Course Code: MITS5501
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: System Description For the development of the portfolio management system and analysis is made on the current framework of the organization and the requirement of the project is identified. The system acts as a single access point to the client and it is needed to be integrated with different functionality such that the portfolio managers can easily get a comprehensive view of the client and the investment information that are need to...

Read More arrow

BIT795 Relational Database Systems

Download : 0 | Pages : 6
  • Course Code: BIT795
  • University: Open Polytechnic
  • Country: New Zealand

Answers: Query 1 ALTER TABLE `reservation` ADD FOREIGN KEY (`TripID`) REFERENCES `trip`(`TripID`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `reservation` ADD FOREIGN KEY (`CustomerNum`) REFERENCES `customer`(`CustomerNum`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `tripguides` ADD FOREIGN KEY (`GuideNum`) REFERENCES `guide`(`GuideNum`) ON DELETE RESTRICT ON UPDATE RESTRICT; ALTER TABLE `tripguides` ADD FOREIGN KEY (`TripID`...

Read More arrow

MITS4003 Database Systems

Download : 0 | Pages : 5
  • Course Code: MITS4003
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Introduction The aim of the paper is to research about data mining. The report is going to discuss the concepts applied by the researcher in their paper. The report will describe all the components related to data mining. Data mining is the process through which data are stored electronically. Data mining basically deals with problem solving and analysing the data that are already present within the database (Maione ET AL., 2016). The p...

Read More arrow

BCO2041 Systems Analysis And Design 2

Download : 0 | Pages : 5
  • Course Code: BCO2041
  • University: Victoria University
  • Country: Australia

Answer: System Request Project Sponsor The sponsor of the project is Dr. Robert Slate who is the owner and President of Family First Medical Centers Pty Ltd. Business Needs The organization is a single centred organization, however, there has been an expansion in the number of centres and have developed four additional centres in the last four years. This would be expanding their businesses and the increase in the number of centres for the...

Read More arrow
Next
watch

Save Time & improve Grades

Just share your requirements and get customized solutions on time.

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,236,324

Orders

4.9/5

Overall Rating

5,066

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 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

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

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

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

440 Order Completed

99% Response Time

Jack Arens

MBA in HRM

London, United Kingdom

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

2594 Order Completed

95% Response Time

Michael Johnson

Masters of MSc in Economics

Washington, United States

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

Awesome write up for my assignment!!! Worth the money paid!!! Will come back .....

flag

User Id: 372486 - 30 Mar 2020

Australia

student rating student rating student rating student rating student rating

I really appreciate how the editor understood what I really meant to say thus making me feel more confident in submitting my work. I am an extremely happy customer. I will definitely sen un update on my grade.

flag

User Id: 393526 - 30 Mar 2020

Australia

student rating student rating student rating student rating student rating

Excellent work. We got total of 68 marks and we are very satisfied with the score. We gave this assignment near to deadline which is 2 days before due date. The assignment was about 4000 words and they did it well and gave it before 8 hours of submis...

flag

User Id: 393410 - 30 Mar 2020

Australia

student rating student rating student rating student rating student rating

I can\'t complain, speedy service and got the assignment before the deadline and got full mark

flag

User Id: 331157 - 30 Mar 2020

Australia

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