Question: 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.. Hi!! I need help with this question please. Please strictly follow the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!