hello every body
i want help for the ERD , if any missing in that pleas tell me and advise me how can i modify this ERD .
this ERD for Online Library management system . the diagram attached
bahr_alhalak
4
Junior Poster in Training
Recommended Answers
Jump to PostI have attached one file. I think you need three table. I am not sure why you have used book table and reverse table. I have used only user, bookinfo and borrow tables.
All 4 Replies
urtrivedi
276
Nearly a Posting Virtuoso
I have attached one file. I think you need three table. I am not sure why you have used book table and reverse table. I have used only user, bookinfo and borrow tables.
bahr_alhalak
4
Junior Poster in Training
thanx to interacte with my question . but what about reversation table ?
and u mention one to many relation betwen user and borrwing table??
and no relation between book and user?how it happen?
plez more explination..
and thanx
urtrivedi
276
Nearly a Posting Virtuoso
borrow table is transcation table and it contains user id and book id. so user is related to book in borrow table. User is not directly connected with book.
Now what do you mean by reversation?
bahr_alhalak
4
Junior Poster in Training
sorrry i mean reservation table....
reserve a particular book borrowed by others currently!!!
so i think we need to reservation
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.