CODEWITHSUNDEEP
databaseentity-relationship
JamieITGirl
JamieITGirl

Reputation: 191

E-R entity design for a web application

for exercise, I have to design a web application with online forums. Each forum refers to a specific category of sport and a specific course, e.g. soccer forum of informatic. Each user can submit a post in a forum, this post has a text, a photo and a date.
I've designed the forum like an entity with only one attribute, the category (of sport), and the post like another entity, linked by a "part of" relationship with Forum.
The Forum is linked by a relationship with the entity Course.
Do you think this is the best solution?
Thanks.
Here's an image of my elaboration:
model

Upvotes: 1

Views: 381

Answers (1)

gymni f
gymni f

Reputation: 408

Each user can submit a post in a forum, this post has a text, a photo and a date.

So I would add the entity "user" which would have a relation with post (users submits posts) and then I would put a relation between "user" and "forum" because the user that is subscribed to the forum writes posts. Because of this, I would cancel the relation between "forum" and "post". In addtion a forum belongs only to a course I think. However consider that this is my own solution and an E/R model can be done in many ways. This is my solution:

enter image description here

Upvotes: 1

Related Questions