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

 

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

Ask a doubt
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 13 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.