Database Normalisation: Second Normal Form
This video is part of a series about database normalisation. It explains how to transform a database, which is already in first normal form, into second normal form by working through an example. It covers the criteria for the second normal form including ensuring that a relation, that is a table, does not contain any partial dependencies on the primary key. The video explains what is meant by a functional dependency and a partial dependency.
Видео Database Normalisation: Second Normal Form канала Computer Science
Видео Database Normalisation: Second Normal Form канала Computer Science
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Database Normalisation: Third Normal FormSecond Normal Form (2NF) | Database Normalization | DBMSDatabase Normalisation: First Normal FormDatabase Normalization in SQL - 1NF, 2NF, 3NF, 4NF - SQL Training OnlineBasic Concept of Database Normalization - Simple Explanation for BeginnersBasic concept of normalization | Need of Normalization in DBMS1st, 2nd and 3rd Normal Form (Database Normalisation)Why Computers Can't Count SometimesDatabase Design 37 - 2NF (Second Normal Form of Database Normalization)1NF 2NF 3NF DBMSThird Normal Form (3NF) | Database Normalization | DBMSBoyce-Codd Normal Form (BCNF) | Database Normalization | DBMSFunctional dependency in DBMS | What is functional dependency | Database Management SystemNormalization - 1NF, 2NF, 3NF and 4NFDatabase Transactions (ACID)5th Normal Form (5NF) | Join Dependency | Database NormalizationSecond Normal Form in DBMS | 2NF in dbms | Normalization in DBMSHow to do database normalizationFirst Normal Form (1NF) | Database Normalization | DBMS