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.

Interview Answer

1 Answer


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 question, Sign In with Facebook or Sign Up