SpEAK:Normalization Document v1.0

Experiment_User: User ID (PK), Last Name, First Name, Phone, Email, Campus, Experiment Number, Title, Date Created, Date Modified, Description, Keyword ID, Keyword Name, URL ID, URL Name, Attachment ID, Attachment Name
 * Starting Entity with Unique Identifier

Experiment_User will be set up as a super-type containing 3 sub-types: Experiment_Admin, Author, and Viewer Experiment_User: User ID (PK) Experiment_Admin: User ID(PK, FK), Last Name, First Name, Phone, Email, Campus Author: User ID(PK, FK), Last Name, First Name, Phone, Email, Campus Viewer: User ID(PK, FK) Experiment: Experiment Number(PK), User ID (FK), Title, Date Created, Date Modified, Description Accessible Experiments: User ID(PK,FK), Experiment Number(PK,FK) Keyword: Keyword ID(PK), Experiment Number(FK), Keyword Name URL Link: URL ID(PK), Experiment Number(FK), URL Name Attachment: Attachment ID(PK), Experiment Number(FK), Attachment Name
 * First Normal Form

Second Normal Form has already been achieved because entities are in First Normal Form and entities with composite keys either do not have non-key attributes or only one key attribute is present which all non-key attributes depend upon.
 * Second Normal Form

Third Normal Form has also been achieved because entities are in Second Normal Form and all non-key attributes depend only on key attributes and not on other non-key attributes.
 * Third Normal Form