×

Courses

Chapters

>
<

DBMS

DBMS Record | CrackEase

Record

Record illustration

In a relational database, a record represents a single entry in a table. The terms record, tuple and row are commonly used interchangeably.

RECORD

Each record stores the complete information for a specific entity. All records in the same table share the same structure (columns), but each record contains different values for those columns.

Example: If an employee table stores 10 employees, the table will have 10 records — one record per employee.

Consider the sample table emp below:

ENAME JOB SAL HIREDATE HIREDATE+2
KINGPRESIDENT500017-NOV-8119-NOV-81
BLAKEMANAGER285001-MAY-8103-MAY-81
CLARKMANAGER245009-JUN-8111-JUN-81
JONESMANAGER297502-APR-8104-APR-81
SCOTTANALYST300019-APR-8721-APR-87
FORDANALYST300003-DEC-8105-DEC-81
SMITHCLERK80017-DEC-8019-DEC-80

This table contains seven rows — i.e., seven records — each storing details of one employee.

Footer Content | CrackEase
→
←