SQL and Relation Databases - Reading Assignment

[DaanBoshoven]

1. A dataset representing a single item
2. A labeled element of a tuple, e.g. “Address” or “Date of birth”
3. A set of tuples sharing the same attributes; a set of columns and rows

[Restford]

1. Rows - a single record of an object and its attributes.
2. Columns - The element corresponding to an attribute.
3. Tables - A set of rows and columns.

[alemr]

1. What is a row?
   –> A data set representing a single item
2. What is a column?
   –> A labeled element of a tuple, e.g. “Address” or “Date of birth”
3. What is a table?
   –> A set of tuples sharing the same attributes; a set of columns and rows

[Damedius]

1)A row is a data set representing a single item.

2)A column is a labeled element of a tuple.

3)A table is a set if tuples sharing the same attributes; a set of columns or rows.

[Murisoja]

@ivan

Welcome to the discussion about this reading assignment.

Leave your answers to the questions below in this thread. If you have any questions or you want to discuss something connected to the assignment feel free to do it in this thread as well, but please everything to the topic.

1. What is a row?
2. What is a column?
3. What is a table?

1. singular piece of data
2. attribute of a particular piece of data
3. collection of rows and columns containing the data rows and columns

[Crypto_PONY]

1. A Row is a data set representing a single item; a record.

2. A Column is an attribute/field of a record.

3. A Table is a set of rows and columns; a set of records and in a field.

[kwaben]

1. What is a row?
   A record or Tuple
2. What is a column?
   A field in a record
3. What is a table?
   A relationship

[Haseley]

1. RDBM term: A row is a “record”. A data set representing a single item.

2. RDBM term: A column is an “attribute” or “field”. A labeled element of a tuple (e.g. Address/D.O.B.)

3. RDBM term: A table is a “Relation or Base Relvar”. A set of tuples sharing the same attributes;
   A set of Columns and rows.

[Groovy_Avocado]

1. What is a row?
A row is a data set representing a single item. In relational database terms it is called a record.
2. What is a column?
A column is a labeled element of a tuple, e.g. “Address” or “Date of birth”. In relational database terms it is called an attribute or field.
3. What is a table?
A table is a set of tuples sharing the same attributes; a set of columns and rows. in relational database terms tables are called relation or base relvar.

[Monarcha]

1. A data set representing a single item ex: Marc
2. A data set representing a specific attribute or parameter ex: height
3. A set of rows and columns ex: Marc, Sunniva with Height and Age

[Rob_Kammerer]

1. What is a row?
   A data set representing a single item or The row is the smallest unit of data that can be inserted into a table and deleted from a table .

2. What is a column?
   A labeled element of a tuple, e.g. “Address” or “Date of birth”

3. What is a table?
   A table is a data structure that organizes information into rows and columns ., a set of tuples sharing the same attributes; a set of columns and rows

[supertramp007]

1. What is a row? A data set representing a single item
2. What is a column? A labeled element of a tuple, e.g. “Address” or “Date of birth”
3. What is a table? A set of tuples sharing the same attributes; a set of columns and rows

[MarkusJohansson]

• What is a row?
  data set representing a single item
• What is a column?
  a label element of a tuple.
• What is a table?
  A set of tuples sharing the same attributes; a set of columns and rows

[OmeOmy]

1. A set of data representing a single item, e.g a person and his data.

2. Data or information stored in a database for a single attribute.

3. Data stored on a database for multiple items and their shared attributes.

[Aleksander]

1. A row is a set of data for one item
2. A column is an atribute (a characteristic or quality of items)
3. A table is both combined: so set of atributes for a item in a row or whole relation between items in rows and atributes in columns.

[Cecilia_Machado]

• What is a row?
  Is a dataset representing a single item.
• What is a column?
  A labeled element of a tuple.
• What is a table?
  Is a set of tuples sharing the same attribute; a set of columns and rows.

[Acex13]

1. What is a row?
   A row is a container for a record, which is made up of a grouping of data attributes related to one entity, such as a person, address, product, etc.

2. What is a column?
   A column is a container for an individual data attribute, such as name, age, type, colour, size, etc.

3. What is a table?
   A table is a collection of rows and columns containing a complete dataset, based on the objective of the data.

[FunsyH]

1. A data set representing a single item.

2. A labeled element of a tuple, can be: age or hair colour.

3. A set of tuples sharing the same attributes; a set of columns and rows.

[Allistair_Trent]

• What is a row?
  A Row is a data set representing a single item in a database (record).

• What is a column?
  A column is a field or attribute of a tuple such as “name” or “date of birth”

• What is a table?
  A Table is a set of columns and rows or tuples sharing the same attributes

[Divij_Dawar]

1. A row is a record.
2. A column is an attribute.
3. A table is a set of rows and columns.