Database Answers Sometimes we are happy and sometimes we are sad

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
My Simple Life
Back to the Data Model
Here is the Statement of User Requirements
Well, I am working an a social networking website that will have a calendaring function in it 
as well as online event invitation creation.

I would like a comprehensive and granular data model that articulates and displays the 
interconnectedness of a user's the social network, a user's calendar (showing events he has created, 
been invited to, is notified of), and a user's events (your birthday, when my next Econ 101 class is) 
within the calendar as well as media (video and photo) albums a user might create in addition to the 
online invitation.

So, users will be able to create events (or a set/layer of events) in the calendar:

eg Mom's Birthday
A one-time event on XYZ, starting at X, ending at Y, at John Doe's house, 20 invitees, the event page, 
their comments and uploads to Mom's Birthday album

or
A 2009 Pay Day Schedule for Acme Corporation

Consists of 13x yearly time event, every X, no starting time, no ending time, it just occurs, 
no location, 
no invitee, 
no event page, 
no comments or uploads.


If you and I are connected on this social network, you would be notified of the event creation and 
responses to the event, "John Doe created Mom's Birthday Event and 17 people have RSVP-ed"

or you could also create a layer/set of events (Acme Pay Day schedule) to share (or not) with your connections.

Does this help? 

Apologies for being nebulous before.   

Thanks in advance for your time.

APV

From these Requirements we can identify the 'Things of Interest' as :-
1. Calendar
2. Contacts (friends, relatives, and so on)
3. Events
4. Organisations


Barry Williams
31st. December 2008
Principal Consultant
Database Answers

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map