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
- 17036 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 you size a resultset?
what is a self join? : Sql server database administration
Explain contrast amongst grouped and non-bunched records?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
How to get the definition of a trigger back?
How to modify an existing user defined function?
How to test odbc dsn connection settings?
What command do we use to rename a db, a table and a column?
How many primary keys are possible in a table?
How to list all objects in a given schema?
What is the use of custom fields in report?
Explain the benefits of user-defined functions?
How to turn on the mssql api module in php?
How do you implement session management in SQL Server mode?
Do you know what is sql injection?
