Past Year - 2 Mark Questions

Computer Science - Class 12
Chapter 8 - Database Concepts

## Differentiate between cardinality and degree of a table with the help of an example.

Cardinality refers to the number of tuples/rows in a table whereas, Degree refers to the number of attributes/columns in a table.

Example:

 Employee_id Employee_name Department 101 Ravi Kumar Sales 102 Tarun A IT 103 Jennifer Davis HR 104 Martin Woods HR 105 Ron Romy IT

In table Employee,

Cardinality = 5

Degree = 3

Learn in your speed, with individual attention - Teachoo Maths 1-on-1 Class

### Transcript

Differentiate between cardinality and degree of a table with the help of an example. Answer: Cardinality refers to the number of tuples/rows in a table whereas, Degree refers to the number of attributes/columns in a table. Example: Employee_id Employee_name Department 101 Ravi Kumar Sales 102 Tarun A IT 103 Jennifer Davis HR 104 Martin Woods HR 105 Ron Romy IT In table Employee, Cardinality = 5 Degree = 3