This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.1). Normalization is the process of organizing the records from tables of a database in order to reduce redundancy and dependency.
2). A table it is said to be in 1NF (first normal form) when all key attributes are defined and there aren’t repeating groups in the table. Besides this, all remaining attributes are dependent on the primary key. On the other hand, usually a table in first normal form still contains partial dependencies. These are commonly based on just pieces of primary key and transitive dependencies that are based on a non-key attribute.
3). A table is in 2NF (second normal form) when it is already in 1NF and it also doesn’t include any partial dependencies. A table in 2NF can still contain transitive dependencies, such as dependencies based on attributes that are not part of the primary key....