Assignment #3 ComS 461/561 Due December 2, 2009

Given the set of functional dependencies F = {instructorid→name,instructoradd,dept; dept→building; courseid→courseName,courseCredit} is the design that you used in Assignment #1 in third normal form? Why or why not? If not give a set of relation schemes that would be in third normal form.

Note that this is a written exercise and doesn’t require any implementation.