Database Assignment SQLite Assignment | Homework Help Websites

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