DATABASE AND DESIGN - need help creating the ERD using this question and information attached TABLE P6.7ATTRIBUTE NAMESAMPLE VALUESAMPLE VALUESAMPLE VALUE214Alice B. VanderVoort325 Meadow ParkMurkywaterMEMBER_NUM214235Gerald M. Gallega123 Rose CourtHighlightMEMBER_NAMEAlice B. VanderVoortMEMBER_ADDRESS325 Meadow ParkMEMBER_CITYMurkywaterMEMBER_ZIPCODE123451234912345INVITE_NUMINVITE_DATEACCEPT_DATEDINNER_DATE891023-Feb-201827-Feb-201812-Mar-201823-Feb-201815-Mar-201827-Feb-201815-Mar-201817-Mar-201815-Mar-2018DINNER_ATTENDEDYesYesNoDINNER_CODEDISDI5DI2DINNER_DESCRIPTION Glowing Sea DelightEN3ENTREE_DESCRIPTION Stuffed crabDE8Glowing Sea Delight Ranch SuperbENSENTREE_CODEEN3Stuffed crabMarinated steakDESSERT_CODEDESDE2DESSERT_DESCRIPTION Chocolate mousse with raspberry sauce Cheries jubileeApple pie with honey crust 7. Suppose you are given the following business rules to form the basis for a databasedesign. The database must enable the manager of a company dinner club to mailinvitations to the club's members, to plan the meals, to keep track of who attends thedinners, 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 manymembers.• A dinner is based on a single entree, but an entree may be used as the basis for manydinners. For example, a dinner may be composed of a fish entree, rice, and corn, orthe 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 schemaand draw its dependency diagram. Label all transitive and/or partial dependen-cies. (Hint: This structure uses a composite primary key.)

The relational schema may be written as follows:MEMBER(MEMBER_NUM, MEMBER_NAME, MEMBER_ADDRESS,…

TABLE P6.7 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE MEMBER NUM MEMBER_NAME 214 Alice B. VanderVoort 325 Meadow Park Murkywater 235 Gerald M. Gallega 123 Rose Court Highlight 214 Alice B. VanderVoort 325 Meadow Park Murkywater MEMBER_ADDRESS MEMBER_CITY MEMBER_ZIPCODE INVITE_NUM 12345 12349 12345 8 9. 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 Yes DINNER_ATTENDED DINNER_CODE Yes No DIS Glowing Sea Delight Ranch Superb EN3 Stuffed crab DIS DI2 DINNER DESCRIPTION Glowing Sea Delight ENTREE_CODE ENTREE_DESCRIPTION Stuffed crab DESSERT_CODE DESSERT_DESCRIPTION Chocolate mousse with raspberry sauce Cherries jubilee EN3 EN5 Marinated steak DE2 Apple pie with honey crust DE8 DES

TABLE P6.7 ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE MEMBER NUM MEMBER_NAME 214 Alice B. VanderVoort 325 Meadow Park Murkywater 235 Gerald M. Gallega 123 Rose Court Highlight 214 Alice B. VanderVoort 325 Meadow Park Murkywater MEMBER_ADDRESS MEMBER_CITY MEMBER_ZIPCODE INVITE_NUM 12345 12349 12345 8 9. 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 Yes DINNER_ATTENDED DINNER_CODE Yes No DIS Glowing Sea Delight Ranch Superb EN3 Stuffed crab DIS DI2 DINNER DESCRIPTION Glowing Sea Delight ENTREE_CODE ENTREE_DESCRIPTION Stuffed crab DESSERT_CODE DESSERT_DESCRIPTION Chocolate mousse with raspberry sauce Cherries jubilee EN3 EN5 Marinated steak DE2 Apple pie with honey crust DE8 DES

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Explain the concept of database sharding. What are the advantages and challenges of using sharding to distribute data in a database system?
Database Design the database following an ER model- The ER should contain all necessary information such as entities, attributes, relationships, cardinalities etc. for this example (as shown in the picture) and do changes if necessary
Explain the concept of data replication in a database cluster and its role in ensuring data availability.
It is the responsibility of the_____, a person or group, in a company to manage the database.
When working with UNIX, the method of interprocess communication that is the quickest is
Explain the concept of database sharding and its role in achieving horizontal scalability. Provide an example of how sharding can be implemented in a distributed database system.
Explain how an organization makes use of databases in its information systems, using any particular organization as an example if possible.
Reasons to have a separate data warehouse database versus having a single database supporting both OLTP and OLAP applications include (select all valid reasons) to easily join across data from multiple operational database, it may be necessary to first reformat and "clean up" the operational data. OLAP database have a much shorter time horizon compared to OLTP databases OLAP queries are best done using a query language that is not relational but based on cubes. the OLAP database has a different structure to make it more suitable for analysis to avoid OLAP and OLTP workloads from competing for the same computer resources
Explain the concept of data warehousing and how it differs from a traditional database. Provide use cases where data warehousing is more suitable.
Explain the impact of "data redundancy" on the efficiency of a database.
Explain the concept of complex data types in the context of database management systems. Provide examples of commonly used complex data types.
The role of the database administrator in the Information Systems audit department