Jump to content

Primary Key and Unique confusion


arowa704

Recommended Posts

hi,

AFter reading this paragraph from a book, I got confused:

 

\"While PRIMARY KEY forbids NULL\'s in the attributes of the key, UNIQUE permits them. Moreover, the rule that two tuples may not agree in all of a set of attributes declared UNIQUEmay be violated if one or more of the components involved have NULL as a value. In fact, it is even permitted for both tuples to have NULL in corresponding attributes of the UNIQUE key.\"

 

What I got from this:

1) PRIMARY KEY cannot have NULL

2) UNIQUE can have NULL

 

From Moreover on... is where I got confused.

1) 2 tuples can have NULL in an UNIQUE attribute, which is legal....

 

Another Question

A Primary Key is Unique indirectly...?

But I\'m assuming those two keywords can never be used together.

 

Correct me If i\'m wrong. Thanks in advance

Link to comment
Share on other sites

All the primery key is for is to tell the database which Field for it to sort on. The database can be sorted using various fields but the primiary key is the first field to sort.

 

I don\'t agree with this. A Primary key by definition must be able to uniquely identify any one row in the table.

 

As for NULL, it is often seen as being a property that exists independent of normal SQL rules. When a column is NULL, a value is unknown. Thus even a column guaranteed to be UNIQUE will allow for NULLs if the NULL property is set. For this reason, many SQL purists recommend that NULL be avoided.

 

As for having NULL in a primary key column... that is not allowed. A primary key must have a value and that value is guaranteed unique across the entire series of columns which comprise the primary key.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.