SQL and Relation Databases - Reading Assignment


#1

Welcome to the discussion about this reading assignment.

Leave your answers to the questions below in this thread. If you have any questions or you want to discuss something connected to the assignment feel free to do it in this thread as well, but please everything to the topic.

  1. What is a row?
  2. What is a column?
  3. What is a table?

#2

SQL and Relational Databases – Reading Assignment

Tables

A database table is just that, a table with rows and columns. Different tables contain information about different types of things.

Rows

Each row in a database table represents one instance of the type of object described in that table. A row is also called a record .

Columns

The columns in a table are the set of facts that we keep track of about that type of object. A column is also called an attribute or a field .


#3
  1. A row is a single record. A user, for example.
  2. A column is an attribute of a record. The age or sex of a user, for example.
  3. A table is a set of records. A set or rows and columns.

#4

1) What is a row?
A record of a single item.

2) What is a column?
A labeled element of a single item

3) What is a table?
A table is a set of rows and column, or a set of single items who share the same attributes.


#5
  1. A Record is a single data set - a “Record”

  2. A Column is an “Attribute” Date, Age, Height, Colour, Model, etc. - Field Headings are usually attributes (Formalised way of recording data types - including mask information for example - No Zeros allowed etc.)

  3. A table is a series of rows and columns with intersections or other relationships across tables that through Tuples can return queries with the data requested.


#6
  1. What is a row?

A row is a singular data set

  1. What is a column?

A column represents the attributes of a particular data set.

  1. What is a table?

A Table is a collection of rows and columns displaying data


#7

1. What is a row?
It is a record which represents a single item. (Tuple)
2. What is a column?
It is an attribute or labelled element. (Attribute)
3. What is a table?
It is a set of rows sharing the same columns. (Tuples and Attributes)


#8
  1. What is a row?
    Data set representing a single item
  2. What is a column?
    A labeled element such as address or date of birth
  3. What is a table?
    A set of columns and rows

#9

row.- a set of data relating to 1 item- i.e all the data relating to 1 person
column- data relating to 1 field only, i.e - the last name of everyone in the table- or last name of everyone in your data base
table- a matrice, containing columns and rows,. i.e containing people, or elements in the database and columns. i.e data fields for each entry or row


#10
What is a row?
  1. A row is a tuple in a db. A data set representing a single item.

    What is a column?

  2. A column is an attribute of the db element, capturing some specific characteristic, attribute or field.

    What is a table?

  3. A table is a meaningful entity, say a business element(s), like customer(s), that contains informastion about that entity. In the text, a Relation or Base relvar.


#11
  1. What is a row?
    A single data set.

  2. What is a column?
    Outlines the attributes relating to a given data set.

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


#12
  1. Row contains the record of items with different attributes.
  2. Column is the attribute or field; each item in the same column have that attribute in common with others.
  3. Table is this collection of closely related columns, or the set of rows and columns. It is the relation.

#13
  1. What is a row?
    A row is a record.
  2. What is a column?
    A column is an attribute.
  3. What is a table?
    A set of columns and rows.

#14
  1. What is a row?

A data set representing a single item

  1. What is a column?

A labeled element of a tuple, e.g. "Name" or "Date of birth"

  1. What is a table?

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


#15

What is a row?
A single data set with one item

What is a column?
an attribute with a data set

What is a table?
A set of records with rows & columns


#16
  • What is a row?
    A single record in a table, comprised of all columns

  • What is a column?
    A single data entry in a row.

  • What is a table?
    Collection of rows and columns


#17
  1. A row is the information about an entity, also known as a tuple. For example, a user is the entity, and a row has his information such as: user id (10001), name (John), age (30), address (201 Lurking St, Toshi…) phone no (917-37890000)

  2. A column is a set of information stored in the database - Attribute. Referring to the above example: User ID, name, age, address, phone no.

  3. A table is a collection of a set of information (User ID, name, age, address, phone no) for a collection of entities (John, Lucy, Adam, Peter… ) organised in the form of row and column.

Personally I find this guy on youtube explains row, column & table better than the wikibooks article, so I’ll shared it here: https://www.youtube.com/watch?v=pShj3gtYQik (from 6:27)


#18

What is a row?** A record of data representing a single item
What is a column?** An attribute or field, a labeled element of a tuple like an address or date of birth
What is a table?** a set of columns and rows sharing the same attributes


#19
  1. What is a row? - set of data for a single item
  2. What is a column? set of data for a single attribute
  3. What is a table? set of data for many items and their shared attributes

#20
  1. What is a row? it is a record, a data set representing a single item, for example, a user in an HR DB
  2. What is a column? it is an attribute or filed, a labeled element of a tuple, for example, an address or age or telephone number
  3. What is a table? it is a relation, a set of tuples sharing the same attributes, a set of columns and rows