Question 1 - Past Year - 2 Mark Questions - Chapter 8 - Database Concepts

Last updated at April 16, 2024 by

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

 

Go Ad-free

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

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science and Computer Science at Teachoo