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
- 4985 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
Why use cursor in sql server?
What are system databases in ms sql server?
Can you name a few encryption mechanisms in sql server?
How to include text values in sql statements?
What is sql server programming?
What command is used to rename the database?
What are scalar functions?
Does windows server 2016 come with sql server?
Do you know the different ddl commands in sql?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is store procedure? When do you use?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is tablix?
List some of the rules that apply to creating and using a ‘view’
What is abstracting periodical?
