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.
The following is the relationship diagram for the CQMC system.
For CQMC to be operational, the following business rules are followed.
From the case study a number of assumptions were formulated while creating the ERD. These assumptions are justified in the points below;
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
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)
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.
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.
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
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
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
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
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
Just share your requirements and get customized solutions on time.
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
Awesome write up for my assignment!!! Worth the money paid!!! Will come back .....
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.
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...
I can\'t complain, speedy service and got the assignment before the deadline and got full mark