What does second normal form mean?

Definitions for second normal form
sec·ond nor·mal form

This dictionary definitions page includes all the possible meanings, example usage and translations of the word second normal form.

Wiktionary

  1. second normal formnoun

    A stage in the normalization of a relational database in which it is in first normal form and every non-key attribute is dependent upon the entire primary key.

Wikidata

  1. Second normal form

    Second normal form is a normal form used in database normalization. 2NF was originally defined by E.F. Codd in 1971. A table that is in first normal form must meet additional criteria if it is to qualify for second normal form. Specifically: a table is in 2NF if and only if it is in 1NF and no non-prime attribute is dependent on any proper subset of any candidate key of the table. A non-prime attribute of a table is an attribute that is not a part of any candidate key of the table. Put simply, a table is in 2NF if and only if it is in 1NF and every non-prime attribute of the table is dependent on the whole of a candidate key. Note that when a 1NF table has no composite candidate keys, the table is automatically in 2NF.

How to pronounce second normal form?

How to say second normal form in sign language?

Numerology

  1. Chaldean Numerology

    The numerical value of second normal form in Chaldean Numerology is: 7

  2. Pythagorean Numerology

    The numerical value of second normal form in Pythagorean Numerology is: 5

Translation

Find a translation for the second normal form definition in other languages:

Select another language:

  • - Select -
  • 简体中文 (Chinese - Simplified)
  • 繁體中文 (Chinese - Traditional)
  • Español (Spanish)
  • Esperanto (Esperanto)
  • 日本語 (Japanese)
  • Português (Portuguese)
  • Deutsch (German)
  • العربية (Arabic)
  • Français (French)
  • Русский (Russian)
  • ಕನ್ನಡ (Kannada)
  • 한국어 (Korean)
  • עברית (Hebrew)
  • Gaeilge (Irish)
  • Українська (Ukrainian)
  • اردو (Urdu)
  • Magyar (Hungarian)
  • मानक हिन्दी (Hindi)
  • Indonesia (Indonesian)
  • Italiano (Italian)
  • தமிழ் (Tamil)
  • Türkçe (Turkish)
  • తెలుగు (Telugu)
  • ภาษาไทย (Thai)
  • Tiếng Việt (Vietnamese)
  • Čeština (Czech)
  • Polski (Polish)
  • Bahasa Indonesia (Indonesian)
  • Românește (Romanian)
  • Nederlands (Dutch)
  • Ελληνικά (Greek)
  • Latinum (Latin)
  • Svenska (Swedish)
  • Dansk (Danish)
  • Suomi (Finnish)
  • فارسی (Persian)
  • ייִדיש (Yiddish)
  • հայերեն (Armenian)
  • Norsk (Norwegian)
  • English (English)

Word of the Day

Would you like us to send you a FREE new word definition delivered to your inbox daily?

Please enter your email address:


Citation

Use the citation below to add this definition to your bibliography:

Style:MLAChicagoAPA

"second normal form." Definitions.net. STANDS4 LLC, 2024. Web. 19 Mar. 2024. <https://www.definitions.net/definition/second+normal+form>.

Discuss these second normal form definitions with the community:

0 Comments

    Are we missing a good definition for second normal form? Don't keep it to yourself...

    Free, no signup required:

    Add to Chrome

    Get instant definitions for any word that hits you anywhere on the web!

    Free, no signup required:

    Add to Firefox

    Get instant definitions for any word that hits you anywhere on the web!

    Browse Definitions.net

    Quiz

    Are you a words master?

    »
    clothing that is worn or carried, but not part of your main clothing
    A mediocrity
    B apex
    C rapture
    D accessory

    Nearby & related entries:

    Alternative searches for second normal form: