InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is Third Normal Form And Its Comparison With Star Schema? |
|
Answer» THIRD normal form is NORMALIZED form of storing data in a relational database. It eliminates functional DEPENDENCIES on non-key fields by putting them in a separate table. At this stage, all non-key fields are dependent on only the key. Star SCHEMA is a demoralized form of storing data, which paves the path for storing data in a multi-dimensional model. Third normal form is normalized form of storing data in a relational database. It eliminates functional dependencies on non-key fields by putting them in a separate table. At this stage, all non-key fields are dependent on only the key. Star schema is a demoralized form of storing data, which paves the path for storing data in a multi-dimensional model. |
|