In this chapter we will review the basic principles of database design and normalization. A well-designed database minimizes redundancy without losing any data. That is, we aim to use the least amount of storage space for our database while still maintaining all links between data.
We will cover the following:
- Database concepts and terminology
- Database design principles
- Normalization and the normal forms
- Database design exercises