Distinguish between a record and a field in a table, with an example.
Distinguish between a record and a field in a table, with an example.
4 views
1 Answers
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. |
4 views
Answered