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