Row ( database ) - wikipedia Row ( database ) This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. ( December 2009 ) In the context of a relational database, a row -- also called a record or tuple -- represents a single, implicitly structured data item in a table. In simple terms, a database table can be thought of as consisting of rows and columns or fields. Each row in a table represents a set of related data, and every row in the table has the same structure. For example, in a table that represents companies, each row would represent a single company. Columns might represent things like company name, company street address, whether the company is publicly held, its VAT number, etc... In a table that represents the association of employees with departments, each row would associate one employee with one department. In a less formal usage, e.g. for a database which is not formally relational, a record is equivalent to a row as described above, but is not usually referred to as a row. The implicit structure of a row, and the meaning of the data values in a row, requires that the row be understood as providing a succession of data values, one in each column of the table. The row is then interpreted as a relvar composed of a set of tuples, with each tuple consisting of the two items : the name of the relevant column and the value this row provides for that column. Each column expects a data value of a particular type. For example, one column might require a unique identifier, another might require text representing a person 's name, another might require an integer representing hourly pay in cents. Does not appear Column 1 Column 2 Row ( Record ) 1 Row 1, Column ( Field ) 1 Row 1, Column 2 Row 2 Row 2, Column 1 Row 2, Column 2 Row 3 Row 3, Column 1 Row 3, Column 2 See also Column ( database ) Field ( computer science ) Record ( computer science ) References Jump up ^ `` What is a database row ? '' Cory Janssen, Techopedia, retrieved 27 June 2014 Database management systems Types Object - oriented comparison Relational comparison Document - oriented Graph NoSQL NewSQL Concepts Database ACID Armstrong 's axioms CAP theorem CRUD Null Candidate key Foreign key Superkey Surrogate key Unique key Objects Relation table column row View Transaction Transaction log Trigger Index Stored procedure Cursor Partition Components Concurrency control Data dictionary JDBC XQJ ODBC Query language Query optimizer Query plan Functions Administration and automation Query optimization Replication Related topics Database models Database normalization Database storage Distributed database Federated database system Referential integrity Relational algebra Relational calculus Relational database Relational DBMS Relational model Object - relational database Transaction processing GND : 4011133 - 7 Retrieved from `` https://en.wikipedia.org/w/index.php?title=Row_(database)&oldid=808954630 '' Categories : Database management systems Data modeling Relational model Hidden categories : Articles lacking sources from December 2009 All articles lacking sources Wikipedia articles with GND identifiers Talk About Wikipedia Català Čeština Deutsch Español Euskara Français 한국어 Italiano עברית Nederlands 日本 語 Polski Português Українська 6 more Edit links This page was last edited on 6 November 2017, at 07 : 06. Text is available under the Creative Commons Attribution - ShareAlike License ; additional terms may apply. By using this site, you agree to the Terms of Use and Privacy Policy. Wikipedia ® is a registered trademark of the Wikimedia Foundation, Inc., a non-profit organization. About Wikipedia

Question: in a microsoft access table what does a row of information represent
Answer: a single, implicitly structured data item in a table