SQL and Relation Databases - Reading Assignment

  1. row = record of a single item
  2. column = is an attribute of a particular data set
  3. table = is a set of rows and columns
1 Like
  1. A row represents a single record.

  2. A column is an attribute of a record such as date of birth for example.

  3. A table is a set of records like rows & tables.

1 Like
  1. A row is a record, a data set representing a single item.
  2. A column is an attribute or field, a labeled element of tulpe
  3. A table is a relation or base relvar, a set of tulpes sharing the same attributes, a set of columns and rows.
2 Likes

What is a row?
Is a record or a set of data related to a single item and is referred to as a tuple.

What is a column?
Is a vertical list of attributes or fields for a group of records

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 record or data set representing single item.

  2. A column is an attribute or field such as a labeled element, address or date of birth.

  3. Table is a set of those rows or columns, (tuples) that are related or share the same attributes.

1 Like
  1. A record. A data set representing a single item.
  2. An attribute or field. A labeled element of a tuple. e.g. an 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? Is a Dataset, is the representation of the data we want to store
  2. What is a column? Is the classification or type of data we charge in the row.
  3. What is a table? is the set of rows and tables
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
  • What is a row?
    • Data set representin a single item
  • What is a column?
    • Labeled element of a tuple, such as “address” // “DOB”
  • What is a table?
    • A set of tuples sharing the same attributes; a set of columns and rows

@LORDKALVIN

1 Like
  1. What is a row?
    Data set, also called record of a single item.

  2. What is a column?
    Set of data values of a particular simple type, one value for each row of the database. A column can also be called an attribute or field.

  3. What is a table?
    Tables are database objects that contain all the data in a database. In tables, data is logically organized in a row-and-column format similar to a spreadsheet. A standard user-defined able can have up to 1,024 columns. The number of rows in the table is limited only by the storage capacity of the server.

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?
    and entry in a databse
  2. What is a column?
    a field or datapoint in a database
  3. What is a table?
    a collection of rows and columns :slight_smile:

If anyone is interested to understand relational databases more research Sets, Relations and Functions, mix these concepts with table rows and columns and that all it is.
https://www.tutorialspoint.com/discrete_mathematics/index.htm

In fact, most programming is founded by discrete math so I would highly recommend understanding this field of mathematics if you are new.

1 Like
  1. Row is a single item (or record) within the database
  2. Column is an attribute of records (rows)
  3. Table is set of rows and columns
1 Like
  1. What is a row?
    Its a record -> a data set representing a single item

  2. What is a column?
    Its an attribute of a particular data set like “address” or “date of birth”

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

1 Like
  1. A record (name of the object it describes)
  2. A set of attributes (variables) to describe each record (object)
  3. A set of rows and columns together describing the data
1 Like
  1. record
  2. field
  3. relation
1 Like

1.- “A data set representing a single item” (Horizontal)
2.- “A labeled element of a tuple” (Vertical)
3.- Compilation of these two, showing relations between both.

1 Like
  1. What is a row?
    A row is represents a single record in a DB. For example if the table represents people than a row represents information for a specific person - name, height, eye color, hair color, etc.

  2. What is a column?
    A column represent a specific kind of data. Rows are first described as a data type (Alpha Numeric, Number, etc) and size (1 character, 4000 characters, etc). The data stored in a column will all be similar. For example the first column is for names.

  3. What is a table?
    A table contains a specific group of information. A table could represent the information about a group of people. IE the names, height, hair color, eye color, for all of the people with a state drivers license. A table is made up with rows and columns, similar to a spreadsheet or a ledger.

2 Likes
  1. What is a row?
    a record, which is a dataset representing a single item

  2. What is a column?
    an attribute/field, which is a labeled element of a tuple - i.e DOB, address

  3. What is a table?
    a relation/base relvar, which is a set of tuples sharing same attributes - a set of columns and rows

1 Like
  1. A row is an record entry.

  2. A column is a list of attributes.

  3. A table is the relationship between the row of entries and the column list of attributes.

1 Like