Digitals of an Undergraduate

Chloe, 19 from Hertfordshire, UK. First year Digital Media Design student at Bournemouth University

Entity Relationship Model – Design for Digital Media Environments

Leave a comment

My last lecture was all about the Entity Relationship Model.
In software engineering, an entity–relationship model (ER model) is a data model for describing the data or information aspects of a business domain. A graphical representation of entities and their relationships to each other, used in computing in regard to the organisation of data within databases or information systems.An entity is a piece of data, an object or concept about which data is stored.

An ERD typically consists of four different graphical components:

1. Entity
2. Relationship
3. Cardinality
4. Attribute

There are three different types of ERD’s:

1. One-to-One
2. One-to-Many
3. Many-to-Many

This diagram demonstrates examples for each type of ERD.
For a binary relationship set the mapping cardinality must be one of the following types:

One to One – A husband and wife

One to Many – A football team with many footballers

Many to Many – Lots of students studying lots of different subject.

Advertisements

Author: Chloe Rose Hutchings

Chloe, 20 from Hertfordshire BA (Hons) Digital Media Design student studying at Bournemouth University.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s