SQL and Relation Databases - Reading Assignment

  1. A data set representing a single item
    2.A labeled element an “Address” or “Date of birth”
  2. a combination/set of row’s and column’s
1 Like
  1. (SQL Term) = (Relational DB Term) = (Meaning)
  2. Row = Record / Tuple = a data set (attributes) representing a single item (a tuple)
  3. Column = Attributes = labelled element of a tuple (header/column label)
  4. Table = Relation / Base relvar = a set of tuples sharing the same data set (a set of rows & columns)
1 Like

Great answers. It’s easy to understand. Great work. :clap:

Carlos Z.

  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
1 Like
  1. What is a row?
    A row is a record, tuple or data set representing a single item.

  2. What is a column?
    A labelled element (attribute or field) of a tuple, for example: “Name”, “Height” and “Weight”.

  3. What is a table?
    A set of tuples sharing the same attributes comprised of a set of columns and rows which contain the data of a database.

1 Like
  1. What is a row?
    It is a record which represents a single item.
  2. What is a column?
    A column is a labeled element with an attribute of the record, such as address or date of birth.
  3. What is a table?
    A table is a set of records sharing the same attributes; a set of columns and rows.
1 Like

A row is a record representing an item

A column is a field/ attribute or part of a tuple

A table is a relation or set of tuples showing the same attributes or a set of rows and columns

1 Like
  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.

1 Like

[quote=“ivan, post:1, topic:6430”]

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

  2. A column is a labeled element of a single item.

  3. A table is a set of rows & columns. For instance, a table can be a set of single items who share the same attributes.

1 Like

1, a row is a record basically describing where the column info belongs to
2. values / properties of the record
3. records that belong together e.x. users and their values/properties / multiple rows and columns

1 Like
  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

1 Like
  1. What is a row?

A set of values that a single entity has. This set of values is also known as a Tuple. Data that is shown from left to right.

  1. What is a column?

A labeled attribute or field - for example date of birth, account number, address, phone number etc. Data that is shown top to bottom,.

  1. What is a table?

The sets of data comprising of rows (tuples) and columns.

1 Like
  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.
1 Like
  1. What is a row?
    A dataset representing single item

  2. What is a column?
    A column or attribute represents labeled element e.g. Address, Phone Number, Email

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

1 Like

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

2. What is a column?
-> A labelled 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

1 Like
  1. What is a row?
    A data set representing a single item
  2. What is a column?
    A labeled element of a tuple (a data structure consisting of multiple parts), 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
1 Like
  1. What is a row?

A dataset representing a single item in a table (as well called Tuple)

  1. What is a column?

A labeled element of a Tuple/Row

  1. What is a table?

A set of Tuples (Rows), sharing the same attributes - set of columns and rows

1 Like
  1. What is a row?
    A record of one item

  2. What is a column?
    An attribute of a record, such as “address” or “height”

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

1 Like
  1. What is a row?
    A row has data or information about the type of object described in the table

  2. What is a column?
    Columns are sets of facts that structure the database, about the type of topic or object that is tracked.

  3. What is a table?
    The table is pretty much the combination of rows and columns about the certain subject or object that is recorded in the dataabase.

1 Like