This assignment teaches database design through normalization and ER modeling. Tasks: Normalize a table to 3rd normal form. Create an ER diagram based on the normalized tables. Create database tables based on the ER diagram.