a. Design a simple database with at least 5 relations for such applications as students taking courses taught by faculty in class rooms at a specific time

b. Is the relation R in 3NF? Explain your answer using functional dependencies.

c. If your R above is in 3NF, create at least one table from your database that is not in 3NF. If your R is not in 3NF, decompose R into 3NF relations.

In each case, you are required to specify the primary keys and the functional dependencies that exist in each of the relations and thus, in the database with some discussions