• Best of luck to the class of 2024 for their HSC exams. You got this!
    Let us know your thoughts on the HSC exams here
  • YOU can help the next generation of students in the community!
    Share your trial papers and notes on our Notes & Resources page
MedVision ad

ERDs (1 Viewer)

taker0

Member
Joined
Nov 24, 2007
Messages
60
Gender
Male
HSC
2009
Do we need to know them? cause i keep looking for them in my textbook and cant find...wahts do they look like? does it have something to do with normalising etc?

also what do ERDs look like??
 

grendel

day dreamer
Joined
Sep 10, 2002
Messages
103
Gender
Male
HSC
N/A
ERDs (Entity Relationship Diagrams) are just schemas. No difference at least in the IPT course
 

Makro

Porcupine
Joined
May 16, 2006
Messages
415
Location
In between.
Gender
Male
HSC
2009
See attached. As far as I know this is fairly correct. It's an ERD for my olympics database (one of our assessments).

EDIT: My teacher basically gave me this ERD so it can't be too wrong.
 

mijoe

Member
Joined
May 18, 2008
Messages
72
Location
Behind you
Gender
Male
HSC
2010
ERD are the same as schematic diagrams. They show relationships between entities in a database.
 

bazookie

Member
Joined
May 28, 2008
Messages
45
Gender
Male
HSC
2008
yes but look at the website... entity relationship diagram with diamonds and boxes wtf? my teacher told me that we just have to draw schemas for thos questions but my teacher is a drop kick so i wouldn't trust him.
 

Makro

Porcupine
Joined
May 16, 2006
Messages
415
Location
In between.
Gender
Male
HSC
2009
The wikipedia page is entirely different. Trust me when I say that ERDs are schemas which look like the picture I attached. I've done countless tests/assignments over the past two years to know that this is true.
 

cxlxoxk

Member
Joined
Feb 17, 2008
Messages
769
Gender
Male
HSC
2008
Makro said:
The wikipedia page is entirely different. Trust me when I say that ERDs are schemas which look like the picture I attached. I've done countless tests/assignments over the past two years to know that this is true.
Entity-relationship diagrams don't show single entities or single instances of relations. Rather, they show entity sets and relationship sets. Example: a particular song is an entity. The collection of all songs in a database is an entity set.

i found this on the wikipedia page, i think the wikipedia page is the same thing, except just explaining it simpler?

I think what it is saying there is that a ERD/Schema wouldn't show eg. "Chasing Cars" and " Snow Patrol"...it would show "song name" and "artist".
 

xcbx

New Member
Joined
Jul 15, 2007
Messages
3
Gender
Female
HSC
2008
In the Heinemann textbook it says "An ERD is a graphical method of identifying the entities and showing the relationship between them. "
Cambridge says "An ERD is one type of schematic diagram. It maps entity types, the relationships between them and the characteristics of the relationships etween entity types."

The attachment that Makro posted looks like the one in the Heinemann textbook so I'd assume that it's correct.

cxlxoxk said:
Entity-relationship diagrams don't show single entities or single instances of relations. Rather, they show entity sets and relationship sets. Example: a particular song is an entity. The collection of all songs in a database is an entity set.
I'm not sure this is true since my Cambridge book called the table 'headings' entities. Although I'm not sure how correct those books are >>

cxlxoxk said:
I think what it is saying there is that a ERD/Schema wouldn't show eg. "Chasing Cars" and " Snow Patrol"...it would show "song name" and "artist".
^^I agree with that though.
 

ondroo

*Sigh*
Joined
Oct 30, 2007
Messages
53
Gender
Male
HSC
2008
Makro said:
The wikipedia page is entirely different. Trust me when I say that ERDs are schemas which look like the picture I attached. I've done countless tests/assignments over the past two years to know that this is true.
Agreed. for the purposes of this course they r like the picture makro attached.

See the board of studies support document page 30. It has a simple one there (but its actually wrong cause it doesnt show relationships).
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top