Peter, who is a DBA designing databases. An application database for domestic cricket clubs needs to be created. There are many cricket clubs at different locations. A club can have many members. Each member, belonging to a particular club, has a unique member ID. The member ID need not be unique across different clubs. The below relations are created.

    Club (ClubId, Name, Location)
    Member (ClubId, MemberId, Name, Address)

Identify the Primary key for Club relation.

ClubId, Location
ClubId, MemberId
ClubId
MemberId
Verified Answer
Correct Option - c

To get all Infosys Certified Database and SQL Professional Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee

Telegram