Interested to Buy Any Domain ? << Click Here >> for more details...
what are the joins,primary key,foriegn key, candidate key,
super key and expain them?
- 6 Answers
- 17225 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / vikash kr pandey
1> JOIN:- JOIN IS USED TO VIEW AND RETRIEVE DATA FROM MULTIPLE TABLE OR RELATED TABLES IN A SINGLE RESULT SET.
2> PRIMARY KEY:-PRIMARY KEY IS A SET OF COLUMNS WHOSE VALUES UNIQUELY IDENTIFY ALL THE ROWS IN A TABLE AND CAN NOT CONTAIN NULL VALUES.
3> FORIEGN KEY:-A COLUMN IN ONE TABLE WHOSE VALUES MATCH THE PRIMARY KEY IN SOME OTHER TABLE IS CALLED A FORIEGN KEY.
4> CANDIDATE KEY:-ANY ATTRIBUTE THAT IS UNIQUELY IDENTIFIES A ROW IN A TABLE IS A CANDIDATE FOR THE PRIMARY KEY. THIS TYPE OF ATTRIBUTE IS CALLED CANDIDATE KEY.
5> SUPER KEY:-THE SUPERTYPE IS DESCRIBED BY ATTRIBUTES THAT BELONGS TO ALL SUBTYPES AND CONNECTED TO THE RELATIONSHIP WITH A LINE CONTAINING A CROSSBAR.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I view a procedure in sql server?
How to create a large table with random data for index testing in ms sql server?
What is relationship? What number of sorts of relationship are there?
How to modify an existing stored procedure in ms sql server?
What are the advantages of sql azure?
Is sql server free?
Give an example of SQL injection attack ?
What is database black box testing?
How to select some specific columns from a table in a query in ms sql server?
How do I view views in sql server?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
What do you do in data exploration
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
What is difference between createstatement and preparedstatement?
What will be query used to get the list of triggers in a database?
