Partial Key:
It is a set of attributes that can uniquely identify weak entities and that are related to same owner entity. It is sometime called as Discriminator.
Alternate Key:
All Candidate Keys excluding the Primary Key are known as Alternate Keys.
Artificial Key:
If no obvious key, either stand alone or compound is available, then the last resort is to simply create a key, by assigning a unique number to each record or occurrence. Then this is known as developing an artificial key.
Compound Key:
If no single data element uniquely identifies occurrences within a construct, then combining multiple elements to create a unique identifier for the construct is known as creating a compound key.
Natural Key:
When one of the data elements stored within a construct is utilized as the primary key, then it is called the natural key.
Interview Questions
- Accounts Payable Interview Questions (25)
- ACLS BLS Certification (5)
- Administrative Interview Questions (35)
- Airline Interview Questions (21)
- AJAX Interview Questions (202)
- ASP.Net Interview Questions (322)
- Baby Sitter Interview Questions (12)
- Bank Interview Questions (50)
- Basic Interview Questions (26)
- BlueTooth Interview Questions (177)
- Bookkeeper Interview Questions (42)
- C# Interview Questions (155)
- C/C++ Interview Questions (210)
- Call Center Interview Questions (68)
- Citizenship Interview Questions (23)
- Cobol Interview Questions (167)
- Computer Architecture Interview Questions (151)
- Computer Networks Interview Questions (160)
- Consulting Interview Questions (33)
- CSS Interview Questions (171)
- Customer Service Interview Questions (28)
- Data Structure Interview Questions (151)
- Data WareHousing Interview Questions (152)
- Database Interview Questions (421)
- EJB Interview Questions (200)
- Financial Interview Questions (130)
- Google & Microsoft Interview Questions (190)
- Hospitality Interview Questions (16)
- HR Interview Questions (173)
- HTML (155)
- Interview Questions for Employers (11)
- Interview Tips (169)
- Investment Banking Interview Questions (11)
- J2EE Interview Questions (249)
- J2ME Interview Questions (171)
- Java Interview Questions (485)
- JavaScript (167)
- JMS Interview Questions (154)
- JSP Interview Questions (155)
- Linux Interview Questions (176)
- MCSE Interview Questions (13)
- Medical Interview Questions (16)
- Microprocessors Interview Questions (162)
- Nanny Interview Questions (14)
- Networking Interview Questions (204)
- Nursing Interview Questions (35)
- Object Oriented Interview Questions (169)
- Operating System Interview Questions (154)
- Oracle Interview Questions (187)
- Other Interview Questions (169)
- Payroll Interview Questions (10)
- PeopleSoft Interview Questions (164)
- Pharmaceutical Interview Questions (10)
- PHP Interview Questions (158)
- Police Interview Questions (10)
- Police Officer Interview Questions (10)
- Private Equity Interview Questions (12)
- Puzzles (152)
- Questions to Ask during an HR Interview (161)
- Retail Interview Questions (12)
- Sales Interview Questions (10)
- SAP-ABAP Interview Questions (227)
- Secretary Interview Questions (11)
- Siebel Interview Questions (172)
- Software Testing (177)
- SQL Interview Questions (314)
- Struts Interview Questions (248)
- System Integration Interview Questions (173)
- Teacher Interview Questions (10)
- Teaching Assistant Interview Questions (11)
- Team Leader Interview Questions (13)
- Telephone Interview Questions (24)
- TIBCO Interview Questions (14)
- University Interview Questions (12)
- UNIX Interview Questions (184)
- VB.NET Interview Questions (154)
- VBScript Interview Questions (162)
- Visual Basic Interview Questions (144)
- XML Interview Questions (188)