Database Design Proposal: Analysis - Essay Example

Comments (1) Cite this document
The proposal is certainly feasible and possible because a relational database such as MySQL can easily handle the data storage and retrieval complexity required, PHP can be used to facilitate data entry and retrieval, and the use of CSS can help to ensure consistency in the…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER91.2% of users find it useful
Database Design Proposal: Analysis
Read TextPreview

Extract of sample "Database Design Proposal: Analysis"

Download file to see previous pages For example, if a patients current condition is required to be known, then all the necessary particulars of the patient will be required along with details of the treatments given, the response of the treatments and general health progress.
1. A foreseeable challenge could be that the number of patients will grow over time. It is therefore essential to minimise data redundancy and lack of coherency issues at the design stage through normalisation and ensuring that relationships between the relational tables are clearly and appropriately defined. This will ensure the database can cope well with the increase over time instead of becoming too complex to handle.
2. It is of the utmost importance to ensure that health care workers have not only all the required information presented to them about each patient when requested, but also that the information is up-to-date and provided in real-time. This is to ensure that no important decision is taken by a health care worker at the centre based on old information or historical data that is no longer valid.
Although not directly related to database design, another feasibility issue that could impact on how well the design is implemented and how many essential design features are incorporated, is the budget. The MySQL software itself will be free, but the development costs and the cost of the hardware need to be considered. In case the budget is tight then a distinction should be drawn between the most essential elements and features, and extras that can be down without, at least for now. Besides cost, another major constraint is time. The health care centre management must ensure they can have the database developed within the time they have available before it will be required to be ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Database Design Proposal: Analysis Essay Example | Topics and Well Written Essays - 750 words”, n.d.)
Retrieved de
(Database Design Proposal: Analysis Essay Example | Topics and Well Written Essays - 750 Words)
“Database Design Proposal: Analysis Essay Example | Topics and Well Written Essays - 750 Words”, n.d.
  • Cited: 0 times
Comments (1)
Click to create a comment or rate a document
ebailey added comment 1 year ago
Student rated this paper as
I never thought 750 words essay could be written in such a free manner. I loved the background of this essay. Will definitely use it for my own work!

CHECK THESE SAMPLES OF Database Design Proposal: Analysis

Database Design approach is the key for the successful design using UML. Using the object-oriented approach for the database design the object oriented UML database model is presented in Fig 2 below. The aforementioned entity database design is implemented using Oracle and Postgres the interpretation for which is presented in the next section. Object - Relational Analysis Kevin Loney (2004)ii argues that the object relational database implementation using Oracle 10g not only provide the flexibility in the operations of the database in case of editing or updating tables...
14 Pages(3500 words)Essay

Relational Database Design

...Relational Database Design The Design of a Relational Database by This paper describes the process of creating a relational database. Itincludes the SQL code (MySQL) for creating the tables, the joins to create the necessary relationships and the results of those SQL runs. It describes the specifications of the proposed system, the logic of that system, the table definitions and contents, a live transaction which inserts data and one that deletes it and finally a non-trivial query which demonstrates multiple joins, group functions, qualifiers and correlation variables. Relational Database Design The hallmark of the relational database is that when one table changes in the database all other tables are updated and are current. 1... ...
6 Pages(1500 words)Assignment

Database Design & Development

...Relational Database Management System Definition of RDBMS RDBMS can be defined as a set of modules that helps the organization create, maintain database at a single, centralized point. It is a database management system that is based on a popular model of relational model. This model was devised by E. F. Codd. It is a DBMS that manages the data in the form of tables, even the relation that exists between these tables in stored in the form of tables. RDBMS is based on the concept of relational system, referential integrity and normalization (Chaterjee 2005). All data is held in the form of tables and is described by the use of data values. The data which is found in the table columns...
4 Pages(1000 words)Essay

Database systems analysis & design

...System Database Design Report Table of Contents Introduction 3 System Context 3 Stakeholders 3 Requirement Analysis 4 Requirements 4 2.Business Objects (Entities) 4 Database Design 5 1.ERA Diagram 5 1.1.Entity-Relationship Model (ER Model) 6 1.2.Entity-Attribute Model (EA Model) 7 1.3.Entity-Relationship-Attribute Diagram (ERA Diagram) 8 2.Normalization 9 2.1.Un-normalised Form 9 2.2.First Normal Form (1NF) 10 2.3.Second Normal Form (2NF) 11 2.4.Third Normal Form (3NF) 11 Testing 14 Sample Test Data 14 Test Cases 15 Conclusion 18 Introduction This document demonstrates the concept of normalization while designing the conceptual data...
12 Pages(3000 words)Assignment

Database Design and Implementation

...Database Design and Implementation Faculty: Department: Module Academic Year: Semester Data investigation and capture 1 of the three websites chosen 1.1.1 This is an online auction site gaining popularity close to that of e-bay. Even though it does not have as much traffic as e-bay, it generates quite a number of sales. The fact that it does not charge listing fee puts it at a greater competitive edge over the similar online purchasing sites. A major pitfall exists in the payment duration; the buyer’s payment can take up to a fortnight since it goes through Ubid which can cause a serious cash flow problem for the new sellers. 1.1.2 E-bid auction is one of the...
20 Pages(5000 words)Assignment

Database Design Proposal

...Database Design Proposal Database Design Proposal This proposal aims at designing a database for a health organization. The health organization deals with bulky health records of patients and staff every day. Therefore, a database system that keeps proper track of all the activities of the facility is necessary. The proposal seeks to come up with an easy-to-use, fast, secure and reliable system to safeguard health information in the organization (Stubbs & Webre, 2011). It also proposes a system that is cheap to design and...
3 Pages(750 words)Article

Principles of Database Design

...Principles of Database Design Principles Of Database Design Disaster Recovery and Business Continuity Plans Business continuity and disaster recovery refer to the contingency plans and measures designed and executed by a business to guarantee operational flexibility in case of any service interruptions. As information technology systems have become the focus of all areas of business, the capacity to reliably and promptly recuperate these systems have become a vital issue in any business. A Business Continuity Plan identifies a business’ vulnerability to both internal and external threats and manufactures soft and hard assets that offer efficient prevention and recovery for the business. At the same time, it retains value system... ...
2 Pages(500 words)Essay

Database design and SQL Light database creation

.... ER- Entity Relationship Diagram- Shows all the entities and their relations in a given database (Luocopoulos, 1994). Relation schema –This is a table like structure that indicated the data entities and their attributes. A collection of relation schema is called a database schema (Herman balsters, 2001). Works Cited Elmasri, R. (2008). Fundamentals of database Systems,5/E. Pearson Eduction. Herman balsters, B. d. (2001). Database Schema Evoulution and Meta-Modelling. Springer. John W. Satzinger, R. B. (2008). System Analysis and Design in a changing world. Cengage Learning EMEA. Luocopoulos, P. (1994). Entity-Relationship Approach-ER 94.Business Modelling and Egineering. Springer.... Database Schema Sarita Gogan Grand...
3 Pages(750 words)Essay

Database design

...Database design: The database design is a very critical unit for any individual who has interest in the computer technology field. A database system is a worthy asset of any business organization. As such its administration should be effective. For one to ensure effective database management and administration, one need to fully understand the database design. The unit has enabled me gain substantial knowledge on design and management of database. The course gives a detailed introduction of database design. The introduction to database design gave me in-depth understanding of how the idea of database originated from. From the introduction, I learned that the idea of database management system arose as a result of the unending... to...
2 Pages(500 words)Essay

Database Design

...Database design Databases are the key components of successful businesses. They help businesses manage their resources efficiently. This is why pop and mom Enterprise wishes to design the following databaseDatabase Design List of entities and relationships The video store keeps stock of the videos. Customers on the other hand request for the videos. The store then rents the DVDs to the customers. The store maintains names and phone numbers for each customer. Each of the movies/DVDs in the store has a title and a unique movienumber together with serial number from the producer that is used to identify it....
1 Pages(250 words)Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Database Design Proposal: Analysis for FREE!

Contact Us