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

Develop A Conceptual Data Model Diagram

tag 0 Download2 Pages 400 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 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?

 

Answers:

1. ER Diagram

2. Business Rules

There are so many business rules which are used in the CQMC database-

  • All details about patient should be stored into the database.
  • All details about GPs should be stored into the database.
  • All details about specialist should be stored into the database.
  • The specialist’s experience and education should also be stored into the database.
  • The patient’s medical history is also need to store into the database.
  • Special patients should get discount from the CQMC.

3. Assumptions

There are some assumptions which are used in the CQMC database-

  • The date of appointment, booking is very important. It should be stored into the database.
  • The date of prescription is also most important. It should be stored into the database.
  • Two types of patients are used in CQMC- Special and Regular.

Logical Design / 3 NF Relations

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.)

 

References

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]

OR

Cite This Work

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 06 April 2020].

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 06 April 2020.

My Assignment Help. Develop A Conceptual Data Model Diagram [Internet]. My Assignment Help. 2018 [cited 06 April 2020]. 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.

Latest Database Samples

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

CPT140 Database Concepts And Relation

Download : 0 | Pages : 5
  • Course Code: CPT140
  • University: Royal Melbourne Institute Of Technology
  • Country: Australia

Answer: Question 1: 1.1 Give {LoanID}+: {LoanID, MemberFirstName, MemberLastName, Address, PostCode, LoanDate, ReturnDate, Title, Year, PublisherName, Year, LoanDate, ReturnDate} The closure of {LoanID} is in the above section. 1.2 Candidate Key:  MemberID – no redundant attribute MemberFirstName - redundant attribute MemberLastName – redundant attribute Address – redundant attribute PostCode – redunda...

Read More arrow

ITECH7406 Business Intelligence And Data Warehousing Enterprise Data

Download : 0 | Pages : 14
  • Course Code: ITECH7406
  • University: Federation University
  • Country: Australia

Answer: Introduction Air consist of breathable oxygen which is the most important factors for the existence of life on earth and continuously supports life on Earth. With the industrial revolution the fresh and pure air has been contaminated due to the excessive amount of increase pollutants. The presence of any substance in the air over the natural concentration level potentially impacts the effect.  Air pollution is mainly caused by t...

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,245,154

Orders

4.9/5

Overall Rating

5,067

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

647 Order Completed

98% Response Time

Adlina Han

Masters in Marketing with Specialization in Branding

Singapore, Singapore

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

1309 Order Completed

100% Response Time

Gemmie Chen

MSc in Nursing

Singapore, Singapore

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

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

Very fast and smooth service. The assignment I have received was highly satisfied.

flag

User Id: 218337 - 06 Apr 2020

Australia

student rating student rating student rating student rating student rating

it was grade homework and great time , I have a 5 point thanks , I will work with you always.

flag

User Id: 359586 - 06 Apr 2020

Australia

student rating student rating student rating student rating student rating

It was done very nicely and well before the deadline. I am very happy with the content and the expert

flag

User Id: 354422 - 06 Apr 2020

Australia

student rating student rating student rating student rating student rating

The work done was amazing! Helped me to get through my semester in flying colors. Worth every penny!

flag

User Id: 339159 - 06 Apr 2020

Australia

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