Question

jump to level 1
for each of the following tables, identify which column could serve as the primary key.
(1) a table named country has a row for each country, with columns for each of the
following values: name, capital, continent, population, currency.
pick
(2) a table named car has a row for each car, with columns for each of the following values:
make, model, year, color, vehicle identification number (vin).
pick

Explanation:

A primary key uniquely identifies each row in a table. For the country table, each country has a unique name (no two countries share the exact official name). For the car table, a VIN is a globally unique identifier assigned to each individual car.

Answer:

(1) name
(2) vehicle identification number (VIN)