UNIQUE constraint and PRIMARY key?

Asked By danielle mea 0 points N/A Posted on - 10/26/2011

Our professor in Database 2 assigned us to make some small system. We were required to use MS Access as our mode of database storage. Now, after he discussed on what to do, I'm just a little confused between unique constraint and primary key. Is there any differences between these two entity? 

• Status: Open
• Question Views: 804
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Databases

Answered By maverick 0 points N/A #96324

UNIQUE constraint and PRIMARY key?

Unique and Primary keys are very confusing but if you look at it in a logical way there are differences in its nature. 

For one a primary key cannot be null it can only accept “not null values” while a Unique Key can accept null values. Also in a given table, you can have many unique keys but you can only have one primary key. 

Also a Unique key column applies no constrains except for the fact that no duplicates are allowed on that column, while a Primary Key column has a constraint that the value should not be null and that there are no duplicates and an ascending order is followed.

About maverick

Questions
0

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/26/2011
• Question Category: Misc Databases