Interested to Buy Any Domain ? << Click Here >> for more details...
hi,i want t0 knom d syntax for a super key with an example
- 1 Answers
- 5058 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
Explain sql server authentication modes?
How do I find my localdb version?
What do you understand by intent locks?
What is merge join?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
Why the trigger fires multiple times in single login?
What is a benefit of using an after insert trigger over using a before insert trigger?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
What programming language would you use to create embedded functions in ssrs?
What is master database? : SQL Server Architecture
What is the difference function and stored procedure?
What are the properties of the relational tables?
Can we call future method from trigger?
What is the order in which the sql query is executed?
Can you always create a cache of a report?
