hi,i want t0 knom d syntax for a super key with an example
- 1 Answers
- 4535 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
What are the methods used to protect against sql injection attack?
Give an example of SQL injection attack ?
Give main differences between "Truncate" and "Delete".
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What is truncate table?
What is table level trigger?
What is the difference between implicit and explicit transaction?
What are the general features of sql server management studio? : sql server management studio
What are the types of database recovery models?
What is the command dbcc checkdb used for?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
Can a trigger be created on a view?
What is normalization of database?
What is the process of normalising?
What is order of B+tree?
