Entity Relationship Diagram (ERD) Tutorial - Part 2
Learn how to create an Entity Relationship Diagram with Primary Keys, Foreign Keys, and Composite Keys in this advanced ERD tutorial. We provide step-by-step training on how to identify these different keys, as well as helpful information on bridge tables, data types, and how your ER Diagram relates to a database management system.
A Primary Key is an attribute (or field) that uniquely identifies every record in a certain table. There’s one Primary Key per entity, and they must be unique, never-changing, and never-null. You note a Primary Key in your Entity Relationship Diagram with “PK” to the left of the appropriate attribute.
A Foreign Key is an attribute in one entity that links to the Primary Key of another entity. Consequently, they enable relationships between those entities. There can be multiple foreign keys per entity, or none at all. You note a Foreign Key in your ERD with “FK” to the left of the appropriate attributes.
——
Learn more and sign up:
http://www.lucidchart.com
Follow us:
Facebook: https://www.facebook.com/lucidchart
Twitter: https://twitter.com/lucidchart
Instagram: https://www.instagram.com/lucidchart
LinkedIn: https://www.linkedin.com/company/lucidsoftware
Видео Entity Relationship Diagram (ERD) Tutorial - Part 2 канала Lucidchart
A Primary Key is an attribute (or field) that uniquely identifies every record in a certain table. There’s one Primary Key per entity, and they must be unique, never-changing, and never-null. You note a Primary Key in your Entity Relationship Diagram with “PK” to the left of the appropriate attribute.
A Foreign Key is an attribute in one entity that links to the Primary Key of another entity. Consequently, they enable relationships between those entities. There can be multiple foreign keys per entity, or none at all. You note a Foreign Key in your ERD with “FK” to the left of the appropriate attributes.
——
Learn more and sign up:
http://www.lucidchart.com
Follow us:
Facebook: https://www.facebook.com/lucidchart
Twitter: https://twitter.com/lucidchart
Instagram: https://www.instagram.com/lucidchart
LinkedIn: https://www.linkedin.com/company/lucidsoftware
Видео Entity Relationship Diagram (ERD) Tutorial - Part 2 канала Lucidchart
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Entity Relationship Diagram (ERD) Tutorial - Part 1Normalization - 1NF, 2NF, 3NF and 4NFNatural Language Processing in PythonSQL vs NoSQL or MySQL vs MongoDBDatabase Design 18 - Designing Many-to-Many RelationshipsUML Use Case Diagram TutorialCreating Primary and Foreign Keys in SQL Server 2012Learn SQL in 1 Hour - SQL Basics for BeginnersHTML Crash Course For Absolute BeginnersUML Class Diagram TutorialTutorial - Diagrama Entidad-Relación (ER)Basic Concept of Database Normalization - Simple Explanation for BeginnersHow to Make a UML Sequence DiagramMySQL Tutorial for Beginners [Full Course]Weak entitySecond Normal Form (2NF) | Database Normalization | DBMSLogical Database Design and E-R DiagramsEntity Relationship Diagram (ERD) Training VideoDatabase Design 36 - 1NF (First Normal Form of Database Normalization)Access 2007 Tutorial 1.3. Many to Many Relationship