CMPS 180

Winter 2003

Due Tuesday, Feb 18th 2003 at 11:59 pm



Refer to Project Part2 for Logistics and Late Policy.

The schema we are working with in this part of the project is the schema designed for FANDANGOOSE in Project Part I.

I. For each relation in your schema, specify all the non-trivial functional dependencies. Any functional dependency that
actually holds should be specified or should follow from the specified functional dependencies.

Note: Some relations may not have any non-trivial functional dependencies.

II. Check if your relational schema is in BCNF. If not, decompose your relations so that each relation in your schema is in
BCNF.

Note: There may be some relations that do not violate BCNF requirement.


Important: Even if all your relations are in BCNF, you should show all the steps required to prove that they are in BCNF.

What to submit:

For this part of the project you will only submit a README file, that will contain your name and cats id and the answers for
steps I and II specified above.

How to submit:

submit cmps180-wt.w03 proj3 README

or

submit cmps180-wt.w03 proj3-late README
if your project part is late.