O que são as Formas Normais em Bancos de Dados?

Want to learn more about our Complete SQL Course? Click the link below to secure your spot in the next class: https://lp.hashtagtreinamentos.com/es... -------------------------------------------------------------------- DOWNLOAD THE SQL MINI-COURSE: https://pages.hashtagtreinamentos.com... ----------------------------------------------------------------------- ► To Download the File Used in the Class, Access: https://pages.hashtagtreinamentos.com... ► What are Database Anomalies? ► How to Adjust the Structure of a Database    • O que São Anomalias em Bancos de Dados?   ► How to Adjust the Structure of a Database    • Como Ajustar a Estrutura de um Banco de Dados   ► 8 Steps to Data Modeling    • 8 Etapas para Modelagem de Dados   ----------------------------------------------------------------------- If you prefer the video in text format: https://www.hashtagtreinamentos.com/o... ----------------------------------------------------------------------- Recommended Video: ► Basic Course on SQL:    • Fundamentos do SQL - Curso de SQL - Aula 1   ----------------------------------------------------------------------- Hey Impressives! In today's lesson, I want to explain to you what normal forms are in databases. The idea is to show you the concept in database modeling so that you can ensure that your tables are well-structured. The 5 concepts I'm going to show you are: Functional dependency, partial functional dependency, transitive dependency, multivalued attributes, and composite attributes. Then I'll explain what normalization is, and finally, I'll show you practical examples of the first normal form, second normal form, and third normal form. So that you can have a well-structured database. We have more forms, but these 3 will already be enough to better structure your database! ----------------------------------------------------------------------- Hashtag Programming ► Subscribe to our channel: http://bit.ly/3c0LJQi ► Turn on notifications (click the bell icon)! ► Like our video! ----------------------------------------------------------------------- Social Media ► Blog: https://bit.ly/2MRUZs0 ► YouTube: http://bit.ly/3c0LJQi ► Instagram: https://bit.ly/3o6dw42 ► Facebook: http://bit.ly/3qGtaF2 Here on the Hashtag Programming channel, we teach various Python and SQL tips so you can develop your programming and database skills! ----------------------------------------------------------------------- Lesson Content 00:00 Introduction 02:35 5 Important Concepts 03:15 Concept 1: Functional Dependency 05:04 Concept 2: Partial Functional Dependency 08:15 Concept 3: Transitive Functional Dependency 11:00 Concept 4: Multivalued Attributes 12:30 Concept 5: Composite Attributes 13:18 What is Normalization? 14:34 Normal Forms 16:14 First Normal Form (1NF) 17:06 Practical Example (1NF) 14:34 Step 1 of 1NF 17:52 Step 2 of 1NF 20:21 Second Normal Form (2NF) 21:22 Practical Example (2NF) 25:25 Third Normal Form (3NF) 26:33 Practical Example (3NF) 30:17 Lesson Summary 32:21 Conclusion #sql #hashtagprogramacao