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

Old testament character sketch bible study - Geotrack security logon - Royal gwent hospital phone number - Tricon restaurants international globalization reexamined - What is a whole farm budget - 1425 calories a day - The population density of worms in a particular field - Defy gemini petit chef multifunction thermofan oven manual - Http simulations ibsa org au coffeeville - Help With MICRO ECON - Phet colorado electric field - You have a chemical in a sealed glass container - Spartan steel v martin judgement - How to pronounce praxis - Bulbs by cecil taylor - Dr ranbir singh clinic andheri east - List of irregular verbs in english and spanish - Lopilato bros hume - Examples of personal disablers in aged care - Ronessa brown net worth - Eco plastics company case study answers - Philippine normal university uniform - Reading assessment record sheet - Cmit 320 umuc - Clinical Significance - Skin Disorders - Pretest posttest design example - Sodium carbonate flame color - The _______ is located immediately below the stratopause - Environmental Issues - How to calculate desired roi per unit - 2 paragraph discussion - Griffins brook medical centre - Hooke's law bbc bitesize - Academic Success and Professional Development Plan Template. - Prefix meaning for pre - Q1 ecological succession refers to - Lucinda wizard of oz - The data selected to create a chart must include - Ideological reasoning - Maximum reimbursement a third party payer - Nurture works on what nature endows - Each chef at sushi emperor prepares - How many ghosts visit scrooge - Buzan mind map software - Policy based profession 6th edition - Shark bite hydraulic press - Shakespeare for early years - Church christmas concert flyer - Legg mason charged with violating the fcpa - Financial accounting theory mcgraw hill - Internation 5 ok - Disgrace essay topics - The adjusting entry required to record accrued expenses includes - What were the causes of the metrolink accident - Macbeth 100 question test answers - Discussion - Provide financial and business performance information assignment - Theorem 10.10 class 9 - Create a local database entry for chap authentication - Ucl msc mechanical engineering - Discussion on Linear development in Learning approaches - From net earnings of $740 per month - 11th century scotland macbeth - Walden university mental health nurse practitioner - Discussion - Key success factors of industry analysis - Psy4500/ Week 3 - Assignment: Analyze the Influence of Genius and Zeitgeist in Groundbreaking Psychological Studies - Human behavior negative and positive effects on the environment - Lcp phonics phase 6 - GHF D.6 - Gcu 5 mission competencies - Cisco ap bridge mode - Direct shear test lab report conclusion - Capricorn coast netball association - Trader joe's 10 minute barley discontinued - Hla competency directory - What is a social institution - Environmental Factors and Health Promotion Presentation (DUE 24 HOURS) - Skill related components of fitness - Alibaba case study questions and answers - Cryptic drinks quiz questions answers - Create a one variable data table in excel 2013 - 45 dover street malvern - Sfd and bmd for fixed beam - Ipc 620 latest revision - Gym management system php mysql source code - Chapter 10 e commerce digital markets digital goods quiz - What are the prime numbers between 1 and 49 - Essary enterprises has bonds on the market - D909o - Attention getter for persuasive speech - Log book sample for internship - Butterfield phosphate buffer preparation - 2013 penny no mint mark value - 4 3 loan calculations and regression worksheet answers - Information tech - Dicussion ( Management Concepts) Week 10 - Fire tank capacity as per nbc - Avon products inc 2009 case analysis