Lesson 3 - Database Flashcards
1
Q
what is normalizing?
A
s creating databases that are very efficient in utilizing
space and can be easily searched by storing data in the smallest data
pieces (within reason). e.g. breaking them down into separate fields.
2
Q
why do we normalize databases?
A
- To be able to search more efficiently – less superfluous data returned
- To be able to search more effectively – more options available
- To avoid duplication
- To keep consistent and not mixed units
- To improve data integrity
- To enable efficient validation – (reasonableness and completeness)
3
Q
further normalization
A
can not have multiple values in the same field e.g. kgs and grams together
