Check sibling questions

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

 

Are ads bothering you?


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 - Teacher, Engineer, Marketer

Made by

Davneet Singh

Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.