Generally, the database table is viewed as a collection of records
The term record is often also called tuple and row in a database table
Aptitude
- Introduction
- File System vs DBMS
- Tuple
- Record
- Architecture
- Need of DBMS
- DBMS Abstraciton and Indipendence
- Data Models
- ER Models
- RDBMS
- Relational Data Model
- SQL Introduction
- SQL Types
- DDL Commands
- DQL Commands
- DML Commands
- DCL Commands
- TCL Commands
- Default Constraints
- Check Constraint
- Not Null Constraint
- Unique Constraint
- Key Constraint
- Key In DBMS
- Primary Key
- Foreign Key
- Super Key
- Candidate Key
- Alternate Key
- Composite Key
ER Models
RDBMS
SQL
SQL Constraints
Keys In DBMS
Record
RECORD
Each record represents complete information of the specific data item, each record stores different data with the same structure
Example : For example in an employee table, we need to store the details of 10 employees then the database table will consist of 10 records every each record contains details of that particular employee i.e 1 record for storing the information of one employee
Consider a sample table ‘emp’.
| ENAME | JOB | SAL | HIREDATE | HIREDATE+2 |
| KING | PRESIDENT | 5000 | 17-NOV-81 | 19-NOV-81 |
| BLAKE | MANAGER | 2850 | 01-MAY-81 | 03-MAY-81 |
| CLARK | MANAGER | 2450 | 09-JUN-81 | 11-JUN-81 |
| JONES | MANAGER | 2975 | 02-APR-81 | 04-APR-81 |
| SCOTT | ANALYST | 3000 | 19-APR-87 | 21-APR-87 |
| FORD | ANALYST | 3000 | 03-DEC-81 | 05-DEC-81 |
| SMITH | CLERK | 800 | 17-DEC-80 | 19-DEC-80 |
Table contents seven rows i.e it stores the details of all the 7 employees in 7 separate tuples
→
←