SpEAK:Normalization Document v1.0

From Openitware
Jump to: navigation, search
Starting Entity with Unique Identifier

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

First Normal Form

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


Second 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.

Third 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.