Question

Aman wants has to create a table with following fields:
PlayerID, PlayerName, Date of Birth, SportsPlayed, Indian_Nationality, International_
Player, Remarks
a. What will be the appropriate data type of all the fields?
b. Which one will be the primary key?
​

Answer 1

a) Data type for all the fields:

PlayerID = Number

Player Name = String, Character

Date of Birth = Number

Sports Played = Character

Nationality = Character

International Player = Character

Remarks = Character

b)

PlayerID will be primary key for this database.