SQL and Relation Databases - Reading Assignment

Blockchain Business Course
#21
  1. What is a row?
    is a record of one item/value
  2. What is a column?
    it is a attribute or labeled field eg “address” or “date of birth”
  3. What is a table?
    a accumulation of rows and columns
1 Like
#22
  1. What is a row?
    A data set row in table representing a single item
  2. What is a column?
    A data set column in a table representing labeled data for every single item in a row
  3. What is a table?
    A set of rows and columns sharing the same attributes from columns on items in rows
1 Like
#23

  1. A row is a data set that represents a single item.

  2. A column is an attribute or field of a certain record. I.e. User A is 15 years old.

  3. A table is a set of records.

1 Like
#24

  1. What is a row?
    Within the table you have rows that start with 1 and continues down. A table can contain miljons of rows. 1 row are one record.

  2. What is a column?
    You might have worked with an excell doc. There you can se columns named A,B,C,D etc… You can create and give name to columns in the table.

  3. What is a table?
    Within the DB you have tables that contain different data. One can contain info about adresses, the second stores transactions the third lists products.

1 Like
#25
  1. What is a row?
    Is just a simple record in a table. It is a composition of differents columns
  2. What is a column?
    Is a field of a record
  3. What is a table?
    Is a set of records
1 Like
#26
  1. What is a row?

It is a record of different values in the database table which structured by fields. These fields can have key fields and secondary fields.

  1. What is a column?

It is a field in the table which composes of values on the database table.

  1. What is a table?

Database table is a set of fields structured or organised like a ledger. It is composed of fields and its values which can be related to other tables as well, thus Relational Database Management System.

1 Like
#27
  1. What is a row? a data set representing a single item
  2. What is a column? a labelled set of fields e.g Age, Height. For a set of Records
  3. What is a table? a relation, a set of columns and rows
1 Like
#28
  1. What is a row?
    It is a dataset for a specific item. Meaning this is all the information for a specific entry.
  2. What is a column?
    A column is a specific labeled element of a tuple. This is basically a specific information stored for each row.
  3. What is a table?
    This is grouped information in a database which includes all rows and all columns for that grouping.
1 Like
#29

Row: Represents single data item
Column: Specific category of information in a table
Table Collection of related data that includes columns and rows

1 Like
#30

1, A data set representing a single item

  1. A labeled element of a tuple, e.g. “Address” or “Date of birth”

  2. A set of tuples sharing the same attributes; a set of columns and rows

1 Like
#31
  1. A record of something. A single data set. Perhaps a name for example.
  2. A column would be an attribute of the row or ‘name’ for this example, so date of birth lets say.
  3. A table would be a representation of the relationship between the name and date of birth in this example.

As simple as this shit sounds, it’s still a bit confusing when you add ‘tuples’ and try to understand rows columns and tables, but without understanding what and how tuples relate…anyone want to elaborate?

1 Like
#32

Nando,
So the way you understand it, for answer 1, would something like a ‘name’ , a single item, be both a row and a tuple? WTF is a tuple?

YC

#33
  1. What is a row?
    A row is a dataset representing a single item. Also known as a record.
  2. What is a column?
    A column is a labeled element of a tuple. Also known as an attribute or field.
  3. What is a table?
    A table is a set of tuples sharing the same attributes; a set of columns or rows. Also known as a Relation or Base relvar.
1 Like
#34

YC, you are right I wasn’t clear. In fact I was wrong when I called a row a tuple, rows are items. A tuple in this context is the (item, attribute) pair that has a value in a 2D table for example (name, age) = integer number. A relational table is a set of tuples with their values. What do you think ?

Nando

#35
  1. What is a row?
    A data entry
  2. What is a column?
    Data types
  3. What is a table?
    Holding rows and columns of a defined category
1 Like
#36

  1. What is a row?
    A row, or record, is a dataset representing a single item.

  2. What is a column?
    A column, attribute or field, is a labeled element of a tuple(row).

  3. What is a table?
    A table, relation or base relvar, is a set of tuples sharing the same attributes.

2 Likes
#37

  • What is a row?
    it’s a record ,a dataset representing a single item.

  • What is a column?
    it’s a field or atribute .a labled element of a tuple .

  • What is a table?
    It’s a set of tuples sharing the same field .a set of columns and rows .

image

1 Like
#38

  1. What is a row?
    A row consists of a record of data relating to a singular item.

  2. What is a column?
    A column consists of labeled fields such as “address” or "phone numbers etc.

  3. What is a table?
    A table is the make up of rows and columns and the data in those rows and columns.

1 Like
#39

What is a row?
A Data set representing a single item.

What is a column?
A labelled item like date of birth or address.

What is a table?
The above; Rows & Columns

1 Like
#40
  1. What is a row? A data set representing a single item
  2. What is a column? A labeled element of a tuple
  3. What is a table? A set of tuples sharing the same attributes; a set of columns and rows
1 Like