StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Database Schema for a Health Care Clinic - Essay Example

Cite this document
Summary
"Database Schema for a Health Care Clinic" paper describes the entities and relationships of health care clinics together with their relationship. The paper also describes deleting using a marker column, database schema, and diagram which is indicated on the PowerPoint presentation…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER92.3% of users find it useful
Database Schema for a Health Care Clinic
Read Text Preview

Extract of sample "Database Schema for a Health Care Clinic"

Download file to see previous pages The database schema for the database is as follows:
(Indicated in bold are the primary and secondary key attributes)
Health Care Center (name, address, location, phone, email)
Patients(First Name, Last Name, Surname, patient Number, DOB, address, phone, next of kin, next of kin contacts )
Appointments (patient number, appointment number, date, time)
Prescriptions (prescription ID, patient number, prescription, date, treatment ID)\
Treatment (patient number, symptoms, diagnosis, treatment ID, date, treatment, description)
Referrals (patient number, date, hospital, symptoms, ref ID, description)
Diseases (disease ID, date, number of occurrences, symptoms, description)
The diagram is indicated in the PowerPoint presentation.

Challenges
The greatest difficulty in developing the database schema was in the drawing of the ER diagrams. The tools required for this task were not readily available and those that were available required a great deal of their understanding to use. The diagram drawn does not indicate all the attributes related to a given relation schema. It also has a limitation while indicating the relationships among the data entities.
This diagram can be highly improved so that it illustrates clearly all the relationships. This can only be achieved through the use of the appropriate modeling and mapping tools (John W. Satzinger, 2008).
Data dictionary for the entity attributes
• Primary key- This is a unique element in each table that helps to safeguard against repeating similar entries in a database. Helps to reduce data redundancy in the database (Elmasri, 2008).
• Secondary Key- This is a primary key that has been defined in another table but is being used in another table. This helps to enforce referential integrity of the database in that an attribute defined in a table must exist and have value to be used in the second table. ...Download file to see next pages Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database design and SQL Light database creation Essay”, n.d.)
Retrieved from https://studentshare.org/logic-programming/1618798-database-design-and-sql-light-database-creation
(Database Design and SQL Light Database Creation Essay)
https://studentshare.org/logic-programming/1618798-database-design-and-sql-light-database-creation.
“Database Design and SQL Light Database Creation Essay”, n.d. https://studentshare.org/logic-programming/1618798-database-design-and-sql-light-database-creation.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Schema for a Health Care Clinic

The Technology of HIMS: Hardware, Software, Peripherals and Processes

health care Information Systems: A Practical Approach for health care Management.... Some of the essential service components are: the health promotion services, disease deterrence services, emergency services, ambulatory care simple and complex conditions, inpatient care for single and multiple conditions, short term and long term care, social and psychological services, rehabilitation services, dental services, registration, scheduling, accounts management, and pharmaceutical services....
1 Pages (250 words) Essay

Use of Boolean Tools in Searching a Database

Specially mentioning, the formation, as well as the maintenance of an effective database system, can provide to be quite beneficial for enhancing the provided care to the patients by a considerable level.... It can be affirmed in this similar context that the formulation of a well-structured database would enhance patients' care through holding detailed health-related information about the patients, accessing and readily updating them in an effective manner.... t can be apparently observed that maintaining databases has brought about a plethora of improvements regarding patient care by maintaining medical records of the patients in a comprehensive manner, assessing the quality and the outcome of care at large....
12 Pages (3000 words) Research Paper

Public-Private Partnerships in Performance in Healthcare Services

At one point, the International Monetary Fund also pointed out that governments needed to expand the scope of private sectors' coverage in health care in relation to loan conditions, as a means of decreasing government debts (Stuckler and Basu, 2009).... They have acknowledged how private markets often do not provide public health services including primary health care (Basu, et.... On one side are those who want universal and public health services access as well as those wanting the private sector to make available care in areas where there has been failure in public services....
54 Pages (13500 words) Dissertation

Citizen Participation In Public Administration

The balance of a democratic relationship between the state and the Government is determined by key factors like access and transparency.... The paper "Citizen Participation In Public Administration" compares some of the issues raised from the perspectives of statism and libertarianism.... ... ... ...
6 Pages (1500 words) Essay

The Basics of the National Health Service System

The futility of it all should not be taken as an excuse to deny the body of health care.... This is where health care services come in.... ne of the places in the world where health care services have gone a long way is that of the United Kingdom.... , it has invested heavily in providing health care to its populace.... NHS has always considered health care as a basic human right.... As was already stated, the NHS is oriented toward achieving high-quality health care....
6 Pages (1500 words) Essay

Financial Analysis of DBMS in Health and Social Care Organizations in Hong Kong

Hong Kong's health care system needs reforms.... This computer system must be able to deliver or send needed information from one health care facility to another in various locations where it is needed.... In relation to the above-mentioned need, after Hong Kong's transition over to the Chinese mainland, there have been some proposed reforms on its health care system.... And since it is supported by one of the lowest tax regimes currently existing in the world, the Hong Kong government is giving good consideration on having revamps implemented on the overhaul of its entire health care system....
12 Pages (3000 words) Essay

Evidence-Based Practice

The evidence obtained does not dictate the decision-making process but helps in adding support for patient care.... The paper "Evidence-Based Practice" discusses the aims to produce research-based evidence to be applied in answering a question designed for use in a client who is hypertensive and overweight....
9 Pages (2250 words) Research Proposal

A Framework of an Information System for Healthcare Services

The writer of the paper 'A Framework of an Information System for Healthcare Services' states that paper-based records cannot maintain well the work of patient care in a sufficiently-organized manner.... The proposed system build will enable proper utilization and high efficiency of health records.... Admission of the sick is being done pointlessly in the health centre, undesirable drug reaction is taking place because clinicians are not aware of drugs prescribed, and several tests are being planned....
6 Pages (1500 words) Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us