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

Question:

Discuss about the Relational Data Model E-R Diagram.
 
 

Answer:

ER Diagram

(Studytonight.com 2016)

Business Rules

The business rules that are defined in the CQ Specialist Medical Centre (CQMC) are as follows-

  1. The patient detail along with other information like medical history, allergy etc. will be stored into the database.
  2. The General Practitioners detail is also stored into the database like Name. Address etc.
  3. All test and procedures will also be stored into the database.
  4. The patient’s total charges and all tests charges will be saved into the database independently.
  5. Special patients will get discount from the CQMC.

Assumptions

The assumptions that are defined in the CQ Specialist Medical Centre (CQMC) are as follows-

  1. Booking and date of appointment will be stored into the database.
  2. The prescription date will also be stored into the database.
  3. The General Practitioners detail will also be stored into the database.
  4. There are two types of patients- regular and special patients like senior citizen etc.

Logical Design

TPatient (FPatientID, FFullName,FAddress, FPhone, FGender)

TRegular (FPatientID)

TSpecial (FPatientID, FType)

TPatientMedicalHistory (FPatientID, FSurgery,FDetail, FMedicine, FDosage, FAllergy)

foreignkey(FPatientID)references TPatient (FPatientID)

TGP (FMPNumber, FFullName,FAddress, FPhone, FGender)

TReference (FPatientID,FReferralID,FDateOfReference, FLetter)

foreignkey(FPatientID)references TPatient (FPatientID)

foreignkey(FReferralID)referencesTGeneralPractitioner (FMPNumber)

TSpecialist (FSpecialistID, FFullName,FAddress, FPhone, FGender, FExperience)

TSpecialistQualification (FSpecialistID,FQualification)

foreignkey(FSpecialistID)references TSpecialist (FSpecialistID)

TAppointment(FAppointmentID, FSpecialistID, FPatientID, FAppointmentDateTime, FBookingDateTime)

foreignkey(FSpecialistID)referencesSpecialist (FSpecialistID)

foreignkey(FPatientID)references TPatient (FPatientID)

TPrescription (FPrescriptionID, FAppointmentID, FDateOfPrescription, FTest, FProcedures)

foreignkey(FAppointmentID)references TAppointment (FAppointmentID)

TCurrentMedication (FPrescriptionID, FProblem, FMedicine, FDosage)

foreignkey(FPrescriptionID)references TPrescription (FPrescriptionID)

TCQMCFee (Type, Fee)

TCharges (FAppointmentID, FFeeType , FDiscount, FTotalCharge)

foreignkey(FAppointmentID)references TAppointment (FAppointmentID)

foreignkey(FFeeType)references TCQMCFee (Type)(Tutorialspoint 2016)

 

References

Tutorialspoint 2016, Relational Data Model, [Online]. Available: <https://www.tutorialspoint.com/dbms/relational_data_model.htm/> [Accessed: 5-April-2017]

Studytonight.com 2016, E-R Diagram, [Online]. Available: <https://www.studytonight.com/dbms/er-diagram.php> [Accessed: 5-April-2017]

OR

Cite This Work

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

My Assignment Help. (2018). Relational Data Model E-R Diagram. Retrieved from https://myassignmenthelp.com/free-samples/relational-data-model-e-r-diagram.

"Relational Data Model E-R Diagram." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/relational-data-model-e-r-diagram.

My Assignment Help (2018) Relational Data Model E-R Diagram [Online]. Available from: https://myassignmenthelp.com/free-samples/relational-data-model-e-r-diagram
[Accessed 09 April 2020].

My Assignment Help. 'Relational Data Model E-R Diagram' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/relational-data-model-e-r-diagram> accessed 09 April 2020.

My Assignment Help. Relational Data Model E-R Diagram [Internet]. My Assignment Help. 2018 [cited 09 April 2020]. Available from: https://myassignmenthelp.com/free-samples/relational-data-model-e-r-diagram.


At MyAssignmenthelp.com, we understand that when students get stuck with tough assignments, they look for affordable services. To assist students with complex assignments, we have built a team of skilled cheap essay writers. MyAssignmenthelp.com has become one stop solution for all students who often look for answers related to their search similar to do my essay at the cheap rate or who can write my essay at affordable prices. Students prefer hiring us as we have the best provisions to render services related to do my essay online at a reasonable rate.

Latest Database Samples

MITS5002 Software Engineering Methodology Case Study

Download : 0 | Pages : 8
  • Course Code: MITS5002
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Introduction: In our software we should make sure that a client receives real time notification about the market improvement and their balance in the account. If they have less balance in the account then they should be notified so that they can deposit the funds to the account for the account managers to purchase the shares. This kind of notification helps clients in taking an advantage of the market by purchasing cheap share from th...

Read More arrow

SIT772 Database And Information Retrieval

Download : 0 | Pages : 4

Answer: 1. Below is a list of documents in unstructured format that will be used to apply an index technique to convert them into an inverted index. Doc 1?Information retrieval is the activity of obtaining information resources relevant to an information need from a collection of information resources. Searches can be based on full-text or other content-based indexing. Doc 2?Information retrieval is finding material of an unstructured natur...

Read More arrow

ITECH2002 Systems Modelling

Download : 0 | Pages : 3
  • Course Code: ITECH2002
  • University: Federation University
  • Country: Australia

Answer: Background The report contains the details of the WestAust Corporation Ltd. who is looking to implement an Operations Management System. The system would be able to support the operations in the business of the organization. The organization works in the parcel system. They also provide services in the other sectors as well. The five sub-systems of the Operations Management System (OMS) for WestAust Corporation Ltd that have been identi...

Read More arrow Tags: Australia Abbotsford Management University of Sydney 

ITC548 System Analysis Project

Download : 0 | Pages : 10
  • Course Code: ITC548
  • University: Charles Sturt University
  • Country: Australia

Answer: Introduction This report aims to discuss the aspects of the implementation of the solutions of Telehealth Project. A review of the cloud based solutions along with the advantages and the disadvantages are provided in this report. The advantages and the disadvantages of the predictive SDLC approach and the advantages and the disadvantages of the Adaptive SDLC approach is provided in this approach is provided in this report. Lastly, thi...

Read More arrow

MITS5002 Software Engineering Methodology And Investments

Download : 0 | Pages : 15
  • Course Code: MITS5002
  • University: Victorian Institute Of Technology
  • Country: Australia

Answer: Introduction System is composed of different procedures that are brought together to complete a particular designated task within a specified period of time while information system is just a software used to give a particular data to it’s users. Information system in most organizations are managing and processing data as soon as the users request for the data. It can as well be used for planning long term activities in an orga...

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,249,346

Orders

4.9/5

Overall Rating

5,068

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

2830 Order Completed

97% Response Time

Leroy Bicknell

MBA in Marketing

London, United Kingdom

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

752 Order Completed

100% Response Time

Hugh Cleave

Masters in Human Resource Management (MMgt, HRM)

Wellington, New Zealand

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

1758 Order Completed

99% Response Time

William Martinez

MS in Biology

Washington, United States

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

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

Just submitted my first assignment, and so happy with the quality! Will highly recommend.

flag

User Id: 400281 - 09 Apr 2020

Australia

student rating student rating student rating student rating student rating

work done nicely on time. the price was so affordable and reasonable. this is my fourth assignment done by the site.

flag

User Id: 368625 - 09 Apr 2020

Australia

student rating student rating student rating student rating student rating

The assignment requirements was met and the assignment was delivered timely. Pleased with the service provided and would recommend it if you are in a rush and other commitments! Worth it for the price paid as quality work was provided.

flag

User Id: 117708 - 09 Apr 2020

Australia

student rating student rating student rating student rating student rating

Assignment requirements were met adequately. Expert worked on the assignment swiftly and delivered the assignment timely.

flag

User Id: 117708 - 09 Apr 2020

Australia

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