hi,i want t0 knom d syntax for a super key with an example
- 1 Answers
- 4661 Views
- I also Faced
- E-Mail Answers
Answer Posted / shikha
PersonID
PersonID + LastName
PersonID + FirstName
PersonID + DOB
PersonID + LastName + FirstName
PersonID + LastName + DOB
PersonID + FirstName + DOB
PersonID + LastName + FirstName + DOB
LastName + FirstName + DOB
All of these will uniquely identify each record, so each
one is a superkey. Of those keys, a key which is comprised
of more than one column is a composite key; a key of only
one column is a simple key.
A candidate key is a superkey that has no unique subset; it
contains no columns that are not necessary to make it
unique. This table has 2 candidate keys:
PersonID
LastName + FirstName + DOB
Not all candidate keys make good primary keys: Note that
these may work for our current data set, but would likely
be
.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
can a table be moved to different filegroup? : Sql server administration
What do you mean by data integrity?
How to create a local temporary stored procedure?
What do you understand by the data quality services in sql server?
What is transact-sql language?
How to connect sql server management studio express to sql server 2005 express?
What is a select query statement in ms sql server?
Tell me what is the difference between locking and multi-versioning?
What is the difference between update lock and exclusive lock?
What are parameterized reports? What are cascading parameters in ssrs reports?
What are a scheduled jobs?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What is executereader?
What do you understand by sql server agent?
How to access the inserted record of an event?
