DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Database Design (http://www.daniweb.com/forums/forum142.html)
-   -   Can you help me pick out the remaning entity to finsish the ERD. (http://www.daniweb.com/forums/thread169599.html)

birch39 Jan 19th, 2009 9:47 pm
Can you help me pick out the remaning entity to finsish the ERD.
 
I got referee and project as two of my tables need help finding other based on this and know what kind of relationship it is and what the assumptions are.

Leeds Met students and staff have the opportunity to volunteer on community and conservation projects at home and abroad. Projects will incorporate a variety of activities and tasks. Overseas projects will mainly take place in the summer vacation although there will be trips running at other times during the year. Overseas project length will range from one to four weeks, while home projects could be one semester or a whole year.

We need a database system that will hold the information regarding project specific information about the teams of volunteers who go on the overseas volunteering trips including medical information, flight information, next of kin, project specific information about mentors and mentees.

We also need to be able to hold contact information on the community groups and charities that we work with. And the information from our community partners about volunteering opportunities so that we can then promote these opportunities through a mailing list for members interested in voluntary work here at home.

Ramy Mahrous Jan 21st, 2009 9:43 am
Re: Can you help me pick out the remaning entity to finsish the ERD.
 
So, show us your ERD I am bit lost in the description.

birch39 Jan 21st, 2009 1:01 pm
Re: Can you help me pick out the remaning entity to finsish the ERD.
 
1 Attachment(s)
Here is my ERD

Attachment 8925

Ramy Mahrous Jan 25th, 2009 10:16 am
Re: Can you help me pick out the remaning entity to finsish the ERD.
 
I think your ERD fulfills your requirements but it's not clear, if you work with team to develop this application try to brainstorm the design of ERD


All times are GMT -4. The time now is 5:28 am.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC