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 Perform Logical Design

tag 0 Download2 Pages 460 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 Develop a Conceptual Data Model Diagram Perform Logical Design.
 
 

Answer:

ER Diagram

(CS Odessa Corp. 2016)

Business Rules

Business rules that are the base of the CQMC database are as follows-

  1. The detail of every person related to CQMC like patient and specialist will be stored into the database.
  2. The medical history of patient will also be stored into the database.
  3. The payment detail of the patient will also be stored into the database.
  4. The discount will be given to the special patients from CQMC.
  5. If there is any allergy to the patient, that will also be saved into the database.

Assumptions

Assumptions that are implemented in the CQMC database are as follows-

  1. The prescription date, appointment date etc., all are stored into the database.
  2. The information related to the GP is also stored into the database.
  3. The qualification of the GP is also mentioned into the database.

Logical Design (3 NF Relations)

Tab_Patient (Field_PatientID, Field_FullName, Field_Address, Field_Phone, Field_Gender)

Tab_Regular (Field_PatientID)

Tab_Special (Field_PatientID, Field_Type)

Tab_MedicalHistory (Field_PatientID, Field_Surgery, Field_Detail, Field_DateofSurgery)

Foreign key (Field_PatientID) references Tab_Patient (Field_PatientID)

Tab_Allergy (Field_PatientID, Field_Allergy)

Foreign key (Field_PatientID) references Tab_Patient (Field_PatientID)

Tab_GP (Field_MPNumber, Field_FullName, Field_Address, Field_Phone, Field_Gender, Field_Experience)

Tab_GPQualification (Field_ MPNumber, Field_Qualification)

Foreign key (Field_ MPNumber) references Tab_GP (Field_ MPNumber)

Tab_Reference (Field_PatientID, Field_ReferralID, Field_Letter)

Foreign key (Field_PatientID) references Tab_Patient (Field_PatientID)

Foreign key (Field_ReferralID) references Tab_GP (Field_MPNumber)

Tab_Specialist (Field_SpecialistID,Field_FullName,  Field_Address, Field_Phone, Field_Gender, Field_Experience) 

Tab_SpecialistQualification (Field_SpecialistID, Field_Qualification)

Foreign key (Field_SpecialistID) references Tab_Specialist (Field_SpecialistID)

Tab_Appointment (Field_AppointmentID, Field_SpecialistID, Field_PatientID, Field_AppDateTime, Field_BookingDateTime)

Foreign key (Field_SpecialistID) references Specialist (Field_SpecialistID)

Foreign key (Field_PatientID) references Tab_Patient (Field_PatientID)

Tab_Prescription (Field_PrescriptionID, Field_AppointmentID, Field_PrescriptionDate, Field_Test, Field_Procedures)

Foreign key (Field_AppointmentID) references Tab_Appointment (Field_AppointmentID)

Tab_CurrentMedication (Field_PrescriptionID, Field_Problem, Field_Medicine, Field_Dosage, Field_StartDate, Field_EndDate, Field_Duration)

Foreign key (Field_PrescriptionID ) references Tab_Prescription (Field_PrescriptionID)

Tab_FeeStructure (Field_Type, Field_Fee)

Tab_Charges (Field_AppointmentID, Field_FeeType, Field_Discount, Field_TotalCharge)

Foreign key (Field_AppointmentID) references Tab_Appointment (Field_AppointmentID)

Foreign key (Field_FeeType) references Tab_FeeStructure (Field_Type) (Adrienne Watt n.d.)

 

References

Adrienne Watt n.d., Chapter 11 Functional Dependencies, [Online]. Available: <https://opentextbc.ca/dbdesign/chapter/chapter-11-functional-dependencies/> [Accessed: 6-April-2017]

 CS Odessa Corp. 2016, Design elements – ERD (crow’s foot notation), [Online]. Available:  <https://www.conceptdraw.com/examples/crowfoot-notation> [Accessed: 6-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 Perform Logical Design . Retrieved from https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram-perform-logical-design.

"Develop A Conceptual Data Model Diagram Perform Logical Design ." My Assignment Help, 2018, https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram-perform-logical-design.

My Assignment Help (2018) Develop A Conceptual Data Model Diagram Perform Logical Design [Online]. Available from: https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram-perform-logical-design
[Accessed 03 April 2020].

My Assignment Help. 'Develop A Conceptual Data Model Diagram Perform Logical Design ' (My Assignment Help, 2018) <https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram-perform-logical-design> accessed 03 April 2020.

My Assignment Help. Develop A Conceptual Data Model Diagram Perform Logical Design [Internet]. My Assignment Help. 2018 [cited 03 April 2020]. Available from: https://myassignmenthelp.com/free-samples/develop-a-conceptual-data-model-diagram-perform-logical-design.


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

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

ITECH7406 Business Intelligence And Data Warehousing Data System

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

Answer: 1. Introduction The generation of new data is increasing at an exponential rate due to the advancement within technology as well as an information system. The data that are collected can either be structural in nature, or they are generally unstructured in nature. It is found that different types of sensitive data, as well as information, generally remains hidden within the huge data volumes which can be used in the business organizat...

Read More arrow

ISY00243-You Can Fit In Information System-Case Study

Download : 0 | Pages : 9

Answer Fact findings Fact finding is a methodology used to carry out the research for this project and is comprising of  the following strategies like carrying out questionnaires, using sampling of the existing files, forms and document to analyze the system, carrying out research either from the book or from the internet, direct observation and prototyping. This requires to be done so that the data can be collected in a well and organiz...

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,241,609

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

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

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

2594 Order Completed

95% Response Time

Michael Johnson

Masters of MSc in Economics

Washington, United States

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

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

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

The assignment was return to me on time has to make corrections and adjustment myself but still made a good grade. thanks

flag

User Id: 392946 - 02 Apr 2020

Australia

student rating student rating student rating student rating student rating

OMG this was totally better than expected and worth every penny!!! I suck at math so i\'m excited to see my grade!

flag

User Id: 394019 - 02 Apr 2020

Australia

student rating student rating student rating student rating student rating

Very happy with work provided by My assignment help.com. Excellent work. Always with in deadline.

flag

User Id: 228464 - 02 Apr 2020

Australia

student rating student rating student rating student rating student rating

Haven\'t get result yet but already feel like a great piece of writing, no disappoint.

flag

User Id: 329158 - 02 Apr 2020

Australia

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