B ITM 330 Lecture 3: Chapter 2b notes

• School: SUNY Albany
• Department: Information Technology Management
• Course: B ITM 330
• Professor: Jakov Crnkovic

Document Summary

Chapter two part 2: functional dependency a relationship between attributes in which one attribute. Functional dependency (or group of attributes) determines the value of another attribute in the same table: the attribute (or attributes) that we use as the starting point (the variable on the. Determinants left side of the equation) is called a determinant. Normalization deleted, or modified without creating update anomalies. Normalization principles: relational design principles for normalized relations, to be a well-formed relation, every determinant must be a candidate key, any relation that is not well formed should be broken into two or more well-formed relations. Modification problems: tables that are not normalized will experience issues known as modification problems. Insertion problems: difficulties inserting data into a relation, modification problems, difficulties modifying data into a relation, deletion problems, difficulties deleting data from a relation, most modification problems are solved by breaking an existing table into two or.