Question

Differentiate between fields and records.

Answer 1

To make it simple and clear let us take an example.  A company have employees. Every employee has one employee number, name, date of joining, department, designation, basic salary, hra, da, TA, Gross salary, deduction and net salary.

Employee attributes like id number, name, date of joining ....etc.  are called fields. Each employee information is called record. Generally records are in rows and fields are in columns. cross section of row  and column is called element or cell.

Answer 2

Hey mate, here is your answer.: -)

==================================

Field: One piece of information you want to use in your database.
Example: Name, Date of birth

Record: A group of fields containing data about a person, item etc.
Example: Name and Addresss and Date of birth

==================================

HOPE it helps to you!!