Computer Science 2 Marks Each

Primary Key: An attribute/column among the Candidate Keys which is used to uniquely identify each row/record in a table

Example:

Rollnumber in the table STUDENT

OR

AccessionNumber in the table LIBRARY

OR

EmpNumber in the table EMPLOYEE

OR

PanNumber in the table INCOMETAX OR

MemberNumber in the table MEMBER OR

AccNumber in the table BANK

Alternate Key: All such attributes/columns, which can act as a primary key but are not the primary key in a table.

DML – Data Manipulation Language

Degree = 2

Cardinality = 1

Degree of LIST = 4

Cardinality of LIST = 6

DEGREE = 5

CARDINALITY = 9