interview questions shared by candidates
What are some of the things you might consider when designing a database?
(Books have been written about this). "Normalization vs. denormalization, data model accurately reflects problem domain, adaptability / maintainability, performance, indexing, partitioning.
The key aspects to consider are normalization vs. denormalization, partitioning, data model accurately reflects problem domain, adaptability and maintainability, performance, and indexing
Don't let the interviewer answer the question for you. He will keep talking and will try to put words in your mouth / help you, or at least give you the feeling. You have to ensure that you are answering the question the way you want to answer it using your ideas, not theirs. Don't be shy.