answersLogoWhite

0

In a database a primary key is a unique value, meaning that it cannot be repeated. It is also mandatory, so it cannot be left blank. Something like a product code, an ISBN number, a student number, an employee number etc. would be primary keys.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

Which field MS Access will not allow you to delete?

A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.A primary key field.


Can super key be as primary key?

I think super key is treated as the primary key because in a table their will be only one primary key.


What are the importance of primary key?

Importance of primary key


What does the primary key in a data base do?

We know that primary key is the one that is not null and is always unique. A primary key uniquely identifies a record in a table.


What are the advantage of primary key?

Primary key that is used to identify a record uniquely. Primary key is a key that always unique and not null. A system generated primary key is called surrogate key.Primary key is the one which is always unique and not null. Advantage of primary key that it helps in identifying a tuple uniquely.


What is the primary key for the properties table?

Primary key is to set property ID as the primary key for the properties table.


What is an unlikely primary key?

A first name, a surname, a date of birth, and an address are just some examples of fields that would not be used as primary keys. Lots of people will have the same name or same date of birth and you could have people in your database that are living at the same address, so they are likely to be duplicated and so none of those fields should be used as primary key fields.


Entity integrity constraint?

The entity integrity constraint states that no primary key value can be null. This is because the primary key value is used to identify individual tuples in a relation. Having null value for the primary key implies that we cannot identify some tuples. This also specifies that there may not be any duplicate entries in primary key column key row.


How you create or assign primary key?

A primary key is never null and is also unique . Example of primary key is create table emp (ecode integer NOT NULL PRIMARY KEY);


Why do you designate one of the candidate key of relation to be the primary key?

We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.


What are some examples of commodities in economics?

A primary product like oil or coffee.


What are some examples of the primary soursces about the aztec's conquest?

they had better materials to fight with