Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

First normal form

Index First normal form

First normal form (1NF) is a property of a relation in a relational database. [1]

19 relations: Array data structure, Christopher J. Date, Column (database), Data domain, Database normalization, Edgar F. Codd, Hugh Darwen, International Standard Book Number, Isomorphism, Null (SQL), Relation (database), Relational database, Relational model, Second normal form, SQL, SQL:2003, Third normal form, Tuple, View (SQL).

Array data structure

In computer science, an array data structure, or simply an array, is a data structure consisting of a collection of elements (values or variables), each identified by at least one array index or key.

New!!: First normal form and Array data structure · See more »

Christopher J. Date

Chris Date (born 1941) is an independent author, lecturer, researcher, and consultant, specializing in relational database theory.

New!!: First normal form and Christopher J. Date · See more »

Column (database)

In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database.

New!!: First normal form and Column (database) · See more »

Data domain

In data management and database analysis, a data domain refers to all the values which a data element may contain.

New!!: First normal form and Data domain · See more »

Database normalization

Database normalization is the process of restructuring a relational database in accordance with a series of so-called normal forms in order to reduce data redundancy and improve data integrity.

New!!: First normal form and Database normalization · See more »

Edgar F. Codd

Edgar Frank "Ted" Codd (19 August 1923 – 18 April 2003) was an English computer scientist who, while working for IBM, invented the relational model for database management, the theoretical basis for relational databases and relational database management systems.

New!!: First normal form and Edgar F. Codd · See more »

Hugh Darwen

Hugh Darwen is a computer scientist who was an employee of IBM United Kingdom from 1967.

New!!: First normal form and Hugh Darwen · See more »

International Standard Book Number

The International Standard Book Number (ISBN) is a unique numeric commercial book identifier.

New!!: First normal form and International Standard Book Number · See more »

Isomorphism

In mathematics, an isomorphism (from the Ancient Greek: ἴσος isos "equal", and μορφή morphe "form" or "shape") is a homomorphism or morphism (i.e. a mathematical mapping) that can be reversed by an inverse morphism.

New!!: First normal form and Isomorphism · See more »

Null (SQL)

Null (or NULL) is a special marker used in Structured Query Language to indicate that a data value does not exist in the database.

New!!: First normal form and Null (SQL) · See more »

Relation (database)

In relational database theory, a relation, as originally defined by E. F. Codd, is a set of tuples (d1, d2,..., dn), where each element dj is a member of Dj, a data domain.

New!!: First normal form and Relation (database) · See more »

Relational database

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.

New!!: First normal form and Relational database · See more »

Relational model

The relational model (RM) for database management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations.

New!!: First normal form and Relational model · See more »

Second normal form

Second normal form (2NF) is a normal form used in database normalization.

New!!: First normal form and Second normal form · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: First normal form and SQL · See more »

SQL:2003

SQL:2003 is the fourth revision of the SQL database query language.

New!!: First normal form and SQL:2003 · See more »

Third normal form

Third normal form (3NF) is a normal form that is used in normalizing a database design to reduce the duplication of data and ensure referential integrity by ensuring that (1) the entity is in second normal form, and (2) all the attributes in a table are determined only by the candidate keys of that relation and not by any non-prime attributes.

New!!: First normal form and Third normal form · See more »

Tuple

In mathematics, a tuple is a finite ordered list (sequence) of elements.

New!!: First normal form and Tuple · See more »

View (SQL)

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

New!!: First normal form and View (SQL) · See more »

Redirects here:

1NF, 1st normal form.

References

[1] https://en.wikipedia.org/wiki/First_normal_form

OutgoingIncoming
Hey! We are on Facebook now! »