| | |
Can you help me pick out the remaning entity to finsish the ERD.
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jan 2009
Posts: 2
Reputation:
Solved Threads: 0
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.
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.
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
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
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
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
![]() |
Other Threads in the Database Design Forum
- Previous Thread: Need help in designing some tables
- Next Thread: Rookie after some advice
| Thread Tools | Search this Thread |






