SQL and Relation Databases - Reading Assignment

Blockchain Business Course
#482

  1. A row is a single recorded item, a tuple, in a database

  2. A column is a labeled element of a tuple - field or attribute - in a db

  3. A table is a set of tuples sharing the same attribute / field, a set of columns and rows.

1 Like
#483

OK, love to answer these as I’ve been working with databases over 25 years now.
All these questions are related to data structures. I have worked with data that is stored by object oriented code where the master or ‘parent’ class has the basic columns stored in tables defined for data that is comon to all its children and where the children have more unique data to meet its purpose. For example a comon parent class is “Base” that has children of ComputerSystem and People. A person has attributes like email address, login, phone # and so on, while ComputerSystem has hostname, domain, and so on. These fields or columns are specific for the child class but they do share common attributes like Name, Description, UID, DatasetID and so on.

  1. A row is a record in a table that can be indexed with a unique key or just a non-unique hey.
    A row is populated by UPDATE TABLE_NAME SET FIELD = VALUE where field = value
  2. A column is a component of the row that allows for specifid filtering, but also has DATA TYPE defined as CHAR, VARCHAR, INT, BOOL. An API can extend the data types by adding a meaning to a data record like DATE by adding translation between EPOCH time to a human understood date.
  3. Table is then the database object where the row and columns are confined to. Atlhough a view or a “JOIN” can connect data from tables by looking at matching data in the LEFT, RIGHT or INNER (both) tables. Table is basically the smallest component object with data definitions.

Each database that I’ve worked with has similar syntax, but differs in the use of built in KEYs and Functions. For example Microsoft SQL is almost the same as ORACLE, but functions in MSSQL will not work in Oracle.

1 Like
#484

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

Carlos Z.

1 Like
#485

  1. What is a row?
    A row is an entry in the database that contains the key-value pair of an item in database

  2. What is a column?
    This is the list of attributes related to a particular key.

  3. What is a table?
    The collection of entries and attributes for a particular category.

1 Like
#486

Row- a record- the data set of a single item
Column- attribute or field- labeled element
table- relation- a set of tuples with the same attributes

1 Like
#487
  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
#488
  1. A row is a record where the data set is.
  2. A column has a labeled element known as the attribute/field
  3. Table has sets of columns and rows sharing same attributes
1 Like
#489

  • What is a row?

          A row is a record, it means a single thing into the data

  • What is a column?

     It's a field of information

  • What is a table?

        It's a set of rows and columns.
1 Like
#490

SQL and Relationship Databases: Read

  1. A Row can be described as a data set representing a single item.

  2. A Column can be described as a labelled element of a tuple(restricting combination of attributes) eg. an Address or a Date of Birth.

  3. A Table can be described as a set of tuples (restricting combination of attributes) sharing the same attributes in a set of columns and rows.

1 Like
#491
  1. It is a record
  2. It is an Attribute
  3. It is a relationship between records and attributes
1 Like
#492

  1. A Row is called a Record in a relational database and represents a single item.

  2. A Column is an Attribute/Field in a relational database and is a labelled element of a Tuple ie. DOB, address

  3. A Table is a Relation/Base Relvar in a relational database and is a set of Tuples sharing the same attributes in a set of columns and rows.

1 Like
#493
  1. A ROW is a record
  2. The COLUMN is a field
  3. The Table is a set of columns and rows
1 Like
#494

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 columns and rows

1 Like
#495
  1. A row is a data set representing a single item
  2. A labeled element of a tuple
  3. A set of tuples sharing the same attributes or a set of columns and rows.
1 Like
#496

Row - also called tuple or record- a data record within a table, representing a single item
Column- also called attribute - a labelled element of a row, can contain number, text, etc
Table - also called relations - a set of rows (tuples) and columns (attributes)

1 Like
#497
  1. A data set respresenting a single item (record).
  2. A labeled element of a tuple (attribute or field)
  3. A set of tuples sharing the same attributes; a set of columns and rows (relation or base relvar).
1 Like
#498

SQL and Relation Databases - Reading Assignment questions:

  1. What is a row?
    Row is a Record/ a data set representing a single item.

  2. What is a column?
    Column is an Attribute or field/ a labeled element of a tuple (e.g. Address or DOB).

  3. What is a table?
    Table is a Relation - a collection of rows and columns representing various data.

G.

1 Like
#499
  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
#500

A row is a data set, it represents date about a single item or individual
A column is an attribute or a label to data collected
A Table is a set of columns and rows

1 Like
#501
  1. A row is a data set representing a single record.
  2. A column is an attribute of a record representing an element.
  3. A table is a set or rows and columns representing records with predefined attributes.
2 Likes