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.

I got about half of this (I think) but I've been rewatching lectures/rereading the textbook for hours and can't finish off. Thanks in advance.

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

Intelligent Information And Database Systems Third International Conference Achids 2011 Daegu Korea April 2011 Proceedings Part 2 Lnai 6592

Authors: Ngoc Thanh Nguyen ,Chong-Gun Kim ,Adam Janiak

2011th Edition

3642200419, 978-3642200410

More Books

Students also viewed these Databases questions

Question

2. (1 point) Given AABC, tan A b b

Answered: 1 week ago

Question

1. What are the pros and cons of diversity for an organisation?

Answered: 1 week ago

Question

1. Explain the concept of diversity and equality in the workplace.

Answered: 1 week ago