This week we are covering one of the important database design concepts which is normalization. Discuss the following topics:
1. Data Anomalies – Explain in your own words using tables from your lab project. Also describe how such anomalies could be prevented.
2. Normalization – Assume that you have not read this lecture and you have created your lab project (tables). Do you think your tables in your project are normalized? Explain how this session helped your project? What are your thoughts on normalization?