D4DME – Entity Relationship Diagram (ERD)

Last Tuesday we had a seminar which revolved around Entity Relationship Diagrams (ERD). This is basically a flow-chart diagram which shows the relationships between many entities of a certain database.

An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure.” – http://www.techopedia.com/definition/1200/entity-relationship-diagram-erd

erd explained

http://docs.oracle.com/cd/A87860_01/doc/java.817/a81358/05_deva.gif

Above is an image which explains the various symbols used within ERD’s and I need to become familiar with these so that I can focus my skills on the more complicated parts of the project. In the seminar we began to think what we would need to include in the database design and therefore in our ERD. We looked at a photo sharing website and came up with the following.

photo erd

For our task to complete over the next week, we had to create our own ERD – a recipe website where users upload their recipe title, description and a photo. We had to decide what would need to be included and below is what I came up with.

recipe erd

Advertisements

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