Question

Distinguish between a record and a field in a table, with an example.

Answer 1

Distinguish between a record and a field in a table are as follows:

Record	Field
It is a collection of data items, which represent a complete unit of information about a thing or a person.	It is an area within the record reserved for a specific piece of data.
A record refers to a row in the table.	A field refers to a column in the table.
The record is also known as a tuple.	Field is also known as attribute.
e.g. if Employee is a table, then entire information of an employee is called a record.	e.g. if Employee is a table, then empId, empName, department, salary are the fields.