Need to create ERD database ans design for 7 and 8 TABLE P6.7 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE MEMBER_NUM 214 235 214 MEMBER NAME Alice B. VanderVoort Gerald M. Gallega Alice B. VanderVoort MEMBER ADDRESS 325 Meadow Park 123 Rose Court 325 Meadow Park MEMBER CITY Murkywater Highlight Murkywater MEMBER ZIPCODE 12345 12349 12345 INVITE NUM 8 10 INVITE DATE 23-Feb-2018 12-Mar-2018 23-Feb-2018 ACCEPT DATE 27-Feb-2018 15-Mar-2018 27-Feb-2018 DINNER DATE 15-Mar-2018 17-Mar-2018 15-Mar-2018 DINNER ATTENDED Yes Yes No DINNER CODE DIS DIS DI2 Glowing Sea Delight Ranch Superb EN3 Stuffed crab DINNER DESCRIPTION Glowing Sea Delight ENTREE CODE EN3 ENS ENTREE DESCRIPTION Stuffed crab Marinated steak DESSERT CODE DE8 DES DE2 DESSERT DESCRIPTION Chocolate mousse with raspberry sauce Cherries jubilee Apple pie with honey crust 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.) b. Break up the dependency diagram you drew in Problem 7a to produce depen- dency diagrams that are in 3NF, and write the relational schema. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency dia- grams contain attributes that meet proper design criteria; that is, make sure there are no multivalued attributes, that the naming conventions are met, and so on.) c. Using the results of Problem 7b, draw the Crow's Foot ERD. 3. Use the dependency diagram shown in Figure P6.8 to work the following problems. a. Break up the dependency diagram shown in Figure P6.8 to create two new depen- dency diagrams: one in 3NF and one in 2NE. b. Modify the dependency diagrams you created in Problem 8a to produce a set of dependency diagrams that are in 3NE (Hint: One of your dependency diagrams should be in 3NF but not in BCNE) c. Modify the dependency diagrams you created in Problem 8b to produce a collec- tion of dependency diagrams that are in 3NF and BCNE