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

Databse Design Draw Entity Relationship Diagram

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

Questions:

1.Use the symbols as prescribed in your unit-textbook to draw the ER diagra?
 

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?

 

Anwers:

Identification of Entities

  1. Medical specialists
  2. Consultations
  • Procedures
  1. Patients
  2. Appointments
  3. General medical practitioner (GPs)
  • Medical history
  • Tests
  1. Prescription
  2. Charges
  3. Invoice

Identifying Attributes of the Entities

1.Medical specialists

Specialist ID

Specialist First name

Specialist Last name

DOB

Contacts

Address

2.Consultation

Consultation ID

Referral letter

Specialist ID

Specialist remarks

3.Patient

Patient ID

Patient Name

Gender

DOB

Phone number

Telephone

Address

Comments

4.Medical history

Patient ID

Past surgeries

Current medicines

Current dosage

Medication allergies

5.Booking

Booking ID

Patient ID

Date of booking

Appointment ID

6.General practitioner

Medical Provider Number

Name

Contact number

Address

7.Referral Letter

Letter ID

Notes

Medical Provider Number

8.Test

Test ID

Test description

9.Procedure

Procedure ID

Procedure description

10.Prescription

Prescription id

Description

11.Appointment

Appointment ID

Patient ID

Specialist ID

Phone call

Personal visit

12.Invoice

Invoice number

Appointment ID

Total charges

2: Business Rules and assumptions

The general practitioner may issue one or more referral letters. Many referral letters may be issued by one general practitioner.

One patient may have many referral letters while many referral letters may belong to one patient.

One patient may have one or more medical history reports. Many history reports may belong to one patient.

One patient may make one or more bookings for appointment while many bookings may be made by one patient

One booking makes only one appointment while one appoints has only one booking

One appointment may result to many invoices while many invoice which each invoice must be attached to an appointment

Each appointment must have one or more consultation while each consultation must have an appointment

Each appointment may have one or more tests while each test must have an appointment

Each appointment may have one or more prescriptions while each prescription must have an appointment

Each appointment may have one or more procedure while each procedure must have an appointment

3: Logical design in 3NF

Medical specialist (SpecialistID, Specialistname, DOB, Contacts, Address)

Consultation (ConsultationID, ReferralletterID, SpecialistID, TestID, ProcedureID, PrescriptionID, AppointmentID, Specialistremarks)

Foreign key (ReferralletterID) references Referral Letter (ReferralletterID)

Foreign key (SpecialistID) references Medical specialists (SpecialistID)

Foreign key (TestID) references Test (TestID)

Foreign key (ProcedureID) references Medical specialists (ProcedureID) 

Foreign key (PrescriptionID) references Prescription (PrescriptionID)

Foreign key (Appointment) references Appointment (AppointmentID)

Patient (PatientID, PatientName, Gender, DOB, Phonenumber, Telephone, Address, Comments)

Medical history (PatientID, Pastsurgeries, Currentmedicines, Currentdosage, Medicationallergies)

Foreign key (PatientID) references patient (PatientID)

Booking (BookingID, PatientID, Date of booking, AppointmentID, SpecialistID)

Foreign key (PatientID) references patient (PatientID)

Foreign key (AppointmentID) references Appointment (AppointmentID)

Foreign key (SpecialistID) references SpecialistID (SpecialistID)

General practitioner (MedicalProviderNumber, Name, contactnumber, address)

Referral Letter (ReferralletterID, Notes, MedicalProviderNumber)

Foreign key (MedicalProviderNumber) references general practitioner (MedicalProviderNumber)

Test (TestID, Testdescription)

Procedure (ProcedureID, Proceduredescription)

Prescription (PrescriptionID, Description)

Appointment (AppointmentID, PatientID, SpecialistID, time, duration)

Invoice (Invoicenumber, Appointment ID, Totalcharges)

Foreign key (Invoicenumber) references invoice (Invoicenumber)

 

References

Buxton, S. (2009). Database design. 1st ed. Amsterdam: Morgan Kaufmann Publishers/Elsevier.

Demba, M. (2013). Algorithm for Relational Database Normalization Up to 3NF. International Journal of Database Management Systems, 5(3), pp.39-51.

Garmany, J., Walker, J. and Clark, T. (2005). Logical database design principles. 1st ed. Boca Raton, Fla.: Auerbach Publications.

Howe, D. (2003). Data analysis for database design. 1st ed. Oxford [u.a.]: Butterworth Heinemann.

Shoval, P. and Even-Chaime, M. (2012). Database schema design: an experimental comparison between normalization and information analysis. ACM SIGMIS Database, 18(3), pp.30-39.

Watt, A. and Eng, N. (2014). Database design. 1st ed. [Place of publication not identified]: [publisher not identified].

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). Databse Design Draw Entity Relationship Diagram. Retrieved from https://myassignmenthelp.com/free-samples/databse-design-draw-entity-relationship-diagram.

" Databse Design Draw Entity Relationship Diagram." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/databse-design-draw-entity-relationship-diagram.

My Assignment Help (2018) Databse Design Draw Entity Relationship Diagram [Online]. Available from: https://myassignmenthelp.com/free-samples/databse-design-draw-entity-relationship-diagram
[Accessed 11 July 2020].

My Assignment Help. ' Databse Design Draw Entity Relationship Diagram' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/databse-design-draw-entity-relationship-diagram> accessed 11 July 2020.

My Assignment Help. Databse Design Draw Entity Relationship Diagram [Internet]. My Assignment Help. 2018 [cited 11 July 2020]. Available from: https://myassignmenthelp.com/free-samples/databse-design-draw-entity-relationship-diagram.


For years now, MyAssignmenthelp.com is providing affordable essay help to millions of students worldwide. Our essay assistance services have helped us in assisting students with even the toughest essay assignments. We take pride in the fact that we cater the best assistance to search terms like help me with my essay. We offer affordable services in the fastest way possible. For our fast delivering services, students trust us with their urgent essay assignment needs. Two of our most popular essay writing services are maths essay help and English essay help.

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,359,640

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

3076 Order Completed

99% Response Time

Emily Wei

Doctor of Philosophy (Ph.D) in Civil Engineering

Singapore, Singapore

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

2115 Order Completed

97% Response Time

Kimberley Chen

MPA in Accounting

Singapore, Singapore

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

798 Order Completed

97% Response Time

Benjamin Blakeman

MSc in Medical Technology

London, United Kingdom

Hire Me
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

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

This is one class that I absolutely hate to do the discussion questions and assignments so this service has been the best thing every and my grades are always an A

flag

User Id: 451554 - 11 Jul 2020

Australia

student rating student rating student rating student rating student rating

This has been such a great service and I wish I had used them last year and before this session. Makes my life much easier.

flag

User Id: 451554 - 11 Jul 2020

Australia

student rating student rating student rating student rating student rating

Always fast turn around time and quality work. Wish I had used them the last two years.

flag

User Id: 451554 - 11 Jul 2020

Australia

student rating student rating student rating student rating student rating

I am writing to inform you that I have received my grades for Human Growth & Development. They are as follows: Assignments 8 & 4 = 100%. Thank you for such professional services rendered! I am looking forward to a continued relationship in the futu...

flag

User Id: 452606 - 11 Jul 2020

Australia

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