When should you consider denormalization?
Submitted by: AdministratorDenormalization is used when there is a lot of tables involved in retreiving data.Denormalization is done in dimentional modelling used to construct a data ware house.This is not usually done for data bases of transactional systems.
Submitted by: Administrator
Submitted by: Administrator
Read Online Data Modeling Job Interview Questions And Answers
Top Data Modeling Questions
| ☺ | What is ERD? |
| ☺ | Why are recursive relationships are bad? How do you resolve them? |
| ☺ | What is second normal form? |
| ☺ | What is third normal form? |
| ☺ | What is an artificial (derived) primary key? When should it be used? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
