Interested to Buy Any Domain ? << Click Here >> for more details...
Diff between Composite key, Alternate Key, Candidate Key,
Primary Key, Unique Key, Super Key, Foreign Key
- 1 Answers
- 10856 Views
- I also Faced
- E-Mail Answers
Answer / sapan saxena
Super Key: All possible keys which can identify entities in
the table uniquely.
Primary Key: uniquely identify each entity in the table and
does not contain null and duplicate vales.
Composite key: The combination of two or more than two keys
which identifies entities uniquely.
Candidate Key: Nominee for the primary key.
Alternate Key: Rest of the candidate keys which is not the
primary key.
Unique Key: Same as primary key but can accept one null key
only.
Foreign Key: A foreign key is one or more columns whose
value must exist in the primary key of another table.
| Is This Answer Correct ? | 41 Yes | 2 No |
What are scalar functions?
What is a schema in ms sql server 2005?
Please illustrate physical database architecture? : SQL Server Architecture
What is a non-clustered index?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
What is normalization and its types?
How to count groups returned with the group by clause in ms sql server?
How m-m relationships are implemented?
What’s the use of custom fields in report?
What do you think of this implementation? Can this be implemented better?
Explain about system stored procedure?
what is for foreign key ??
4 Answers CarrizalSoft Technologies, Sabic,
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
