Question

Consider the following table PLAYER: 

         Table: PLAYER

PNO	NAME	SCORE
P1	RISHABH	52
P2	HUSSAIN	45
P3	ARNOLD	23
P4	ARNAV	18
P5	GURSHARAN	42

1. Identify and write the name of the most appropriate column from the given table PLAYER that can be used as a Primary key.
2. Define the term Degree in relational data model. What is the Degree of the given table PLAYER?

Answer 1

1. The most suitable column from the provided table PLAYER to serve as a primary key is PNO, since each value in the column is distinct.
2. The number of attributes (columns) in the provided table indicates the degree of a relation. The current table PLAYER has a degree of 3.