CS 4250: Project Part 4 Template


Project name, names and emails of project group members


Section 1: Initial Relations
create table A (...
create table B ...
create table C ...
create table D ...
create table ...
create table ...


Section 2: Functional Dependencies
One possible way to arrange a list of FDs:
Functional dependencies Relation(s)
a1 -> a2 A
a1 -> a3 A
a1 -> a4 A
a3 -> a4 A
b1 -> b2 B
b1 -> b3 B
b1 -> b4 B
b1 -> b5 B

Another possible way to arrange a list of FDs:

A Table
a1 -> a2
a1 -> a3
a1 -> a4
B Table
b1 -> b2
b1 -> b3
b1 -> b4
b1 -> b5


Section 3: Normalization

Table A is/is not in 3NF because... Table A is/is not in BCNF because...

Table B is/is not in 3NF because... Table B is/is not in BCNF because...


Section not all projects will need: Normalized versions of tables that were not BCNF or discussion(s) of why 3NF is appropriate in each case


Group Member Contributions