What is the primary key used for in a relational database?Select one:a. To link tables togetherb. To perform data aggregationc. To enforce referential integrityd. To uniquely identify each record in a table

What is the primary key in a relational database used for?

What is the primary key in a relational database used for?To establish relationships between tablesTo ensure data is stored in binary formatTo uniquely identify records in a tableTo create backup copies of the database

What is the term for the candidate key other than the primary key in a relational database table

Explain the following terms as used in database implementation. [3 Marks]a. Primary keyb. Columnc. Row

4. Explain the primary key in MySQL and why it is important in database design