Question: Create an Entity-Relationship Diagram representing the logical data model for the following scenario. It should include all entities, attributes, relationships and keys. Below your ERD, LIST ANY PATTERNS YOU USED IN CREATING THE ERD.
Scenario:
A cooking club organizes several dinners for its members. The purpose of the club is to allow several members to get together and prepare a dinner for the other members. The club president maintains a database that plans each meal and tracks which members attends each dinner, and also keeps track of which members creates each dinner.
Each dinner serves many members and any member is allowed to attend. Each dinner has an invitation. This invitation is mailed to each member. The invitation includes the date of the dinner and location.
Each dinner is based on a single entrée and a single dessert. This entrée and dessert can be used again for other dinners.
Prepare an Entity-Relationship Diagram show the logical data model for the given scenario.