Entity Relationship Diagram Database Example. Erd entity relationship diagram is used to show the logical structure of databases. People customers or other objects relate to each other in an application or a database.
Cs3200 database design spring 2018 derbinsky outline 1. For example in a university database we might have entities for students courses and lecturers. They are created when a new system is being designed so that the development team can understand how to structure the database.
People customers or other objects relate to each other in an application or a database.
An entity relationship diagram erd is a type of diagram that lets you see how different entities e g. The music database is designed to store details of a music collection including the albums in the collection the artists who made them the tracks on the albums and when each track. In an er diagram cardinality is represented as a crow s foot at the connector s ends. They might have relationships with courses and lecturers.
