Exercise DB Theory

1. Normal Forms:
   Give three examples for relations that are NOT in the 1st, 2nd, 3rd normal form.
   Normalize your examples according to the corresponding form criteria.

2. DB Design and ER Model:
   Design a DB "workshop" for a group of students and teachers working on several projects.
   A project is supervised by exactly one teacher, but each teacher may supervise more than one project. The number of students in a project is not limited and students may participate in as may projects as they like.
   Draw an ER diagram of your DB design.