Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi!! I need help with this question please. Please strictly follow the instructions. Note that it just asks for the ER model (no code). Just

Hi!! I need help with this question please. Please strictly follow the instructions. Note that it just asks for the ER model (no code). Just a correct and clean ER drawing will be sufficient.. image text in transcribed

For Part 1, you will draw an ER diagram modeling the data needed for the system. It should include entity sets (possibly including one or more weak entity sets) representing Person, Contentltem, and FriendGroup, as well as several relationship sets. Details of the data model: Each Person has a unique e-mail, a password, and a name, consisting of a first name and a last name Each content item has a unique item_ID, a date, and other pertinent data. For example depending on the nature of your content, you might want to include a location, consisting of latitude, longitude, and/or location name; data about the size and/or format of the item; etc. Each content item is posted by exactly one person. For Part 1, you can limit the content items to just photos, which should include a unique item_ID, a date, a file_path, and a name A FriendGroup has a name and a description. Different people may have FriendGroups with the same name (and description), but an individual user cannot have more than one FriendGroup with the same name. For example, Ann and Bob can each have FriendGroups named "family and they can even have the same description, but Ann cannot have two friend groups named "family Each FriendGroup is owned by exactly one person (the person who is defining a group of his/her friends). Each FriendGroup has one or more members, i.e. People who BelongTo the FriendGroup. For example Ann can create a FriendGroup called "family" with members Ann, Cathy, David, and Ellen (each of whom BelongsTo Ann's family FriendGroup) For Part 1, you will draw an ER diagram modeling the data needed for the system. It should include entity sets (possibly including one or more weak entity sets) representing Person, Contentltem, and FriendGroup, as well as several relationship sets. Details of the data model: Each Person has a unique e-mail, a password, and a name, consisting of a first name and a last name Each content item has a unique item_ID, a date, and other pertinent data. For example depending on the nature of your content, you might want to include a location, consisting of latitude, longitude, and/or location name; data about the size and/or format of the item; etc. Each content item is posted by exactly one person. For Part 1, you can limit the content items to just photos, which should include a unique item_ID, a date, a file_path, and a name A FriendGroup has a name and a description. Different people may have FriendGroups with the same name (and description), but an individual user cannot have more than one FriendGroup with the same name. For example, Ann and Bob can each have FriendGroups named "family and they can even have the same description, but Ann cannot have two friend groups named "family Each FriendGroup is owned by exactly one person (the person who is defining a group of his/her friends). Each FriendGroup has one or more members, i.e. People who BelongTo the FriendGroup. For example Ann can create a FriendGroup called "family" with members Ann, Cathy, David, and Ellen (each of whom BelongsTo Ann's family FriendGroup)

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

Sams Teach Yourself Beginning Databases In 24 Hours

Authors: Ryan Stephens, Ron Plew

1st Edition

067232492X, 978-0672324925

More Books

Students also viewed these Databases questions

Question

How flying airoplane?

Answered: 1 week ago

Question

1. What are the marketing implications of this situation?

Answered: 1 week ago