Reference no: EM133398573
Assignment:
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 make 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.
|
Components of a database application are you likely to need
: Which of the following components of a database application are you likely to need: data entry forms, reports, queries, or application program?
|
|
Examine a business continuity plan
: Senior management at Health Network has decided they want a business impact analysis (BIA) that examines the company's data center.
|
|
What restrictions and policies should employers institute
: What restrictions and policies should employers institute, and why? Are their risks to employees with BYOD in the workplace, if so what?
|
|
Create a plot of the residuals versus the fitted values
: In addition, create a plot of the residuals versus the fitted values. What does this plot tell you about the reasonableness of using a linear model here?
|
|
Identify suitable entity sets
: That means that you have to identify suitable entity sets, relationship sets, attributes, keys of entity sets (if not specified), and so on.
|
|
Should we have to certain aspects of others private lives
: How much access should we have to certain aspects of others' private lives? For example, should States share criminal databases?
|
|
Develop a dashboard used by general manager at a large
: Develop a dashboard that could be used by the general manager at a large, full-service health club to track the current state of operations.
|
|
Why was this a false sense of complacency
: The Mexican-American Generation achieved a sense of "psychic security." What is meant by this and why was this a false sense of complacency?
|
|
How would you make linux accessible by others
: Even with all the advancements with Linux its still not very well know with a the majority of the average user. That is where you come in.
|