Preview

Normalization of Database Management Systems

Satisfactory Essays
Open Document
Open Document
989 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Normalization of Database Management Systems
Normalization of Database Tables

Database Tables and Normalization

* Normalization is a process for assigning attributes to entities. It reduces data redundancies and helps eliminate the data anomalies. * Normalization works through a series of stages called normal forms: * First normal form (1NF) * Second normal form (2NF) * Third normal form (3NF) * Fourth normal form (4NF) * The highest level of normalization is not always desirable.

* The Need for Normalization * Case of a Construction Company * Building project -- Project number, Name, Employees assigned to the project. * Employee -- Employee number, Name, Job classification * The company charges its clients by billing the hours spent on each project. The hourly billing rate is dependent on the employee’s position. * Periodically, a report is generated. * The table whose contents correspond to the reporting requirements is shown in Table 5.1.

Scenario

A few employees works for one project.
Employee Num : 101, 102, 103, 105 Project Num : 15 Project Name : Evergreen

Sample Form

Table Structure Matches the Report Format

Database Tables and Normalization * Problems with the Figure 5.1 * The project number is intended to be a primary key, but it contains nulls. * The table displays data redundancies. * The table entries invite data inconsistencies. * The data redundancies yield the following anomalies: * Update anomalies. * Addition anomalies. * Deletion anomalies.

* Conversion to First Normal Form * A relational table must not contain repeating groups. * Repeating groups can be eliminated by adding the appropriate entry in at least the primary key column(s).

Data Organization: First Normal Form

BEFORE

AFTER

First Normal Form ( 1 NF )

* 1NF Definition

You May Also Find These Documents Helpful

  • Powerful Essays

    Music

    • 1176 Words
    • 5 Pages

    | Primary Key – may contain alpha and numeric. You create this, do not use autonumber.…

    • 1176 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    PT2520 Week 3 Forum

    • 190 Words
    • 1 Page

    Normalization is a process for evaluating and correcting table structures to minimize data redundancies and by helping to eliminate data anomalies. It helps evaluate table structures and produce good tables.…

    • 190 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    4 Dep

    • 897 Words
    • 4 Pages

    Use this table as the structure for your report. Use the headings provided to structure your report.…

    • 897 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    16 F | You should limit repetition of attributes to the repetition of the primary key as a foreign key in a related table.…

    • 313 Words
    • 1 Page
    Satisfactory Essays
  • Better Essays

    Normalization of the database: This is a critical step for making the database. Normalization will help create table structures as well…

    • 3100 Words
    • 13 Pages
    Better Essays
  • Satisfactory Essays

    This memo is to inform you that your service request SR-ta-001 has reached my desk and currently is in the process of being completed. The purpose of this memo is to report the progress on the service requests. Currently I am in the stage of normalizing the database to the third normal form. By normalizing the database to the third level of normalization I will ensure that the data is efficiently organized within the database by removing duplicate and redundant data from the database relations. Normalizing the data to the normal third will help free up space and make it easier for the users to retrieve the data by elimination of the same data stored in more than one relation. In addition, normalizing to this level will also ensure data integrity, scalability, and storage efficiency. I have made sure that that there are no repeating columns or rows within the same tables and each column has only one value and one data type therefore the level of 1 normalization has been completed. I then continued to normalize the database to the second level of normalization by ensuring that each nonkey attribute is fully dependent on the key columns of the table. Once level one and two normal form had been completed I continued by establishing primary and foreign keys along with relationships. I will keep in contact with you as the project nears completion.…

    • 329 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    The database design team transforms entities into tables and expresses relationships by defining foreign keys. The tables in the model are to be normalized before converting them into designs. Normalization is the process of converting poorly structured tables into two or more well-structured tables. Database practitioners classify tables into various normal forms according to the kinds of problems they have. Transforming a table into a normal form to remove duplicated data and other problems is called normalizing the table. After normalizing, the designer should represent the relationship among those tables to complete the design.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Good Essays

    * Each row of the table holds data that pertain to some entity or a portion of some entity…

    • 805 Words
    • 4 Pages
    Good Essays
  • Good Essays

    The project for the implementation of our new system for billing and customer management is approaching completion. At the moment, the application has passed the user acceptance testing stage and the hardware is already in place. During the development of the system, the team realized that the existing database platform was inadequate to the new system; hence, they suggested using more modern database environment which will cost the company additional licensing costs.…

    • 681 Words
    • 3 Pages
    Good Essays
  • Better Essays

    Relational Databases

    • 4830 Words
    • 20 Pages

    Contrast the logical and the physical view of data and discuss why separate views are necessary in database applications. Describe which perspective is most useful for each of the following employees: a programmer, a manager, and an internal auditor. How will understanding logical data structures assist you when designing and using database systems?</para></question><question id="ch04ques02" label="4.2">…

    • 4830 Words
    • 20 Pages
    Better Essays
  • Good Essays

    First normal form (1NF) sets the very basic rules for organized databases. These rules eliminate duplicative columns from the same table and creates separate tables for each group of related data and identify each row with a unique column or set of columns known as the primary key. The basic objective of the first normal form defined by Codd was to permit data to be queried and manipulated using a “universal data sub-language” such as SQL. One of Codd’s important insights was that the structural complexity could always be removed, leading to a much greater power and flexibility in the way queries could be formulated and evaluated.…

    • 505 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Potato Lab Write Up

    • 1353 Words
    • 6 Pages

    Tables are used to organize numerical data. They are referred to as Table 1, Table 3 etc. and should also be numbered in the order they are referred to in the report. Tables should have captions that identify the data they contain. Pay attention to numbers and units in tables.…

    • 1353 Words
    • 6 Pages
    Good Essays
  • Better Essays

    Music Contract

    • 911 Words
    • 4 Pages

    Session charges are based on an hourly rate. If the session runs over to the next hour due to the client’s organisation then an additional hour will be charged to the client.…

    • 911 Words
    • 4 Pages
    Better Essays
  • Powerful Essays

    REPORT ON PRO E

    • 1655 Words
    • 7 Pages

    You can generate several kinds of output using Pro/REPORT such as family tables, associative reports, and…

    • 1655 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    Standardisation of DBMS

    • 298 Words
    • 2 Pages

    An early proposal for a standard terminology and general architecture database a system was produced in 1971 by the DBTG (Data Base Task Group) appointed by the Conference on data Systems and Languages. The DBTG recognized the need for a two level approach with a system view called the schema and user view called subschema. The American National Standard Institute terminology and architecture in 1975.ANSI-SPARC recognized the need for a three level approach with a system catalog.…

    • 298 Words
    • 2 Pages
    Satisfactory Essays

Related Topics