Draw and submit an ER data model for the given scenario.

People

for every person associated with the site, we need to know at least their email address and their name

we'll keep their given names and family names separate so that we can sort lists of people by their family name

everyone must have at least one given name, but some people may have no family name (e.g. "Prince")

Users

users are people who can log in to the site and organise events

each user needs to be registered with the system and must provide an email address and a password

their email and password are used for authentication when they log in to the system

once logged in, they can modify information related to themselves via their "Account" page

users may provide additional information about themselves, including a phone number, their personal website, and their birthday

they can also provide a name that's shown on the ev.org website, instead of just their user- and family-names

in addition, they may want to provide a home address (a location)

users can also create contact lists, which are essentially just named groups of people (note that the people in a contact list are not necessarily users)

Events

events happen at a certain place at a certain time

people may attend an event if they register for the event

events may be public or private - if public, anyone may attend by registering with their email address - if private, only people who are invited may attend

so that people can decide whether or not to attend an event, the event organiser should provide at least the following information: - a title and description of the event - starting date, starting time, ending date (generally the same as starting date), ending time, - location of the event (a place) organisers may also specify a set of categories for the event (e.g. festival, concert, lecture, party, food/wine, music, etc.) to help users who are searching for events

events may be one-off or they may be repeated at various intervals (daily, weekly, monthly) - repeated events run from start-time until end-time on every day they occur - for daily events, the event runs every day from start-date until end-date - for weekly events, the event runs every 7 days from start-date until end-date - for monthly events, the event runs every 4 weeks from start-date until end-date

a one-off event may span multiple days (e.g. a music festival)

Places

places have a name and address

the address should include: street, city, state, country and postal code

places may also have GPS coordinates (a la Google maps)

Contacts and Invitees Lists

a user can create a contact list (named list of people)

an event can have a list of people who are invited to the event

contact lists can be used to specify invitees to an event (but invitees lists are always a list of people; any contact list would be expanded to generate the invitees list)

we need to record whether an invitee has RSVP'd to attend the event