Essay on Databases: Database Normalization and Data

Submitted By Gwest52
Words: 1490
Pages: 6
Open Document
Databases: Concept, Design, and Functionality

A relational database is a maintained collection of separate, related tables containing data stored in fields (columns) called attributes and records (rows) called records (Definition Rel DB, 2014). Relationships between the tables are created by utilizing a common field or key. Keys are data points used to identify unique values or records within tables, and provide a logical method to access a record within the table (Gilfillan, 2002). A primary key is a qualifier chosen to identify a unique individual record in a particular table. The table containing the primary key is related to one or more additional tables utilizing fields that are common to them (Gilfillan, 2002). This common field must be the primary key for the related table and is called a foreign key. Foreign keys allow the relation between the tables and secure the integrity of the data referenced. Foreign keys also allow the user to delete or update the database by removing or amending a record in one table which then cascades through relevant tables executing the deletion or update (Gilfillan, 2002).
The use of a database management system (DBMS) allows the user to store, maintain, and retrieve information using transactions. Transactions are one or multiple SQL statements(s) that compose a logical entity of work (Oracle, 2014). The use of relational databases allows entities to store large amounts of information in a standardized process, manage the stored data in an efficient manner, and access the relevant, up-to-date information using a simple query. Relational databases enable users, through the use of targeted queries, quickly to retrieve the pertinent information related within the database without conducting multiple searches through data files. Use of relational databases streamlines data entry, records maintenance, and access to information thereby increasing productivity and reducing redundancy through the elimination of duplication (effort and data storage).
Normalization is the mechanism in which data contained in the database is organized, removing inconsistencies and redundancies to protect the data content and make the database more flexible (Microsoft, 2013). Database experts developed a number of rules, known as normal forms, devised to eliminate errors during normalization. Normal forms are incorporated to assess and correct table structure to reduce data redundancies, thereby decrease the chance for anomalies (Carpenter, 2008). There are seven normal forms; however, only three are recognized as critical in the development of a properly functioning database.
The first normal form involves the removal of repeating data, ensuring each attribute expresses only a single value, arrays/groups are not repeated, and that each record is unique. Do not use multiple fields in one table to store like data, use separate tables when needed, identifying the related datasets with a primary key (Microsoft, 2013).
The second normal form eliminates functional discrepancies, related attributes within a table that are dependent on one another and not solely on the key. By utilizing rules for the second form, separate attributes should be given their own entities to remove functional discrepancies thereby ensuring members are dependent on the key. Create a separate table for sets of values that apply to several records and relate the tables with a foreign key (Microsoft, 2013).
Third normal form seeks to eliminate transitive dependencies, attributes that are dependent on another attribute for its meaning, instead of the primary key. Every attribute should describe the entity, not another attribute. Eliminate or move, (new table), attributes that are not dependent on the primary key (Sarkar, 2006).
Normal forms 4 through 7, Boyce-Codd Normal Form (BCNF), fifth normal form (Project-Join Normal Form), sixth normal form, and Domain-Key Normal Form (DKNF) are higher normal forms and not used as
Show More

Related Documents: Essay on Databases: Database Normalization and Data

CSC316 mod 4 Case Essay

Trident University Anuj Kainth Module 4 Case CSC 316 – Database Systems I Professor: Michael J. Pelosi 2 March 2014 Acid and Normalization Normalizing the Database Simply put, normalization is a formal process for determining which fields belong in which tables in a relational database. Normalization ensures that you get the benefits relational databases offer (Beckett, 1997). Normalizing the tables can be done by eliminating repeating groups, identifying the…

Words 525 - Pages 3

The principles and importance of normal Essay

importance of normalization Steven Smith, Andrew Sandoval, Michael Mojica, Jason Price DBM/380 18 March 2013 Dr. Goodwin The principles and importance of normalization The task assigned in Service Request SR-ht-003, “Develop a Design for a Fleet Truck Maintenance Database” for Huffman Trucking has been created. This paper will give a description and show the importance of normalization in relationship to this project and address the process by which the project was normalized. Normalization is considered…

Words 323 - Pages 2

Normalization In Database Design

Normalization is an important part of database design. Research and comment on Normalization and any experience that you may have had with this technique.

 The concept of improving a database through normalization revolves around the ideas of efficiency and relationship building. Normalization improves design and is widely used. Two goals exist in this pursuit; they are “eliminating redundant data…and ensuring dependencies make sense (only storing related data in a table)” (Chapple, 2013). Redundancies…

Words 328 - Pages 2

Essay about Database Normalization and Table

Normalization Normalization is the process of organizing data in a database. This includes creating tables and establishing relationships between those tables according to rules designed both to protect the data and to make the database more flexible by eliminating redundancy and inconsistent dependency. Redundant data wastes disk space and creates maintenance problems. If data that exists in more than one place must be changed, the data must be changed in exactly the same way in all locations…

Words 1127 - Pages 5

Essay about Huffman Trucking Service Request HT

SR-HT-03 Huffman trucking is in need of a change that will help the company organize their data for maintenance and parts on their vehicles. The company has put in a service request for a database that will help the company improve efficiency and maintain records while also helping by increasing productivity. The service request includes several steps that need to be taken in order to complete this task. “The database development process consists of three major stages: requirements, design, and implementation”…

Words 1284 - Pages 6

Normalization Of Database Tables

Chapter 5 Normalization of Database Tables Discussion Focus Why are some table structures considered to be bad and others good and how do you recognize the difference between good and bad structures? From an information management point of view, possibly the most vexing and destructive problems are created through uncontrolled data redundancies. Such redundancies produce update and delete anomalies that create data integrity problems. The loss of data integrity can destroy the usefulness…

Words 10105 - Pages 41

Cs251 Fundamantals of Database Systems Ip 1 - 5 Essay

CS251-1301B-03 Fundamentals of Database Systems Phase 1 -5 Individual Project Robert March 24th, 2013 Table of Contents Project Outline 3 Description of the Database Design Life Cycle 4 The Entity Relationship Diagram 7 The Logical Model and Normalization 9 The Microsoft Access Database 11 The Microsoft Access Database Application 14 References: 18 Project Outline My idea for a project concept is for a granite fabrication and installation company called MasterStoneWorks…

Words 1684 - Pages 7

Fundamentals of Database Systems Key Assignment Essay examples

Key Assignment Project Fundamentals of Database Systems CS251-1202B-03 June 25, 2012 Table of Contents Project Outline 4 Description of the Database Design Life Cycle (Phase 1 IP) 4 Selected Database Description 4 Tablet and Capsule Antibiotics 4 Powder and Liquid Antibiotics 5 Skin and Coat 5 A Listing And Description Of The 7 Steps Of The SDLC/DBDSL and Their Tasks 6 System Requirements Analysis and Feasibility Study 6 System Analysis 7 Code Generation and Design 9 Implementation…

Words 3571 - Pages 15

Course Notes Essay

A Report - Output of summary material from data. Work Shadowing - The act of following someone, as he or she performs the duties of his or her job, to see what the job entails and what actions he or she typically performs during the workday Data integrity - Refers to the accuracy and quality of the data. Normalization – The process of decomposing relations with…

Words 664 - Pages 3

Data Management and Decision Making Essay

Intelligence: Databases and Information Management Wienand Omta Fabiano Dalpiaz 1 drs. ing. Wienand Omta Learning Objectives      2 Describe how the problems of managing data resources in a traditional file environment are solved by a database management system. Describe the capabilities and value of a database management system. Apply important database design principles. Evaluate tools and technologies for accessing information from databases to improve business…

Words 2085 - Pages 9