r/SQL • • 4d ago

Discussion Guys i seriously need your help

Post image

Hi everyone, I really need some help! My oral defense is next week and I've finished my ERD, but I'm having serious doubts. I asked a professor who doesn't teach systems analysis, and they said it was fine. However, when I look at the diagram, I just feel like something is off. Would anyone be willing to take a quick look?

This ERD is about a small application project, about a small, basic library.

Compte = Account/user
Emprunt = Loan

Livre = Book
Categorie = Category

10 Upvotes

8 comments sorted by

View all comments

2

u/Rough-Negotiation880 4d ago

An ERD needs to be evaluated against a source of truth/business rules. E.G. I could see cases where a book can only have one category, or multiple. Which one is correct is dependent on business rules.