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

Relational Data Model E-R Diagram

tag 0 Download2 Pages / 318 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

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]

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). 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 08 July 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 08 July 2020.

My Assignment Help. Relational Data Model E-R Diagram [Internet]. My Assignment Help. 2018 [cited 08 July 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

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

OIT20247 Database Design And Development

Download : 0 | Pages : 2

Answer: Business Rules Every Entity Relationship Model must have a strong set of business rules. For the CQ Insurance company’s database adaptation, the business rules that have been implemented into the ER Diagram are as follows: A customer can apply for only one of the insurance policies. He can buy the insurance for either a building policy or a home-contents policy for a particular property of his interest, or may be a building-c...

Read More arrow

ISYS616 Systems Analysis And Design

Download : 1 | Pages : 4

Answer: Reflective Journal System Analysis & Design is one of the most significant aspects of the system development projects. There are several concepts that are defined under system analysis & design. The application of these concepts shall be done to design and develop a flexible, scalable, and reliable system. I got an opportunity to apply these concepts and my understanding of the methods on Waiters on call meal-delivery system t...

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,357,694

Orders

4.9/5

Overall Rating

5,081

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

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

2279 Order Completed

97% Response Time

Zachary Perez

PhD in Computer Science and Information System

Washington, United States

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

755 Order Completed

95% Response Time

Douglas Cowley

Masters in Finance with Specialization in Audit

Wellington, New Zealand

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

2632 Order Completed

100% Response Time

Albert Ambrosio

MSc in Nursing

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

was not given on time and also there were many errors. had too many. mistakes in grammar

flag

User Id: 34737 - 08 Jul 2020

Australia

student rating student rating student rating student rating student rating

The paper is not graded but I am sure it will be good grade as all the requirement are made and it is well organised and easy to follow the ideas. I real like the expert who did this essay and if it was on my power I would always chose him/her to wo...

flag

User Id: 90466 - 08 Jul 2020

Australia

student rating student rating student rating student rating student rating

very satisfied! good writing and research. excellent understanding and made on time.

flag

User Id: 456093 - 08 Jul 2020

Australia

student rating student rating student rating student rating student rating

it is better than my expectation. the essay was ready few days before the due date.

flag

User Id: 382575 - 08 Jul 2020

Australia

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