FD and Normalization

General objective of this lecture is to present on FD (Functional Dependency) and Normalization. Here explain how to control the redundancy of data and how to preserve the consistency of data. Data redundancy occurs when a piece of data is stored in more than one place in the database. Normalization refers to a reversible step-by-step process in which a given set of relations is replaced by successive collections of relations that have a progressively simpler and more regular structure.