Here is the synopsis of our sample research paper on Database Normalization. Have the paper e-mailed to you 24/7/365.
Essay / Research Paper Abstract
A 3 page research paper that briefly discuses the database normalization process, defining it and explaining what is meant by the first three normalization forms. Bibliography lists 3 sources.
Page Count:
3 pages (~225 words per page)
File: D0_khxnf.rtf
Buy This Term Paper »
Unformatted sample text from the term paper:
thereby ensuring that "data dependencies make sense" (Chapple, 2008). Normal forms, as "defined in relational database theory," offer guidelines for accomplishing these goals (Kent, 1996). Coulson (2008) makes theses
goals clear in his tutorial on the first three normal forms by relating them to the task of recording business invoice data within a database. He posited that "Those of
us who have an ordered mind but arent quite aware of relational databases might try to capture the Invoice data in a spreadsheet, such as Microsoft Excel" (Coulson, 2008). While
this is a logical approach, which records the information, it becomes problematic when users want the answers to complicated questions, such as how many purchases of a specific item were
made in total by all buyers on a specific date (Coulson, 2008). Normalization of a database organizes the information in a manner that makes providing the answers to complicated questions
possible. The first normal form dictates the "shape of a record type" by eliminating repeating fields and groups (Kent, 1996). Furthermore, a feature of the first normal form is that
there should be no repeating groups of similar data in any row. This is referred to as "atomicity" (Coulson, 2008). Rather than a spreadsheet format, the data is expressed in
a "relational database management system" (RDBMS) (Coulson, 2008). This form establishes the fundamental rules for organizing the database by eliminating any duplicated columns within the same tables and also
creating separate tables for "each group of related data," as well as identifying each row with a "unique column or set of columns," which is referred to as the
"primary key" (Chapple, 2008). A "primary key" is a unique identifier for a row of data (Coulson, 2008). When a primary keys value consists of two or more columns, it
...