1.Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study?
2.Provide assumptions and business rules relevant to your ERD?
3.Map your Entity Relationship diagram (ERD) into relations and make sure that all the relations are in 3NF. Provide all the relations in the following format?
There are so many business rules which are used in the CQMC database-
There are some assumptions which are used in the CQMC database-
Table_Patient (FLPatientID, FLFullName, FLAddress, FLPhone, FLGender)
Table_Regular (FLPatientID)
Table_Special (FLPatientID, FLType)
Table_MedicalHistory (FLPatientID, FLSurgery, FLDetail, FLMedicine, FLDosage)
foreignkey(FLPatientID)references TABLE_Patient (FLPatientID)
Table_Allergy (FLPatientID, FLAllergy, FLDetail)
foreignkey(FLPatientID)references TABLE_Patient (FLPatientID)
Table_GP (FLMPNumber, FLFullName,FLAddress, FLPhone, FLGender)
Table_Reference (FLPatientID,FLReferralID,FLDateOfReference, FLLetter)
foreignkey(FLPatientID)references TABLE_Patient (FLPatientID)
foreignkey(FLReferralID)referencesTABLE_GeneralPractitioner (FLMPNumber)
Table_Specialist (FLSpecialistID, FLFullName,FLAddress, FLPhone, FLGender, FLExperience)
Table_SpecialistQualification (FLSpecialistID,FLQualification)
foreignkey(FLSpecialistID)references TABLE_Specialist (FLSpecialistID)
Table_Appointment(FLAppointmentID, FLSpecialistID, FLPatientID, FLAppointmentDateTime, FLBookingDateTime)
foreignkey(FLSpecialistID)referencesSpecialist (FLSpecialistID)
foreignkey(FLPatientID)references TABLE_Patient (FLPatientID)
Table_Prescription (FLPrescriptionID, FLAppointmentID, FLDateOfPrescription, FLTest, FLProcedures)
foreignkey(FLAppointmentID)references TABLE_Appointment (FLAppointmentID)
Table_CurrentMedication (FLPrescriptionID, FLProblem, FLMedicine, FLDosage)
foreignkey(FLPrescriptionID)references TABLE_Prescription (FLPrescriptionID)
Table_Fee (FLType, FLFee)
Table_Charges (FLAppointmentID, FLFeeType, FLFee , FLDiscount, FLTotalCharge)
foreignkey(FLAppointmentID)references TABLE_Appointment (FLAppointmentID)
foreignkey(FLFeeType)references TABLE_Fee (FLType)
(Raghu Ramakrishnan, Johannes Gehrke, Jeff Derstadt, Scott Selicoff, Lin Zhu n.d.)
(teratrax.com n.d.)
Raghu Ramakrishnan, Johannes Gehrke, Jeff Derstadt, Scott Selicoff, Lin Zhu, Database Management Systems Solutions Manual IIIrd Edition
teratrax.com n.d., SQL Server Data Types and Ranges, [Online]. Available: <https://www.teratrax.com/sql-server-data-types-ranges/> [Accessed: 5-April-2017]
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2018). Develop A Conceptual Data Model Diagram. Retrieved from https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram.
"Develop A Conceptual Data Model Diagram." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram.
My Assignment Help (2018) Develop A Conceptual Data Model Diagram [Online]. Available from: https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram
[Accessed 22 January 2021].
My Assignment Help. 'Develop A Conceptual Data Model Diagram' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram> accessed 22 January 2021.
My Assignment Help. Develop A Conceptual Data Model Diagram [Internet]. My Assignment Help. 2018 [cited 22 January 2021]. Available from: https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram.
MyAssignmenthelp.com has appointed best assignment experts who are wizards of words. Our writers know every trick of crafting high quality write-ups within a short period. With years of experiences, we have become one of the most prolific assignment help services in the USA. We deliver custom-made help to students with writing different types of assignments. We guarantee total need-based and timely service, and this is why increasing numbers of students prefer to buy assignment online.
Answer: For improving the business there are many parts need to upgrade. Human errors leads to huge losses to the organization. Errors are common for everyone but sometimes minimal errors leads to big problem. This topic also states the human error in the ice cream store that leads to business loss. In this assignment the management of the ice cream shop wants implement the automation system for the entire billing system. Because this process ...
Read MoreAnswer: Manual systems and operations have often placed a lot of pressure on employees to be extra careful and do tasks in the right way every time, but the problem is that human is to error and they are prone to do them many times. Productivity, performance, and quality of services in manual system is solely depended on the person doing it, therefore, this requires that the business carries out regular training for its employees so as to enab...
Read MoreAnswer: The current problem is a case of testing of hypothesis regarding mean lifetime ( ) of light bulbs. The standard deviation of light bulb has been provided as hours. Assumption: Let the random variable X denotes the lifetime of the light bulbs, where it is assumed that X follows Normal Distribution, (Park, 2015). Step 1: The null hypothesis is constructed as, Step 2: The alternate hypothesis is taken as, {two-tailed} Step 3: The leve...
Read MoreAnswer: Cryptography In cryptography, a hash value is a numeric value which is used to uniquely identify data and it has a fixed length in string values. Since hash values represent data of large amounts as well as smaller numeric values, they apply digital signatures in their operations (Lefebvre, Czyz & Macq, 2003, p. 496). Hash values are mostly used to store passwords in a database. 1. In order to have a successful message authentic...
Read MoreAnswer: Paperback Land is a small organization for selling and buying book. This book shop is run by three different employees. Andrew and Bhavesh are the semi-retired co-owners of the bookshop, and do not take a salary. Chad is a part time employee and its total employment cost is $22 per hour. In task 1, the total annual cost is calculating for this bookshop in a excel sheet. This sheet includes different type of working rate, working hours,...
Read MoreJust share requirement and get customized Solution.
Orders
Overall Rating
Experts
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. If you are unable to calculate word count online, ask our customer executives.
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
I had issues with my assignment and on top of that I have other commitments that hinders me from completing my assignment, therefore I engaged myassignmenthelp 2 days shy of the due date and I am impressed with the results that I obtained. Therefore,...
Australia
Thank you for reworking this order, the outcome is much better than the first produced and i look forward continue working with you.
Australia
the assignment was up to the mark. the team have done a great job. There should be more discount for loyal customers.
Australia
was on time for my assignment due, it was clear and straight to the point, it had enough detail to know what was happening and which question was being answered
Australia