hi there,

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

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

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.

any one?? i really need help 2day is last day to submit ERD of library plz help me out

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...

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

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