Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Relational database proposal example

26/03/2021 Client: saad24vbs Deadline: 2 Day

Abstract

Database systems provide organizations with a wide range of benefits including faster storage and retrieval of information, business intelligence and compliance with information security policies. Despite these numerous benefits, there are challenges that organizations face during the design phase. This proposal presents a database design proposal for a typical healthcare organization to handle events like storage of patient records, physicians, track finances, store medical examinations and treatment and ensure efficient booking of appointment by patients (Doukas, Pliakas, & Maglogiannis, 2010). The proposal will present a conceptual design that includes an ERD model.

Introduction

Manual maintenance of information is becoming difficult and obsolete as healthcare technology advances. In the healthcare industry, the storage of medical records is electronic hence requiring a healthcare organization to store information in a database and access them through a database management system. Currently, healthcare industry faces a challenge of slow information processing, loss of medical records, breaching of information security, massive consumption of papers due to manual storage and inaccuracy in analyzing data. This project aims at addressing these issues through a design of healthcare database using Entity-Relationship modeling. An Entity-Relationship model is a high-level design of the database that shows database entities, attributes, and the relationship between the entities (Earp & Bagui, 2012). Entities are real objects like patients, physicians, and hospitals while attributes are elements that give the objects its characteristics. Attributes include race, age, size, and address.

Solution

Despite the numerous benefits associated with database storage, there are challenges that organizations face during the design phase. However, this solution aims at developing a database design for a typical healthcare organization to handle events like storage of patient records, physicians, track finances, store medical examinations and treatment and ensure efficient booking of appointment by patients. The proposal will present a conceptual, logical and physical design through an Entity-Relationship model. The proposed database will also include a relational schema of the database to allow generation of results based on the desired queries developed in SQL (Al-Masree, 2015).

The project will be limited to design process of the database to yield deliverables like an ERD diagram, list of entities and attributes, a data dictionary, and description of the database design. The steps required to accomplish this objective will begin with the identification of entities and attributes, setting the relationships, presenting the entities in an ERD diagram and developing a data dictionary. A data dictionary will help map the project to a database design.

Resources

This project requires both human resources, financial capital, software components and hardware components. The human resource required include a graphic designer, database administrator, business requirements analysis, and a software engineer. Software requirements for the project include a relational database system like MS Access and SQL server and graphic design software like Adobe suite and Illustrator. Hardware components for the project are five Dell personal computers.

Budget

The table below shows a high-level budget estimation for the project:

Resource Item

Estimated Cost

Human Resource

$21, 000

Software Components

$1,250

Hardware components

$2,500

Total

$23,750

Users

Physicians: these are the database users with a strong knowledge in medical practice. However, these users have a limited experience in database management but can handle basic computer operations including running queries, reading from a database and creating useful information to the database system.

Patients: this includes a group of users with a mixed level of knowledge and competencies. They include computer experts and individuals with physical or technical disabilities. This group include the average users of the database but seeking medical advice from a healthcare facility. They also include family members of individuals seeking medical advice (Doukas et al., 2010).

Conclusion

Conclusively, the healthcare database design is highly recommended because it eliminates the vast expenses of using paper-based records. The design is also affordable because it does not include many stakeholders hence reduced disagreements during execution. Additionally, the design will help in improving the accuracy, security, and usability of the medical database. Upon successful implementation of the project, the project will result in improved return of investment for the hospital organization due to minimal operating costs and optimum delivery of services.

Reference

Al-Masree, H. K. (2015). Extracting Entity Relationship Diagram ( ERD ) From Relational Database Schema. International Journal of Database Theory and Application, 8(3), 15–26.

Doukas, C., Pliakas, T., & Maglogiannis, I. (2010). Mobile healthcare information management utilizing Cloud Computing and Android OS. In 2010 Annual International Conference of the IEEE Engineering in Medicine and Biology Society, EMBC’10 (pp. 1037–1040). https://doi.org/10.1109/IEMBS.2010.5628061

Earp, R., & Bagui, S. (2012). Database Design Using Entity-Relationship Diagrams. Library (Vol. 2012). https://doi.org/10.1201/9780203486054

Database Schema

The Database identified on module 1 will include the following five major entities and their relationships:

1. Physician: the physician entity has a one-to-many relationship with the treatment entity.

1. Patient: this entity has a one-to-many relationship with the appointment entity. Patient entity has a one-to-one relationship with a treatment entity.

1. Appointments: this entity has a one-to-many relationship with the patient entity. A patient will make an appointment (Bracci, Corradi, & Foschini, 2012).

1. Invoice: this entity has a one-to-many relationship with the treatment entity.

1. Treatment: this entity has a one-to-many relationship with the physician entity but a one-to-one relationship with an invoice entity.

Database Diagram

The diagram below shows the Entity Relationship of the database design:

erdplus-diagram

Database Schema

Data Dictionary

The table below shows the data dictionary for the Entity Relationship diagram designed:

Entity

Description

Attributes

Constraints

Physician

This entity will record all the personal and professional information about the physicians in the healthcare center.

Physician id, address, phone, age, degree, gender, shift

Primary key: Physician id

Patient

This entity will store information regarding the patients that can help in identifying them and offering best medical services.

Patient id, name, address, phone, age, gender

Primary key: Patient id

Appointments

An entity that will store the patients’ appointments and services they seek.

Appointment id, date, treatment id, physician id,

Primary key: appointment id,

Foreign key: physician id

Invoice

A financial entity that will store information about the billing for specific customers based on the treatment they receive.

Invoice id, patient id, amount due, invoice date, treatment id,

Primary key: invoice id,

Foreign key: patient id, treatment id

Treatment

This entity will record all the medical services that the entity offers to specific patients and the description of the services.

Treatment Id, patient Id, treatment, treatment cost, date,

Primary key: treatment id

Foreign key: patient id,

Areas of Difficulty

Identifying the database entities was challenging because it requires an interpretation of business requirements to identify the objects. At first, there were numerous entities identified that could lead to enormous database design. However, with closer consideration of the normal routine of a patient-physician healthcare visit, it was possible to determine the relevant entities and eliminate the irrelevant entities.

Developing the Entity Relationship diagram was also difficult because I was not familiar with the development tool. After implementing the first entity, adding attributes and inserting an appropriate relationship, it was easier to complete demonstrating and transfer them to this report.

Reference

Bracci, F., Corradi, A., & Foschini, L. (2012). Database security management for healthcare SaaS in the Amazon AWS Cloud. In Proceedings - IEEE Symposium on Computers and Communications (pp. 000812–000819). https://doi.org/10.1109/ISCC.2012.6249401

Database Schema

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Instant Assignments
Fatimah Syeda
Professional Accountant
24/7 Assignment Help
Homework Guru
Finance Master
Writer Writer Name Offer Chat
Instant Assignments

ONLINE

Instant Assignments

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$62 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$64 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

Give me a chance, i will do this with my best efforts

$77 Chat With Writer
24/7 Assignment Help

ONLINE

24/7 Assignment Help

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$39 Chat With Writer
Homework Guru

ONLINE

Homework Guru

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$128 Chat With Writer
Finance Master

ONLINE

Finance Master

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$105 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Vision and Mission Statement - Older Adults Patient Education Issues Essay and Interview - What is the overhead cost per unit for rings - Food for thought education scotland - What does it mean when cadences are elided - Pmp Training In Chennai | Pmp Certification Chennai | Pmp Certification Cost Chennai | - Nursing diagnosis for tourette syndrome - Business gov au business plan template - Types of chemical reactions worksheet answer key - Exam style questions business studies answers - Floridasnursing - 370 jingaling brook road - Week 10 - Flocon asphalt trucks for sale - X ray overexposure and underexposure - Texas judiciary assignment - National curriculum for early childhood education 2007 pakistan pdf - Bga heatsink with fan - Suppose that people consume only three goods - Prewriting: Finding Key Passages - Organizational Behavior - Team Management Power Point Presentation - Bank account program in java - Ib math hl formula booklet - Doherty and clark sebas - Why did kfc changed its name - Knowledge Sharing Principles - LEGALIZATION OF DRUGS - Delilah carol ann duffy poem - Is a cold pack endothermic or exothermic - Against school john taylor gatto analysis - Beowulf essay - Cipd level 7 employment law assignment examples - Latrobe exam timetable 2021 semester 2 - Medea quotes about revenge - Great blue heron generalist or specialist - General trading company profile doc - Uni of adelaide referencing - Golden age retirement planners specializes in providing financial advice - What is 1 decimal place - Ibm spss modeler crisp dm guide - Use bond energies to estimate the enthalpy change - Unit 1 Paper - Which assumed inventory cost flow method - How to find side length of non right triangle - Question Meaning On My Summer of Scooping Ice Cream - Sentimentalists think that an action is impermissible if it meets what condition? - What safeguards are included in patient portals and phrs - Chapter 13 the expenditure cycle purchasing to cash disbursements - Degree leading coefficient end behavior - Advantages of continuing education for nurses - Duncan robertson all black - British gas home appliance insurance - Mames restaurant meredith nh - What is vertical integration answers - Epa chemical mixing compatibility chart - Compare Western Hemisphere Maps - Disability resource centre cambridge - Aesthetic reasoning definition - Hubspot owner ollie marketer mary - Unique 0835179056 ^ ❤≼र≽❤≼=(⓾】【ABORTION CLINICS 】//PILLS IN PINETOWN SOWETO HILLBROW NEWTOWN OVERPORT PONGOLA DURBAN limpopo polokwane - Richmond group of charities - Edinburgh tram project case study - Hall green rgt dogs - Chmura solid wood l shape executive desk - Models of health and illness pdf - Learn animal body parts - Are blue whales carnivores herbivores or omnivores - A trna molecule is bilingual because it binds to - Openstax org details introduction sociology 2e - I need 1800 words on Leadership and influence , Networking , studying in the UK , Career Plan - Sas 9.4 installation guide linux - Code black documentary quotes - Angle of depression example - Apn professional development plan paper - Www chiefeducationalofficer in ariyalur - Calcium carbonate and hydrochloric acid - Wgu c229 social marketing interventions - Research Paper - Ccss ela literacy rl 1.3 - Eassy(550 Words) APA format - 3 references - Public administration 7 - Name two principal types of cost accounting systems - Equity theory discusses individuals' perceptions about the relationship between ____ and ____. - Roland's overhead doors reports the following financial information quizlet - National 5 chemistry course specification - Accounting III - C-V-P Analysis and Break Even - Dr cordelia oyekan john - Management planning worksheet mgt 521 - Essen of physical anthropology w bind in access code - Spanish alphabet letter sounds - Moreton bay dump fees - Car and ramp experiment - Symbols for statistical significance - Magnesium reacts with silver nitrate solution - Martin slattery key ideas in sociology - 4/1 repost - Common root words and word origins - Case studies of minority student placement in special education - Under armour mission statement 2018