10 likes | 117 Views
Progressive Dinner Diagram. Participants Name Address City State Zip Telephone Contribution Appetizer Destination Main Course Destination Dessert Destination. Appetizer Sites Name Telephone # Max. # of people. Main Course Sites Name Telephone# Max. # of people. Dessert Sites
E N D
Progressive Dinner Diagram Participants Name Address City State Zip Telephone Contribution Appetizer Destination Main Course Destination Dessert Destination Appetizer Sites Name Telephone # Max. # of people Main Course Sites Name Telephone# Max. # of people Dessert Sites Name Telephone # Max. # of people This ER Diagram shows the relationships that exist in a Progressive Dinner I plan every February for my church. Over a hundred people participate and enjoy appetizers at about three homes, then progress to the main course, which is hosted at approximately 6-8 homes. Everyone then meets at the church fellowship hall for dessert together. (I’ve built the database such that dessert can happen in many homes as well, in case we decide to go that route in the future.) Each couple that participates is expected to bring a contribution of either an appetizer, bread/salad, or a dessert. This shows a database that holds much of the information I need when assigning people to the various homes for their meal. It would be a helpful tool for answering people’s questions about where they are going and what they are bringing to the meal.