Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Make A Database In Historical Studies

Authors: Tiago Luis Gil

1st Edition

3030782409, 978-3030782405

More Books

Students also viewed these Databases questions

Question

Demonstrate three aspects of assessing group performance?

Answered: 1 week ago