Learn how to create an Entity Relationship Diagram with Primary Keys, Foreign Keys, and Composite Keys in this advanced ERD tutorial. We provide stepbystep 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, neverchanging, and nevernull. 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.

——

00:00 Overview
0:32 Recap from ERD Part 1
00:51 Primary Keys
00:56 Primary Key Examples
1:54 Primary Key Rules
5:43 Lucidchart
6:06 Foreign Keys
7:43 Foreign Key Rules
8:20 Composite Primary Keys
10:11 Composite Primary Key Rules
10:46 Bridge Tables
12:50 I've finished my ERD. Now what?
14:19 Wrap Up

——

Learn more at: training.lucid.co
Sign up for free at: https://www.lucid.co

Follow us:
Facebook:   / lucidsoftware  
Twitter:   / lucidsoftware  
Instagram:   / lucidsoftware  
LinkedIn:   / lucidsoftware