Results 1 to 7 of 7

Thread: Help Needed...

  1. #1
    Join Date
    Apr 2009
    Posts
    4

    Help Needed...

    hi there,

    im new here i need help i want to make ERD of library plz help...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    well you need a tool to create your ERD. depends on your budget your exeprience and your preferences
    some use tools like MySQL Workbench or SQL Architect, or DbDesigner, some use pencil + paper + rubber. the choice is yours
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Apr 2009
    Posts
    4
    nah i just have to make assignment on the paper of ERD model of library or just print it out with detail information of that model as well.

  4. #4
    Join Date
    Apr 2009
    Posts
    4
    any one?? i really need help 2day is last day to submit ERD of library plz help me out

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    well what have you done to date?
    I doubt anyone here is going to do your homework for you, they may assisst with any tricky problmes you have, they may look at the the ERD and make suggestions or ask questions to get you to validate it.

    but ultimately its your homework, you have to do it...
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    Apr 2009
    Posts
    4
    ya thats for sure that its my work i have to do this but i m new to make library ERD i just need good assist to do my work.

    here is one rejected model

    Click image for larger version. 

Name:	library.GIF 
Views:	2161 
Size:	8.8 KB 
ID:	9470

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by its47
    here is one rejected model
    the only thing i see wrong with it is book_borrowing_id -- you don't need a separate PK for a relationship table, just make the two FKs part of the PK, like you did for book_authors and book_categories, but add date_borrowed to the PK as well

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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