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 '16 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 '16 at 5:23

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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