Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2011

    Draw an ER diagram of library management

    I have to draw the ER diagram of library management base on these following requirements:

    "The library has books, CDs, tapes, and so forth, which are lent to library patrons. The latter have accounts, addresses, and so forth. If a patron is a minor, she/he must have one sponsoring patron who will be responsible for paying any penalties incurred by the minor. Information must be recorded to identify items that are overdue. Each type of items (tapes, CD, books, etc.) for loan has its own loan period, and penalty rate for overdue loans. Include in your E-R diagram information about keys and constraints if any.

    You should come up with 2 different ER diagram, i.e., with and without the IsA construct. Which one would you prefer? Justify your preference, in comparing the database schemas into which ER diagrams may be converted."

    There are what I've done, but I'm not sure they are correct or not.
    can anyone check over for me and give me some ideas about the constraints between entities?
    Attached Thumbnails Attached Thumbnails BlankFlowchart_1.jpeg   BlankFlowchart_2.jpeg   BlankFlowchart_3.jpeg  

  2. #2
    Join Date
    Jul 2012

    Data Models from Database Answers

    I have 15 Library Data Models on my Web Site listed towards the end of the middle column on this page :-

    The Basic Model includes Loans but the treatment is very simple :-
    Library System

    I will try to find the time to enhance it closer to your requirements.


    Barry in London

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts