Normalizing a database means laying out the tables in an efficient way with the main focus being on preserving the integrity of data. If the database is normalized, there is no repetition of data. The need for Normalization ...
Sunday, August 18, 2013
Normalization Process
Relations can fall into one or more categories (or classes) called Normal Forms Normal Form: A class of relations free from a certain set of modification anomalies. Normal forms are given names such as: First normal form (1NF) Second normal form (2NF) Third normal form (3NF) Boyce-Codd normal...
Functional Dependencies
A Functional Dependency describes a relationship between attributes within a single relation. An attribute is functionally dependent on another if we can use the value of one attribute to determine the value of another. Example: Employee_Name is functionally dependant on Social_Security_Number because Social_Security_Number can be used to uniquely...
Subscribe to:
Posts (Atom)
