Answered step by step
Verified Expert Solution
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..
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
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