Question

1)Which two fields can act as the primary key from a given table?
2)which field can act as the candidate key and alternate key?
Acc_No
Cus_Name
Address
Balance
PAN_Number
Plzz answer me fast....

Answer 1

STUDENT {SID, FNAME, LNAME, COURSEID}

Here in STUDENT table keys are:

Candidate keys are SID or FNAME+LAME

Primary Key: SID

Foreign Key: COURSEID

Alternate Key:  FNAME+LAME

Composite Key:  FNAME+LAME