Database Normalisation Essay

1323 words - 6 pages

Research Paper
Introduction
Database-management system (DBMS) is a collection of interrelated data and a
set of programs to access those data. The collection of data, usually referred to as the database, contains information relevant to an enterprise. The primary goal of a DBMS is to provide a way to store and retrieve database information that is both convenient and efficient.

Database systems are designed to manage large bodies of information. Management of data involves both defining structures for storage of information and providing mechanisms for the manipulation of information. In addition, the database system must ensure the safety of the information stored, despite system ...view middle of the document...

Some applications may require data to be combined from several systems. These several systems could well have data that is redundant as well as inconsistent (that is, different copies of the same data may have different values). Data inconsistencies are often encountered in everyday life. For example, we have all come across situations when a new address is communicated to an organization that we deal with (e.g. a bank, or Telecom, or a gas company), we find that some of the communications from that organization are received at the new address while others continue to be mailed to the old address. Combining all the data in a database would involve reduction in redundancy as well as inconsistency. It also is likely to reduce the costs for collection, storage and updating of data.

2. Better service to the Users
A DBMS is often used to provide better service to the users. In conventional systems, availability of information is often poor since it normally is difficult to obtain information that the existing systems were not designed for. Once several conventional systems are combined to form one centralized data base, the availability of information and its up-to-dateness is likely to improve since the data can now be shared and the DBMS makes it easy to respond to unforseen information requests.
Centralizing the data in a database also often means that users can obtain new and combined information that would have been impossible to obtain otherwise. Also, use of a DBMS should allow users that do not know programming to interact with the data more easily.
The ability to quickly obtain new and combined information is becoming increasingly important in an environment where various levels of governments are requiring organizations to provide more and more information about their activities. An organization running a conventional data processing system would require new programs to be written (or the information compiled manually) to meet every new demand.

3. Flexibility of the system is improved
Changes are often necessary to the contents of data stored in any system. These changes are more easily made in a database than in a conventional system in that these changes do not need to have any impact on application programs.

4. Cost of developing and maintaining systems is lower
As noted earlier, it is much easier to respond to unforseen requests when the data is centralized in a database than when it is stored in conventional file systems. Although the initial cost of setting up of a database can be large, one normally expects the overall cost of setting up a database and developing and maintaining application programs to be lower than for similar service using conventional systems since the productivity of programmers can be substantially higher in using non-procedural languages that have been developed with modern DBMS than using procedural languages.

5. Standards can be enforced
Since all access to the database must...

Other Papers Like Database Normalisation

Jail Responsibilities Essay

589 words - 3 pages Jail Responsibilities Monique Priorello September 23, 2012 One of the main responsibilities of a jail is to give the officers the correct “Police Correspondence” courses. This is because these courses give the officers the effective basic training that they need to do things such as; Writing of Memoranda, Police Reports, and Civilian Letters. What needs to be done first is make sure that there are NO errors. This means in

Mgt330 Essay

638 words - 3 pages Starbucks Nefertiti Wright Sangita Patel October 15, 2012 STARBUCKS 2 STARBUCKS - 1 - [no notes on this page]I. Job description a. Baristas II. Job specifications a. Duties III. Form of departmentalization STARBUCKS 3 Starbucks Starbucks have been named in the 100 best companies to work for. Starbucks has many job opportunities for people, which require the right job specifications. The employees create uplifting experience

Fight Club

917 words - 4 pages Fight Club is a story of the narrator’s struggle to gain control over his life. He is in search for an identity in the form of manhood. His masculinity is so repressed because of the absence of a father figure in his life. Because of this he creates Tyler, his alternate personality. Tyler is nothing like anyone the narrator has met, he is self assured and completely free. The narrators alternate personality Tyler Durden is the ultimate alpha-male

The Powers Of The Health And Safety Representative

254 words - 2 pages The Powers of the Health and Safety Representative A health and safety representative has the power to: Identify Workplace Hazards The health and safety representative has the power to identify workplace hazards. This power is usually exercised by conducting workplace inspections. Obtain Information from the Employer The health and safety representative is entitled to the same information available to a joint committee member. Under the Act

Lesson Plan

6476 words - 26 pages QWERTYUIOP by Vivien Alcock Table of Contents Introduction About Short Stories The Writer Synopsis Elements Activities Beyond The Text Assessment Answer Key Glossary Panel of Writers [pic] SHORT STORY Welcome to the World of Literature and to Short Stories! We hope you will enjoy working with this guidebook, which has been specially designed to help you prepare your students enjoy the Literature

Management

1227 words - 5 pages Coca-Cola Global Business and Marketing Strategy Introduction As domestic markets mature, it is becoming more and more fashionable for organisations to seek growth through opportunities in foreign countries. Faster communication, new technologies and improved transport links are making international markets more accessible and businesses pursuing a global position can experience an upsurge in brand awareness and cost effectiveness. Global

Facing Poverty With A Rich Girl's Habit

783 words - 4 pages Facing poverty with a rich girl’s habit Adele Strader Professor Chryst English Composition October 22, 2012 Facing poverty with a rich girl’s habit was written by Suki Kim and published in the New York Times on November 21, 2004. The most important point that Suki want to make was that (1) what we have in life can be taken away in an instant (2) do not go bankrupt in South Korea (3) that a person must adapt and endure

3-4-50 Paper

572 words - 3 pages -4-50 paperLack of exercise is a key contributor to disease and death among many people in the United States, regardless of age. It is a well-known fact that exercise results in a healthier lifestyle. Along with tobacco use and poor nutrition, lack of exercise is one of the main issues that people have which leads to high blood pressure, obesity, and other serious health problems. According to a study by UCSD School of Medicine and SDSU

Capitalism

836 words - 4 pages Miguel Beatrice Capitalism is an economic system in which private individuals and business firms carry out production and exchange of goods and services through complex transactions involved in prices and markets. By extension called capitalist higher social class of this economic system ("bourgeoisie"), or to the common form would the individual interests of capital owners in both companies, shareholders and patterns, also called capitalism

Sociology

1177 words - 5 pages “Housing First” Approach. Retrieved from the Films on Demand database. Burt, M., Aron Y. L., and Lee E. (2011). Helping America's Homeless: Emergency Shelter or Affordable Housing. Urban Institute. Retrieved from http://www.urban.org/pubs/homeless/chapter1.html. Korgen, K. & Furst, G. (2012). Social problems: Causes & responses. San Diego, CA: Bridgepoint Education, Inc. Retrieved from the University Online Library. Ravenhill, M. (2011). The Culture of Homelessness. Ashgate Publishing Limited Gower House. Retrieved from http://homelessmann@ashgate.com.

Mental Health Community Service Essay

509 words - 3 pages Ladesca Smith Nursing 162 Community Volunteer Service Assignment Why you chose this agency? I chose this Sharing God’s Love, because I was interested in what kind of services they provide. I also wanted to know if there was any help out there for the people in need with mental illnesses. I also had lots of my kid’s old clothing that I needed to get rid of, so I donated it to them. Describe the population the agency serves. The

Related Essays

Lafarge S.A Essay

2924 words - 12 pages NAME: IHEKANANDU KINGSLEY N. COURSE: MGMT 292 / F12 N01 TITLE: INDIVIDUAL CASE STUDY (LAFARGE S.A.) SUBMITTED: October 5, 2012 TABLE OF CONTENTS 2. INTRODUCTION 3 3. DESCRIPTION OF CASE 4 4. VALUES 4 4.1. Types of values 4 5. TEAMWORK 7 6. MOTIVATION 8 7. CREATIVITY 9 7.1. Components of creativity 9 8. CONCLUSION 12 9. BIBLIOGRAPHY 13 INTRODUCTION This report aims to provide an in-depth analysis of initiatives pursued by Lafarge as

Finance Essay

665 words - 3 pages Financial statements are the most common tool used for making business decisions. They consist of the balance sheet, income statement and statement of cash flows. The analysis tools used affect all aspects of a company not just a few. A systematic review of the resources a company used to achieve its mission is cost control. Cash flow should be kept at necessary levels for operations is one of the major benefits of cost control. It is a very

Analysis Of Operation Blue Star And Its Effects On The Gandhi Dynasty

934 words - 4 pages The period of time including and following Operation Blue star is considered a dark time in India and black spot in Indian history. It is a time Indian would rather forget, yet still to this day debate about. Was Indihar Gandhi correct in instating operation Blue Star, inflicting damage to the Golden temple, and being responsible for the killing of anywhere from 492 (official reports) to 1500 (estimates run as high as) civilians, which lead to an

Regretful Decisions Essay

930 words - 4 pages Regretful Decisions There are many individuals in a child’s life that helps mold them into a well-rounded adult. In most cases, this guidance comes from the child’s parents or other older, but in Sonny’s case, this guidance was expected from his older brother. In the short narrative, Sonny’s Blues, Sonny’s life was adversely affected by the decisions that his older brother made. The decisions that his brother made include leaving Sonny to stay