7. Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members,...

Need help creating the ERD .. DATABASE AND DESIGN

Extracted text: 7. Suppose you are given the following business rules to form the basis for a database design. The database must enable the manager of a company dinner club to mail invitations to the club's members, to plan the meals, to keep track of who attends the dinners, and so on. • Each dinner serves many members, and each member may attend many dinners. • A member receives many invitations, and each invitation is mailed to many members. • A dinner is based on a single entree, but an entree may be used as the basis for many dinners. For example, a dinner may be composed of a fish entree, rice, and corn, or the dinner may be composed of a fish entree, a baked potato, and string beans. Because the manager is not a database expert, the first attempt at creating the data- base uses the structure shown in Table P6.7. a. Given the table structure illustrated in Table P6.7, write the relational schema and draw its dependency diagram. Label all transitive and/or partial dependen- cies. (Hint: This structure uses a composite primary key.)


Extracted text: TABLE P6.7 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE 214 Alice B. VanderVoort 325 Meadow Park Murkywater MEMBER_NUM 214 235 Gerald M. Gallega 123 Rose Court Highlight MEMBER_NAME Alice B. VanderVoort MEMBER_ADDRESS 325 Meadow Park MEMBER_CITY Murkywater MEMBER_ZIPCODE 12345 12349 12345 INVITE_NUM INVITE_DATE ACCEPT_DATE DINNER_DATE 8 9 10 23-Feb-2018 27-Feb-2018 12-Mar-2018 23-Feb-2018 15-Mar-2018 27-Feb-2018 15-Mar-2018 17-Mar-2018 15-Mar-2018 DINNER_ATTENDED Yes Yes No DINNER_CODE DIS DI5 DI2 DINNER_DESCRIPTION Glowing Sea Delight EN3 ENTREE_DESCRIPTION Stuffed crab DE8 Glowing Sea Delight Ranch Superb ENS ENTREE_CODE EN3 Stuffed crab Marinated steak DESSERT_CODE DES DE2 DESSERT_DESCRIPTION Chocolate mousse with raspberry sauce Cheries jubilee Apple pie with honey crust