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

28/12/2020 Client: saad24vbs Deadline: 10 Days

Proposal


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.

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:

Homework Guru
Top Essay Tutor
University Coursework Help
Helping Hand
Writer Writer Name Offer Chat
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$232 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$235 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$232 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

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

Order 2076606: Book: A Long Way Gone - On seeing england for the first time essay - From inquiry to academic writing 4th edition chapter 1 - Week 10-2 please proof read and check errors and grammars - PPT - Eastern sherbrooke forest walk - Analysis on Food Security - Monash university public holidays - List of uk qualified solicitors - 150 words - Exercise 5 9 part level submission - Essay - What is a literary form - Finance - Apply moderate effect smartart style powerpoint - Core ethical teachings of judaism - Carbon nanotube body armor - Area of sector and segment - Mcgraw hill connect economics homework answers - What happened to missy in the shack - Types of industry sectors - Discussion (Chapter 6): - Silhouette cameo failed to locate framework dll - Urn of sacred ashes poison or not - Jetmaster gas fire troubleshooting - Discussion / Answer 2 questions and comment on 2 students / 200~300 words for answers / need in 24 hours / required outside sources - Hackman job characteristics model - Dual core itanium 2 processor - 56 redbanks road willaston - Case study - Social computing increases the need for customer service - What do gorillas sleep on in fruit orchards - Descriptive statistics excel 2016 - Http teacher scholastic com tools class_setup - Goodwill messages should be short selfless specific spontaneous and - Which of the following statements are false regarding a boxplot? - Indian bean tree crossword clue - Speech on alternative medicine - Dbt skills training manual - Change Proposal - Summary illustration mouse party - Japanese pond carp crossword clue - Schedules of reinforcement meaning - Klein and moeschberger survival analysis solutions - Deliverable 7 - Reorganization 15-18 Pages - Olongapo sports corporation distributes two premium golf balls - Pb h3po4 h2 pb3 po4 2 - What are the components of a relational database - Case Study: Chemotherapy - Selleys oven plus heavy duty gel iga - Cleanbeebaby - Application questions bloom's taxonomy - Alaska air on time performance - Assume that expected inflation is based on the following: πet = θπt-1. if θ = 0, we know that - 3 hour unit hydrograph - Is forum shopping ethical - Dietary fats and blood cholesterol levels worksheet answers - Pak halal meat manchester - 5 8 as a decimal and percent - How to make a family genogram - Wk 8-2 - Compare and contrast utilitarianism deontology and virtue ethics - What does this excerpt from the balfour declaration argue for? - Discussion 2 clinical - Graphics - Osb investment and technology jsc - Mobius strip activity worksheet - Compound words starting with star - Kiwisaver withdrawal application form - Northampton community college library - Toastmasters chief judge script - Ib paper 1 mark scheme - 45 nob hill irondequoit ny 14617 - French baroque floral design - Isoball 3 level 25 - Blu tack maximum temperature - T5-T1 BREAK EVEN ANALYSIS, NET PRESENT VALUE, INTERNAL RATE OF RETURN - How to write a purpose statement for a research proposal - Breaking into wall street 400 questions pdf - Stimulus discrimination consumer behavior - Coach tulin 80 day obsession - 4 slides powerpoint - St lucy's home raised by wolves short story sparknotes - Limiting reagent lab baking soda vinegar answers - Gastro stop how many to take - Cuso4 + bacl2 precipitate - Shelby shelving case solution - Worksheet - Atpl performance and loading - Sema ignited premium tickets - B 4a prokaryotic and eukaryotic cells answers - Logbook format for laboratory - Modern marvels renewable energy quizlet - Add force unity 2d - Cross curriculum priorities symbols - Peter boxall university of auckland - Jitterbug dance video clips - Should cellphones be used in school - Strategic groups beer industry - Mosfet differential amplifier small signal analysis