View Full Version : is this Entity Relationship diagram correct?


ericsermon
07-25-2011, 02:56 AM
Hi,

I saw a few posts on here about E-R diagrams and would be very grateful to anyone who can help me out.

I have a entity relationship diagram, the following conditions have to be satisfied/are true:

each tenant can rent a room in a hall of residence OR apartment.
lease agreements are made at the start of each year.
(hall of residence = 1 person to each room)
(apartment = 3 people to each room)
apartments are inspected by a accomodation officers (members of staff)

I've attached the image, but just in case heres the link:

hxxp://imageshack.us/f/15/erdiagram.jpg/

(replace "xx" with "tt")

Is the diagram correct?

thanks
ES

jdraw
07-25-2011, 05:36 AM
For more info on ER diagramming see this link
http://www.rogersaccesslibrary.com/forum/topic238.html

and review the first 3 topics.
Good luck.