Question: Using Crow's Notation, Design an Entity-Relationship diagram that models an Internet forum and considers the requirements listed below. That means that you have to identify

Using Crow's Notation,

Design an Entity-Relationship diagram that models an Internet forum and considers the requirements listed below. That means that you have to identify suitable entity sets, relationship sets, attributes, keys of entity sets (if not specified), and so on. Further, add the cardinalities (1:1, 1:m, m:1, m:n) to the relationship sets and write down your assumptions regarding the cardinalities if there could be a doubt.

Consider the following requirements:

-A user has an ID which is unique, a name, a nickname, an email address, a date of birth, an age, and a phone number. An age can be obtained in combination with the date of birth and the system date.

-A hometown where users were born has a city name and a state name. Multiple users can be associated with a hometown.

-There are two types of users: registered users and unregistered users.

-The SSN of a registered user is stored, but an unregistered user does not have it.

-A registered user creates a post. Each post belongs to one user and must have exactly one ID, title, and content, along with a date.

-Multiple posts can be associated with a registered user.

-A registered user leaves a comment about a post with the text and the date of the comment.

-A comment is associated with one post and one user. Each post can have multiple comments, and each user can comment on multiple posts.

-An unregistered user cannot create a post or leave a comment but can only read them (a registered user can also read).

-Both kind of users (registered and unregistered) can like a post. An ID for liking a post is stored when a user likes a post.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!