Harris Interview Question: Your given a complex database... | Glassdoor

Interview Question

Software Engineer Interview(Student Candidate) Lees Summit, MO

Your given a complex database diagram, asked how to perform

  certain joins on the tables. Then your told to find which SQL tables may have performance bottle necks due to the normalization scheme. You then suggest ways to de normalize the database.
Answer

Interview Answer

1 Answer

0

Best answer is to keep two tables of same information, a normalized set of tables and 1 non-normalize table. Use a set of db triggers to keep the non-normalize and normalize versions up to sync.

Interview Candidate on Jul 30, 2012

Add Answers or Comments

To comment on this, Sign In or Sign Up.