SQL and Relation Databases - Reading Assignment

Blockchain Business Course
#662
  1. ‘Row’ is an SQL relational database term. A dataset representing a single item. A row is also called a record.
  2. ‘Column’ : is an SQL term that is an attribute or field that applies to an item in the database. For instance, if it is a customer database, an attribute / field could be customer name, customer number, address, start date, date of birth and so forth.
  3. ‘Table’: an SQL term that is a relation or base relvar. A database table is a combination of rows and columns that contain information about different things. It lists items and displays their various attributes.
1 Like
#663
  1. Row :blue_square: :blue_square: :blue_square: is a record, a structured data set in a table.
  2. Collum is an atribute, a collection of data values ​​of a certain type;
    :purple_square:
    :purple_square:
    :purple_square:
  3. Table describes several n to m relationships between 2 or more base tables with possibly linking tables.
    :green_square: :green_square: :green_square: :yellow_square: :yellow_square: :yellow_square: :brown_square: :brown_square: :brown_square:
    :green_square: :green_square: :green_square: :yellow_square: :yellow_square: :yellow_square: :brown_square: :brown_square: :brown_square:
1 Like
#664

Great answers. I like a lot your example, it’s easy to understand. Great work. :clap:

Carlos Z.

#665

A table is a method to store data in both rows and columns and can be easily expanded

A row is the horizontal column in a table or chart that represents a single term.

A column is the vertical storage of data of a certain record.

1 Like
#666

  1. What is a table?
    A table is a database that contains information in rows and columns.

  2. What is a row?
    A row, or a record, is an aspect of a table that represents a single data set.

  3. What is a column?
    A column is an aspect of a table that organizes the different attributes of the various records on the table.

1 Like
#667

Hello,

  1. what is a row?
    A row is data set representing a single item
  2. what is a column?
    A column is an attribute or a field of a row/record.
  3. what is a table?
    A table is a set of columns and rows that share the same attributes.
1 Like
#668

I find the definitions quite confusing but here’s how I see it:

  1. What is a row?
  • An entry of data. Like, if we describe fruits by color and weight, a row would be Mango and its elements would be green; 300. They would be labeled as Color and Weight.
  1. What is a column?
  • Elements with the same label. In the fruit case, a column would be Color and it would contain all the colors of the fruits we entered.
  1. What is a table?
  • A set of entries that have the same attributes. In this case, all the fruits that we choose to describe with color and weight.
1 Like
#669

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

  2. A column is an attribute or field labeled element of a tuple like an address

  3. A table is a set of tuples sharing the same attributes; a set column & row.

1 Like
#670

1 A row is a record. A single item.
2- A column is an attribute or field. A labeled element of a tuple. Ex. height.
3- A set of tuples sharing the same attributes.

1 Like
#671
  1. A row identifies each item record
  2. A column identifies characteristic attributes of each item.
    3.a table includes corresponding row and column entries
1 Like
#672
  1. a row is a set of attributes representing a single item
  2. a column describes an attribute across a set of rows describing several items
  3. a table is a set of tuples sharing attributes (it’s a combination of columns and rows)
1 Like
#673

  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
#674

  1. What is a row?
    …is a /record - a data set representing a single item.

  2. What is a column?
    …is an Attribute or Field representing a labeled element of a Tuple. (area of intersection / cell where the row and the column intersect.)

  3. What is a table?
    …is a relation or base relvar, a set of Tuples sharing the same attributes; a set of columns and rows.

rjr
2021-03-22T04:00:00Z

1 Like
#675
  1. A row is a record, a dataset representing a single item
  2. Column is an Attribute or Field, A labeled element of a tuple, e.g. “Address” or “Date of birth”
  3. A Table is a Relation or Base relvar, A set of tuples sharing the same attributes; a set of columns and rows
1 Like
#676

1.ROW- it is a SQL term which is related to “record” in database’s terms. It is a data set representing a single term
2.COLUMN- it is a SQL term = attribute = a labeled element of a tuple (ex: address, date of birth)
3.It is SQL term which means relation or base relvar. It is a set of tuples sharing yhe same attribute, a set od columns and rows

1 Like
#677

  1. What is a row? Is a record, which represents a single item

  2. What is a column? Attribute or field I.e name and occupation

  3. What is a table? Relation or Base relvar , set of columns and rows which share the same attributes

1 Like
#678
  1. What is a row?

An item, a record

  1. What is a column?

An attribute of that item or record

  1. What is a table?

A set of columns and rows

1 Like
#679
  1. A row is a record/entry in the database
  2. A column is an attribute records in a table can have
  3. A table is a collection of data (records) defined by rows and columns
1 Like
#680
  1. What is a row?
  2. What is a column?
  3. What is a table?

1)A row is a singular data set
2)A column represents the attributes of a particular data set.
3)A table is a collection of rows and columns displaying data

1 Like
#681
  1. A row is a single record, an user for example, some data.
  2. A column is an attribut/field and it tells us age/sex/date of birth about the user
  3. A table is a set of records, made of rows and columns.
1 Like