Editing Relational database (section)

==Terminology==
[[Image:Relational database terms.svg|350px|thumb|right|Relational database terminology]]
The relational database was first defined in June 1970 by [[Edgar F. Codd|Edgar Codd]], of IBM's [[IBM Almaden Research Center|San Jose Research Laboratory]].<ref name="codd">{{cite journal |last=Codd |first=E. F. |author-link=Edgar F. Codd |year=1970 |title=A Relational Model of Data for Large Shared Data Banks |journal=[[Communications of the ACM]] |doi=10.1145/362384.362685 |volume=13 |number=6 |pages=377–387|s2cid=207549016 |doi-access=free }}</ref> Codd's view of what qualifies as an RDBMS is summarized in [[Codd's 12 rules]]. A relational database has become the predominant type of database. Other models besides the ''relational model'' include the [[hierarchical database model]] and the [[network model]].

The table below summarizes some of the most important relational database terms and the corresponding [[SQL]] term:

{| class="wikitable"
|-
! SQL term
! Relational database term
! Description
|-
| [[Row (database)|'''''Row''''']]
| '''''[[Tuple]]''''' or [[Record (computer science)|'''''record''''']]
| A data set representing a single item
|-
| [[Column (database)|'''''Column''''']]
| '''''Attribute''''' or '''''field'''''
| A labeled element of a tuple, e.g. "Address" or "Date of birth"
|-
| [[Table (database)|'''''Table''''']]
| [[Relation (database)|'''''Relation''''']] or [[relvar|'''''Base relvar''''']]
| A set of tuples sharing the same attributes; a set of columns and rows
|-
| [[View (SQL)|'''''View''''']] or '''''[[result set]]'''''
| '''''Derived relvar'''''
| Any set of tuples; a data report from the RDBMS in response to a [[query language|query]]
|}