Seneca College
DBS 211
Lab 10 – Normalization (2NF, 3NF) Objective: Students will learn: To continue the normalization of user views from 1NF to 2NF and 3NF How to identify and remove partial dependencies How to identify and remove transitive dependencies Submission: Save your lab file as a PDF file. You need to submit a single PDF file for this lab. The name of
...[Show More]
Lab 10 – Normalization (2NF, 3NF) Objective: Students will learn: To continue the normalization of user views from 1NF to 2NF and 3NF How to identify and remove partial dependencies How to identify and remove transitive dependencies Submission: Save your lab file as a PDF file. You need to submit a single PDF file for this lab. The name of the file must be as follow: L10_ID_LASTNAME.pdf Definitions: Definition: A relation is in 1NF if it contains no multi-valued dependencies (also known as repeating groups). Definition: A relation is in 2NF it is in 1NF and it contains no Partial Dependencies. Definition: A Partial Dependency occurs when a non-key attribute(s) is dependent on (or is determined by) a pa
[Show Less]