codd's first normal form
Transcription
-
- US Pronunciation
- US IPA
-
-
- US Pronunciation
- US IPA
-
Definitions of codd's first normal form words
- abbreviation Technical meaning of CODD'S FIRST NORMAL FORM database normalisation 3
- noun Definition of codd's first normal form in Technology (database) A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the chances of data becoming inconsistent. A table in a relational database is said to be in normal form if it satisfies certain constraints. Codd's original work defined three such forms but there are now five generally accepted steps of normalisation. The output of the first step is called First Normal Form (1NF), the output of the second step is Second Normal Form (2NF), etc. First Normal Form eliminates repeating groups by putting each value of a multi-valued attribute into a new row. Second Normal Form eliminates functional dependencies on a partial key by putting the fields in a separate table from those that are dependent on the whole key. Third Normal Form eliminates functional dependencies on non-key fields by putting them in a separate table. At this stage, all non-key fields are dependent on the key, the whole key and nothing but the key. Fourth Normal Form separates independent multi-valued facts stored in one table into separate tables. Fifth Normal Form breaks out data redundancy that is not covered by any of the previous normal forms. 1
Information block about the term
Parts of speech for Codd's first normal form
noun
adjective
verb
adverb
pronoun
preposition
conjunction
determiner
exclamation
See also
Matching words
- Words starting with c
- Words starting with co
- Words starting with cod
- Words starting with codd
- Words starting with codds
- Words starting with coddsf
- Words starting with coddsfi
- Words starting with coddsfir
- Words starting with coddsfirs
- Words starting with coddsfirst
- Words starting with coddsfirstn
- Words starting with coddsfirstno
- Words starting with coddsfirstnor
- Words starting with coddsfirstnorm
Was this page helpful?
Thank you for your feedback! Tell your friends about this page
Tell us why?