BMGT 402 Lecture Notes - Lecture 22: Functional Dependency, Candidate Key, Data Integrity
3 Apr 2017
School
Department
Course
Professor
Document Summary
Bmgt402 lecture 22 chapter 14: normalization cont. The process of normalization: formal technique for analyzing a relation. Based on its primary key and the functional dependencies between the attributes of that relation: often executed as a series of steps. Each step corresponds to a specific normal form, which has known properties. Identify functional dependencies: identify all function dependencies between a set of attributes is relatively simple: If the meaning of each attribute and the relationships between the attributes are well understood: this information should be provided by the enterprise. In the form of discussions with users and/or documentation such as the users" requirements specification: if users are unavailable or documentation is incomplete. More on functional dependency: complete set of functional dependencies (y) for a given relation can be very large, important to find an approach that can reduce set to a manageable size.
