The Oracle Guru Answer #2

The Oracle Guru Were you correct? This week's answer is:
b. 2NF

When designing a table, the second normal form (2NF) is the level of normalization where each column in a table that is not a determiner of the contents of another column must itself be a function of the other columns in the table. At 2NF, modifications are still possible because a change to one row in a table may affect data that refers to this information from another table.

Normalization degrees of relational database tables have been defined and also include:

  • The first normal form (1NF) is the "basic" level of normalization and generally corresponds to the definition of any database.

  • The third normal form (3NF), is the level where tables would be divided into two so that specific information could be tracked separately.

  • The domain/key normal form (DKNF) enables you to enforce key and domain restrictions, so the database is assured of being freed from modification anomalies.
  • Click for the full definitions.

    For More Information:

    Best Web Links: Normalization
    White paper: Database normalization tips
    Tip: Introduction to Oracle design
    Discussion forum: Talk about normalization in the Oracle Database Administration discussion forum.
    Let us know if you have an idea for a quiz question topic.

    This was first published in July 2003

    There are Comments. Add yours.

    TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

    REGISTER or login:

    Forgot Password?
    By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
    Sort by: OldestNewest

    Forgot Password?

    No problem! Submit your e-mail address below. We'll send you an email containing your password.

    Your password has been sent to: