Question

3. What is a primary key? Write the steps to set a primary key for a table .​

Answer 1

Answer:

Primary key

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes that uniquely specify a tuple in a relation. Informally, a primary key is "which attributes identify a record", and in simple cases are simply a single attribute: a unique id.

Step 1 Select the field that you want to set as a primary key. Step 2 Click Primary Key button from the Design tab.

1. Provides a datasheet, pivottable, pivotchart and design view.

2. Manages fields and columns of the table.

3. Set the data type and formatting.

4. Create table relationships and object dependencies.