Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Exam tomorrow need help with ER diagram

  • 09-05-2013 04:56PM
    #1
    Blargh
    Registered Users, Registered Users 2 Posts: 63 ✭✭


    Hi guys ive an exam tomorrow and been going through the past papers and found a question on making and er diagram was hinted that somthig like this will be on the exam. I have no notes on it and thers none online either can you help me figure it out with the relationships.


    Explain with an appropriately labelled diagram thenotation used in Entity Relationship diagrams.

    Construct an entity-relationship diagram to model theinformation given above. Ensure that allentities have between three and six properties. Provide primary and foreign keys. State assumptions.



    A college has 6 major entities: lecturers, students,classes, subjects, examinations and books.

      [*]A lecturer lecturers many subjects, and thus many classes
      [*]Each subject has one book
      [*]Each subject has one examination
      [*]A class has many students, although a student can belong to only one class.


    Comments

    • #2
      Kenny Logins
      Registered Users, Registered Users 2 Posts: 9,061 ✭✭✭Kenny Logins


      Where is the exam and what time should I arrive at?


    • #3
      Blargh
      Registered Users, Registered Users 2 Posts: 63 ✭✭Blargh


      Kenny Logins wrote: »
      Where is the exam and what time should I arrive at?

      Ha sure :) :P


    Advertisement