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 Name	Is in 3NF?	Is in BCNF?	Explain
Table A	Yes or No	Yes or No	Table A is/is not in 3NF/BCNF because...
Table B	Yes or No	Yes or No	Table B is/is not in 3NF/BCNF because...
Table C	Yes or No	Yes or No	Table C is/is not in 3NF/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