Question
Distinguish between a record and a field in a table, with an example.
| 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. |
| Record is also known as 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 Empolyee is a table, then empld, empName, department, salary are the fields. |
Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.



