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

Healthcare database design

29/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.

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:

Assignment Guru
Pro Writer
Chartered Accountant
Fatimah Syeda
Financial Solutions Provider
Quality Assignments
Writer Writer Name Offer Chat
Assignment Guru

ONLINE

Assignment Guru

I have read your project details. I can do this within your deadline.

$111 Chat With Writer
Pro Writer

ONLINE

Pro Writer

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

$124 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

I have read and understood all your initial requirements, and I am very professional in this task.

$42 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

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

$29 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

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

$66 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

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

$16 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

Against animal testing the body shop 1993 - Does metal expand in heat - Air conditioning license qld - Hurricane Sandy Case Study - Case study on death and dying grand canyon university - The boarding house james joyce - Brisbane city council report - Just walk on by brent staples thesis statement - Engineering assignment - Lions clubs district constitution - Bni referral slip education - How would you describe sunset boards cash flows for 2014 - Csi ny pot of gold music - Mgt 460 week 3 assignment - Budgeting and Control - Dr roto hog tiller parts - Hcf com au mobile apps - Athena 850 operator manual - Which image is an example of an angular unconformity quizlet - Laa1920 - Wendy Lewis 2 - The plaint of the camel poem questions and answers - Importance of user technology security education within organizations - Sunny baik flute piano - Performance improvement plan examples - Create your own Water Cycle - Experience plans early childhood - What is intellectual traits - Bupa care home menus - Orbital notation for titanium - A quilt of a country - Monument 14 savage drift summary - Cornell notes on i have a dream speech - Phar mor case study solution - If chemicals are transferred to secondary containers servsafe - Ideal pn junction diode - Line plots lesson 9.1 chapter 9 page 183 - Economics of Disease Background Information - Read article and write essay - The life of deep sea fish informative speech - Doosan 1600 compressor fault codes - Research Paper In American Literature I - Role and Scope research 2 - Tele fonika kable poland - Online C- Diversty - Molarity model 1 lemonade mixtures - What is categorical and quantitative data - 4 phases of adlerian therapy - 84 wilpena terrace kilkenny - Cell energy cycle gizmo worksheet answers - Opportunity cost of attending college - Legal environment - Time series residual analysis - Use the 6 Characteristics for the Conceptualization of Discourse Community to freewrite/brainstorm about a particular dicourse community. Example on next page. - Strategic quality management implementation plan example - Jiminy's cricket farm issued a 30 year 7 percent - Myitlab excel chapter 5 homework - History - Egg stores v leibovici - CJT 202 DISCUSSION - TCP/IP Attack Lab- SEED Labs Project - Due aug 27 - Phonemes and graphemes chart - Short run production function for tony hat store answers - How to date a white girl junot diaz - Breckinridge school of nursing earth city mo - How to check if a number is hexadecimal in python - Switch from motorola to a primeco phone - Examples of capital market instruments - A company's resources and capabilities represent - Boundaryless organization pros and cons - Balancing chemical equations using linear algebra - Sex linked traits virtual lab - Consider a profit maximizing firm in a competitive industry - I stand here ironing discussion questions - Animal farm chapter 4 annotations - Rensing groomers is in the dog grooming business - Thermometric titration experiment discussion - Igcse physics magnetism questions - Acs code of conduct - File submission: Computer Operation Vocabulary - Case study on biomedical ethics in the christian narrative - Business ecosystems come of age - Faria depth gauge manual - A&w root beer woolworths - Kid cannabis real life - Why is it irresponsible to serve jugs of alcohol - Experiment 1 classification of bones - Who owns the elder wand after dumbledore - Simplifying the Dissertation Writing Journey in the UK - FOR PROFESSIONAL RESEARCH WRITER ONLY - Time Management as an Online Student - An article in the october 2006 issue of the washington post claimed - Here will come soft rains - Naturalistic observation entails: - Pearsall v alexander - Mirror on the wall here we are again - What are group summations in excel - International computer driving license syllabus - 600 words due 10/02/2020 Telehealth enhancing care for elderly client - case study