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.A member may attend many dinners, and each dinner may be attended by many members. Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in Table I: Table I Sample RESERVATION RecordsAttribute NameSample ValueSample ValueSample ValueMEMBER_NUM214235214MEMBER_NAMEAlice B. VanderVoortGerald M. GallegaAlice B. VanderVoortMEMBER_ADDRESS325 Meadow Park123 Rose Court325 Meadow ParkMEMBER_CITYMurkywaterHighlightMurkywaterMEMBER_ZIPCODE123451234912345INVITE_NUM8910INVITE_DATE23-Feb-201012-Mar-201023-Feb-2010ACCEPT_DATE27-Feb-201015-Mar-201027-Feb-2010DINNER_DATE15-Mar-201017-Mar-201015-Mar-2010DINNER_ATTENDEDYesYesNoDINNER_CODEDI5DI5DI2DINNER_DESCRIPTIONGlowing sea delightGlowing sea delightRanch SuperbENTREE_CODEEN3EN3EN5ENTREE_DESCRIPTIONStuffed crabStuffed crabMarinated steakDESERT_CODEDE8DE5DE2DESERT_DESCRIPTIONChocolate moussewith raspberry sauceCherries jubileeApple pie with honeycrust Given the table structure illustrated in Table I, draw its dependency diagram. Label all transitive and/or partial dependencies. Justify each partial or transitive dependency (Hint: This structure uses a composite primary key.) Break up the dependency diagram you drew in Problem 7a to produce dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes, that the naming conventions are met, and so on.) Using the results of Problem b, draw the Crow’s Foot ERD. You can hand draw it if you do not have the required software. MEMBER_ZIPCODE123451234912345INVITE_NUM10INVITE_DATE23-Feb-201012-Mar-201023-Feb-2010ACCEPT DATE27-Feb-201015-Mar-201027-Feb-2010DINNER_DATE15-Mar-201017-Mar-201015-Mar-2010DINNER_ATTENDEDYesYesNoDINNER_CODEDISDISDI2DINNER_DESCRIPTIONGlowing sea delightGlowing sea delightRanch SuperbENTREE_CODEEN3EN3ENSENTREE_DESCRIPTIONStuffed crabStuffed crabMarinated steakDESERT_CODEDEBDESDE2DESERT_DESCRIPTIONChocolate mousseCherries jubileeApple pie with honeywith raspberry saucecrusta. Given the table structure illustrated in Table I, draw its dependency diagram. Label all transitiveand/or partial dependencies. Justify each partial or transitive dependency (Hint: This structureuses a composite primary key.)b. Break up the dependency diagram you drew in Problem 7a to produce dependency diagramsthat are in 3NF. (Hint: You might have to create a few new attributes. Also, make sure that thenew dependency diagrams contain attributes that meet proper design criteria; that is, makesure that there are no multivalued attributes, that the naming conventions are met, and so on.)c. Using the results of Problem b, draw the Crow's Foot ERD. You can hand draw it if you do nothave the required software. 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 tothe club's members, to plan the meals, to keep track of who attends the dinners, and soon.• 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 becomposed of a fish entree, a baked potato, and string beans.• A member may attend many dinners, and each dinner may be attended by many members.Because the manager is not a database expert, the first attempt at creating the database uses thestructure shown in Table I:Table I Sample RESERVATION RecordsAttribute NameSample ValueSample ValueSample ValueMEMBER_NUM214235214MEMBER_NAMEAlice B. VanderVoortGerald M. GallegaAlice B. VanderVoortww.awMEMBER_ADDRESS325 Meadow Park123 Rose Court325 Meadow ParkMEMBER_CITYMurkywaterHighlightMurkywaterPage 1 of 2

a)Given the table structure illustrated in Table I, draw its dependency diagram. Label all…

Answered: Suppose you are given the following…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

100%

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.
A member may attend many dinners, and each dinner may be attended by many members.

Because the manager is not a database expert, the first attempt at creating the database uses the structure shown in Table I:

Table I Sample RESERVATION Records

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	9	10
INVITE_DATE	23-Feb-2010	12-Mar-2010	23-Feb-2010
ACCEPT_DATE	27-Feb-2010	15-Mar-2010	27-Feb-2010
DINNER_DATE	15-Mar-2010	17-Mar-2010	15-Mar-2010
DINNER_ATTENDED	Yes	Yes	No
DINNER_CODE	DI5	DI5	DI2
DINNER_DESCRIPTION	Glowing sea delight	Glowing sea delight	Ranch Superb
ENTREE_CODE	EN3	EN3	EN5
ENTREE_DESCRIPTION	Stuffed crab	Stuffed crab	Marinated steak
DESERT_CODE	DE8	DE5	DE2
DESERT_DESCRIPTION	Chocolate mousse with raspberry sauce	Cherries jubilee	Apple pie with honey crust

Given the table structure illustrated in Table I, draw its dependency diagram. Label all transitive and/or partial dependencies. Justify each partial or transitive dependency (Hint: This structure uses a composite primary key.)
Break up the dependency diagram you drew in Problem 7a to produce dependency diagrams that are in 3NF. (Hint: You might have to create a few new attributes. Also, make sure that the new dependency diagrams contain attributes that meet proper design criteria; that is, make sure that there are no multivalued attributes, that the naming conventions are met, and so on.)
Using the results of Problem b, draw the Crow’s Foot ERD. You can hand draw it if you do not have the required software.

MEMBER_ZIPCODE
12345
12349
12345
INVITE_NUM
10
INVITE_DATE
23-Feb-2010
12-Mar-2010
23-Feb-2010
ACCEPT DATE
27-Feb-2010
15-Mar-2010
27-Feb-2010
DINNER_DATE
15-Mar-2010
17-Mar-2010
15-Mar-2010
DINNER_ATTENDED
Yes
Yes
No
DINNER_CODE
DIS
DIS
DI2
DINNER_DESCRIPTION
Glowing sea delight
Glowing sea delight
Ranch Superb
ENTREE_CODE
EN3
EN3
ENS
ENTREE_DESCRIPTION
Stuffed crab
Stuffed crab
Marinated steak
DESERT_CODE
DEB
DES
DE2
DESERT_DESCRIPTION
Chocolate mousse
Cherries jubilee
Apple pie with honey
with raspberry sauce
crust
a. Given the table structure illustrated in Table I, draw its dependency diagram. Label all transitive
and/or partial dependencies. Justify each partial or transitive dependency (Hint: This structure
uses a composite primary key.)
b. Break up the dependency diagram you drew in Problem 7a to produce dependency diagrams
that are in 3NF. (Hint: You might have to create a few new attributes. Also, make sure that the
new dependency diagrams contain attributes that meet proper design criteria; that is, make
sure that there are no multivalued attributes, that the naming conventions are met, and so on.)
c. Using the results of Problem b, draw the Crow's Foot ERD. You can hand draw it if you do not
have the required software.

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.
• A member may attend many dinners, and each dinner may be attended by many members.
Because the manager is not a database expert, the first attempt at creating the database uses the
structure shown in Table I:
Table I Sample RESERVATION Records
Attribute Name
Sample Value
Sample Value
Sample Value
MEMBER_NUM
214
235
214
MEMBER_NAME
Alice B. VanderVoort
Gerald M. Gallega
Alice B. VanderVoort
ww.aw
MEMBER_ADDRESS
325 Meadow Park
123 Rose Court
325 Meadow Park
MEMBER_CITY
Murkywater
Highlight
Murkywater
Page 1 of 2

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 3 images

SEE SOLUTION Check out a sample Q&A here