Search code examples
databaseentity-relationship

Drawing entity relationship diagrams -ERD

I need to draw entity relationship diagrams for https://askubuntu.com/. but I can't see entities and entities set. is there anyone who can help?

I need basic RDBM for askubuntu pls ?

Solution

  • A quick look at that website will tell me that it would have the following tables:

    Questions
QuestionTags
Tags
Answers
QuestionViews
Users

    Question Table

    QuestionId
QuestionText

    Tags Table

    TagId
TagName

    QuestionTags Table Note: This table will have a relationship to the Questions and Tags table.

    QuestionTagsId
QuestionId
TagId

    Answers Table

    AnswerId
QuestionId
UserId
AnswerDate

    Users Table

    UserId
UserName

    QuestionViews Table

    QuestionViewId
ViewDate

    Generally, this is a very basic database table definition to contain the information for the website you provided. You would need to define the proper relationships, column types and other constraints.

    I provided this to provide you some headstart on where to look for next.

    Good luck.