Can you help me pick out the remaning entity to finsish the ERD.

Reply

Join Date: Jan 2009
Posts: 2
Reputation: birch39 is an unknown quantity at this point 
Solved Threads: 0
birch39 birch39 is offline Offline
Newbie Poster

Can you help me pick out the remaning entity to finsish the ERD.

 
0
  #1
Jan 19th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Can you help me pick out the remaning entity to finsish the ERD.

 
0
  #2
Jan 21st, 2009
So, show us your ERD I am bit lost in the description.
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Join Date: Jan 2009
Posts: 2
Reputation: birch39 is an unknown quantity at this point 
Solved Threads: 0
birch39 birch39 is offline Offline
Newbie Poster

Re: Can you help me pick out the remaning entity to finsish the ERD.

 
0
  #3
Jan 21st, 2009
Here is my ERD

ERD.doc
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Can you help me pick out the remaning entity to finsish the ERD.

 
0
  #4
Jan 25th, 2009
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
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC