Purchase Solution

Second Normal Form versus Third Normal Form

Not what you're looking for?

Ask Custom Question

Create a table that is 2NF, but is not 3NF. Explain what is wrong with the table, and what needs to be done to correct the situation.

Purchase this Solution
Solution Summary

The solution helps explain how to create the 2nd Normal Form and identify what needs to be corrected in the table to change to 3rd Normal Form.

Solution Preview

Create a table that is 2NF, but is not 3NF. Explain what is wrong with the table, and what needs to be done to correct the situation.
Normalization in database design is a process that helps in checking the quality of relations between or amongst entities in the database. In this process relations with problems are converted to relations with lesser problems or anomalies. This thought leads to the number of normal forms that a database can be designed in. A database generally begins with the First Normal Form as coined by database guru E.F. ...

Purchase this Solution
Free BrainMass Quizzes
C# variables and classes

This quiz contains questions about C# classes and variables.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Basic Networking Questions

This quiz consists of some basic networking questions.

View More Free Quizzes
Related BrainMass Solutions

  • real world example that demonstrates one of the normal forms

    The Second Normal Form: The second normal form (2NF) requires that all the fields in the database contain data that depends on the entire primary key.

  • Normalize a Table: Sales Invoice Information

    Third Normal Form: A relation R is in third normal form if and only if it is in 2NF and every non-key attribute is non-transitively dependent on the primary key.

  • The Relational Model and Data Normalization

    Relations in second normal form can also have anomalies. Third normal form: a relation is in third normal form if it is in second normal form and has no transitive dependencies. Question 4.

  • Designing a database for university

    This in-depth solution of 650 words describes database design for first normal form, second normal form, and third normal form. All characteristics of the database are listed.

  • An explanation of database normalization with and example

    The normal forms are cumulative so that Second Normal Form honors all of the rules of First Normal Form and Third honors all of Second, and so on. Each normal form adds more rules and constraints to a database.

  • Entity Relationship

    If a table is in first normal form (1NF) and has a primary key consisting of a single column, the table: a. is at most in first normal form. b. is also in second normal form. c. cannot be in third normal form.

  • Normalization within Database

    Codd, "Further Normalization of the Data Base Relational Model"[7] 2NF Second normal form means that it is in 1NF and every non-prime attribute of the relation is dependent on the whole of every candidate key. 3NF Third normal form is to ensure

  • Discussing the Concept of Normalization

    - Second Normal Form (2NF): Each field in a table that is not a determiner of the contents of another field must itself be a function of the other fields in the table. - Third Normal Form (3NF): No duplicate information is permitted.

  • Sales Invoice Normalisation

    normal form.

  • A detailed example of form validation with javascript

    Third, an "event handler" needs to be added to the form so that the validation script will run before the form is submitted.

View More Related Solutions