SQL Interview Questions | Solving Database Problem
Question
You are a part of a MNC and someone complains that their app is running slow because of what they think is a “database problem”. How do you go about investigating the slowness and helping them to improve their queries?
(Hint- You need to think logically and get the job done in least time possible)
in progress
2
SQL
4 years
1 Answer
1394 views
Great Grand Master 0
Answer ( 1 )
It could be normalization problem , We can try looking for how we can normalize the database –
1. Each attribute should contain singular value
2. No Partial Dependency
3. No Transitive Dependency
4. Every function dependency should be super key