1. Writing a set of 5-6 rather simple SQL queries.
2,3. Two 1-2 pages essay about a database design algorithm learned in slides, reproducing the algorithm and describing it line by line with its logic and applications.
Possible topics for the 2 essays:
1- Normalization goals
2- Functional Dependencies closure
3- Algorithm for Attribute Closure and Finding Candidate Keys
4- Algorithm for computing the Functional Dependencies canonical cover
5- Algorithm for verifying preservation of functional dependencies
6- Algorithm for Verifying that decompositions have Lossless-Join
7- Algorithm for verifying satisfaction of 2NF, 3NF, 4NF, BCNF
8- Algorithm for decomposition in 3NF, 4NF, BCNF