Wednesday, 17 September 2014

What is field ? What is record or row ? What is column ?

What is field?
Every table is broken up into smaller entities called fields. The fields in the CUSTOMERS table consist of ID,
NAME, AGE, ADDRESS and SALARY.
A field is a column in a table that is designed to maintain specific information about every record in the table.

What is record or row?
A record, also called a row of data, is each individual entry that exists in a table. For example, there are 7 records
in the above CUSTOMERS table. Following is a single row of data or record in the CUSTOMERS table:

A record is a horizontal entity in a table.

What is column?
A column is a vertical entity in a table that contains all information associated with a specific field in a table.
For example, a column in the CUSTOMERS table is ADDRESS, which represents location description and would 
consist of the following:


No comments:

Post a Comment