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

Database design project proposal example

26/12/2020 Client: saad24vbs Deadline: 14 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).

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:

Helping Hand
Top Essay Tutor
University Coursework Help
Homework Guru
Writer Writer Name Offer Chat
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.

$60 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.

$65 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

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

$62 Chat With Writer
Homework Guru

ONLINE

Homework Guru

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

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

Kim Woods only - Apterous fruit fly - Xray vision 220 series hid - Health care budgeting and financial management for non financial managers - Pony club victoria dressage tests - Dr john vincent atanasoff - Mother any distance analysis - Clinical inquiry - 1.97 miles in km - Why did the zoot suit riots happen - Against the grain windows and doors - Network rail rule book - T5 case problem 1 golden pulps - Cssa trials timetable 2021 - How to open yale safe box - Define mood in drama - The manager of the danvers hilton resort hotel stated - Smitty's men's & boy's wear - Scilab solve system of equations - Why uniforms should not be banned - Probability And Statistical Inference - MBA515 Team Assignment - Social learning theory ppt slideshare - The "Canon" of English Literature - Magic carpet airlines case analysis - What is the domain of an exponential function - Eoi for construction project - Art 5 - Expert teachers have which of the following characteristics - Aiou degree verification contact number - Mspa shopper certification code - Discussion #25 - Standing silent documentary - Eastern sherbrooke forest walk - Quick analysis totals gallery in excel - Advanced greyhound cards sheffield - 2016 vcaa specialist exam 1 - Curtin calendar 2018 semester 2 - Thinking for yourself 9th edition answers - Two assignments due tomorrow before 11:59 pm - Nursing - Assign 1 - Subtracting scientific notation with negative exponents - Meditech surgical case study - Stevenson operations management 13th edition citation - Hard and soft engineering - How to find tax and tip - Intial - DISASTER MANAGEMENT PRINCIPLES TRAINING PRESENTATION - 273 k to c - Capstone Project Topic Selection and Approval - Discussion 6B Need by 12pm EST 9/18 Tomorrow - Presentation - Week 6 research article critique paper - Inputs strategic plans target elements of change and outputs - Rm cobol compiler free download - Marketing Help - Body fat and eating disorders paper sci 220 - Descriptive statistics in jupyter notebook - Jp hyperdome - Week2/1 - Monstera albo for sale australia - Dewey decimal system example - Shintoism method of reaching paradise - Baruch fin 3710 test bank - Shakespeare sonnet 29 literary devices - Timken torrington acquisition case - Week 1 - Assignment: Evaluate How Information Systems Detect Unethical Activities - When did mcdonald's stop supersizing - Discussion and paper - Our iceberg is melting characters review - The big short themes - The Golden State LAWS - Ge tee probe user manual - Public Health - Distance speed x time - Where did jared plushnick go - Susan komen planned parenthood 2018 - Dsm 5 autism criteria checklist - Samsung supply chain management ppt - Material delivery schedule template - Chemistry research topics high school - Advanced diploma of conveyancing nsw - Discussion Response(MK0 - Dundee city council leisure - Plot the supply curve and the demand curve for bicycles - Case management information systems are especially beneficial for those with - Vertical integration is going backward on an industry's value chain - How to calculate uniform velocity - Proctorio - Family and Natural Resources Paper - Juneyao airlines chinese name - Madman shakes a dead geranium - Simpson primary school victoria - Criminal procedure # 3 - Lord of the flies main theme - Organizational behavior 11th edition pdf - BUSINESS LAW, ETHICS AND SOCIAL RESPONSIBILITY - Business and law - Translink monthly pass price