From the course: Data Steward Foundations
Join today to access over 23,100 courses taught by industry experts.
Entity-relationship diagrams
From the course: Data Steward Foundations
Entity-relationship diagrams
- [Instructor] Entity relationship diagrams, also known as ER diagrams, provide database designers with a valuable tool for modeling the relationships between database entities in a clear, precise format. This industry standard approach uses a series of block shapes and lines to describe the structure of a database in a manner understandable to all data professionals. In a database model, each object that you wish to track in the database is known as an entity. Normally, each entity is stored in a database table, and every instance of an entity corresponds to a row in that table. In an ER diagram, each entity is depicted as a rectangular box with the name of the entity contained in the box. For example, a database containing information about individual people would likely have an entity called Person. This would correspond to a table with the same name in the database, and every person tracked in the database would be an instance of that Person entity and have a corresponding row in…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.