I'm new to DBM and I'm trying to learn it online. Honestly, I need some help with this. I don't know if I'm doing this right, and any help will be appreciated. This is my answer for i. enter image description here

  • There are many comprehensive resources online. Eg. Textbooks and univeristy slides. (Eg at stanford.edu & sfu.ca .)
    – philipxy
    Jan 3, 2016 at 1:23
  • 1
    Where did you get this exercise? What is particular kind of ER/EER? How do they expect to map to a schema?
    – philipxy
    Jan 5, 2016 at 5:23

1 Answer 1


There should be a table for every box, ie entity type/class, and every diamond, ie relationship type/class. There should be a column for every oval, ie attribute/property. Each line from a diamond to a box is indicates a foreign key. Relationship PKs are composite and consist of FK columns to associated/participant/referenced entity types.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.