Question

What are the two ways of assigning a primary key status to a field?​

Answer 1

Answer:

To set the primary key:

1. Open the database that you want to modify.
2. In the Navigation Pane, right click the table in which you want to set the primary key and, on the shortcut menu, click Design View. ...
3. Select the field or fields that you want to use as the primary key.

Answer 2

Explanation:

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table).[a][1] Informally, a primary key is "which attributes identify a record", and in simple cases are simply a single attribute: a unique id. More formally, a primary key is a choice of candidate key (a minimal superkey); any other candidate key is an alternate key.