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
- 5029 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
Relational calculus is what type of language?
What is tabulation?
What is scrollable cursor?
Call by value and call by reference in procedure and function, with NOCOPY.
Explain the ways to controlling cursor behavior?
Can sql server be linked with other servers like oracle?
How to configure odbc dsn with different port numbers?
Explain what is lock escalation and what is its purpose?
Explain the difference between primary keys and foreign keys?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
Can a table be created inside a trigger?
What is reference section?
What is store procedure?
What is user-defined inline table-valued function?
How to get the query of a table in sql server?
