|
INTERVIEW QUESTIONS
DATABASE
OBJECT RELATIONAL DATABASE
DETAILS
Question: What is third normal form?
Answer: An entity is in the third normal form if it is in the second normal form and all of its attributes are not transitively dependent on the primary key. Transitive dependence means that descriptor key attributes depend not only on the whole primary key, but also on other descriptor key attributes that, in turn, depend on the primary key. In SQL terms, the third normal form means that no column within a table is dependent on a descriptor column that, in turn, depends on the primary key.
|
|
|
Category |
Object Relational Database Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7882 users |
Added on |
8/4/2015 |
Views |
68994 |
Rate it! |
|
|
Question:
What is third normal form?
Answer:
An entity is in the third normal form if it is in the second normal form and all of its attributes are not transitively dependent on the primary key. Transitive dependence means that descriptor key attributes depend not only on the whole primary key, but also on other descriptor key attributes that, in turn, depend on the primary key. In SQL terms, the third normal form means that no column within a table is dependent on a descriptor column that, in turn, depends on the primary key. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is ERD?
|
View Answer
|
|
When should you consider denormalization?
|
View Answer
|
|
What is the difference between hashed file stage and sequential file stage in relates to DataStage Server?
|
View Answer
|
|
What is data sparsity and how it effect on aggregation?
|
View Answer
|
|
What is the difference between star flake and snow flake schema?
|
View Answer
|
|
What is object relational database?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Object Relational Database Interview Questions & Answers - Exam Mode /
Learning Mode
|