Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started