SQL and Relation Databases - Reading Assignment

[blue]

1. What is a row?
   a record: a data set for a single item
2. What is a column?
   a field or attribute a labeled element of a tuple/row
3. What is a table?
   a relation: set of tuples sharing the same attributes; set of rows and columns

[andreas_nygren]

|Row|record|A data set representing a single item|

|Column|Attribute or field|A labeled element of a tuple, e.g. “Address” or “Date of birth”|

|Table|Relation or Base relvar|A set of tuples sharing the same attributes; a set of columns and rows|

[DanD]

1. A row is a data set representing a single item. The relational database term is “record”.
2. A column is a labelled element of a tuple, e.g. “NI number” “Date Of Birth”. A tuple is a finite ordered list of elements. The relational database term is “attribute”.
3. A table a set of tuples sharing the same attributes; a set of columns or rows.

[CryptoVinny]

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

[chadrickm]

@ivan

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

1. A row is a record in a table. It represents the data about that specific record.
2. A column is an attribute or piece of data about the record.
3. A table is a collection of records.

[coinarura]

1. What is a row?
   A row —also called a tuple—represents a single, implicitly structured data item in a table. Simply a data set representing a single item

2. What is a column?
   A labeled element of a tuple (A single row of a table, which contains a single record for that relation. e.g. “Address” or “Date of birth”). A column is also called an attribute or a field
   .

3. What is a table?
   A set of tuples sharing the same attributes; a set of columns and rows.

File:Relational database terms.svg

[Steffen]

1)Row record (tuple) A data set representing a single item
2)Column Attribute or field A labeled element of a tuple, e.g. “Address” or “Date of birth”
3)Table Relation or Base relvar A set of tuples sharing the same attributes; a set of columns and rows

[sneakyturtle]

1. What is a row?

A row is a data record in a table.

2. What is a column?

This is a set of data values in a table

3. What is a table?

This is a collection of related data in a database.

[HexagonalView]

1. What is a row?
   A set of data reflecting one single item
2. What is a column?
   It represents a named element of a data structure
3. What is a table?
   A set of columns and rows or a set of data structures having the same parameters.

[Jazmin]

1. What is a row?
   A record in the database e.g. a user can have a record which includes their email, address, age and phone number

2. What is a column?
   An attribute in the record e.g. the user’s email

3. What is a table?
   a collection of records

[guso]

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

[newbking]

1. What is a row?
   A row is a record. A data set representing a single item

2. What is a column?
   A column is an attribute or field.

3. What is a table?
   A table is relation. A set of columns and rows.

[WoolyBully]

1. a data set representing a single item
2. a labeled element of a tuple, e.g. dress or date off birth
3. a set of tuples sharing the same attributes, a set of columns and rows

[Roel]

@ivan

• What is a row?
• What is a column?
• What is a table?

1. a dataset representing a single item
2. a labeled element of a tuple
3. a set of tuples sharing the same attributes; a set of columns and rows

[johnp]

1. What is a row?
   A data set representing a single item.
2. What is a column?
   The attributes of a particular data set.
3. What is a table?
   Set of columns and rows sharing the same attributes.

[manfredosz]

1. A row is a single piece of information in a database
2. A column is a list of these rows with their similar properties
3. A table is a set of rows and columns

[JeeInthailand]

@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. A data set 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

[chakrit]

@ivan

• What is a row?
• What is a column?
• What is a table?

1. A row is a record in the table representing one item
2. A column is an attribute or a label attached to the tuple
3. A table is the relation or base relvar, or a group of items having common attributes structured as columns and rows.

[bithomie]

1. Row is a record or could be thought about as a file.
2. Column is an attribute or field in the record or file
3. Table is a collection of records that share the same attributes.

[Ed1]

• **What is a row?
  Is a record in the table
• What is a column?
  Is a specific attribute/field in a record
• What is a table?
  A table is a combination of a row and column together.