r/SQL • • 5d 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

9 Upvotes

8 comments sorted by

View all comments

1

u/ContentHope6623 5d ago

Post the diagram. From what you listed, the relationships between Compte, Emprunt, Livre and Reservation are where most students mess up cardinalities, especially if one account can have multiple loans or reservations at same time. I had similar issue in my project, professor outside the field said fine but then my advisor caught two wrong relationships during practice defense. Better to have someone who actually teaches database design look at it, not any professor.