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-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 |
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 |
a) The table is in first normal form, as it contains atomic values, and no row has more than one value.
b) To break it down to second normal form we need to check for functional dependencies. Let's make a different table for dinner code and description.
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-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 |
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 |
MEMBER_NUM |
214 |
214 |
235 |
DINNER_CODE |
DI5 |
DI2 |
DI5 |
DINNER_DESCRIPTION |
Glowing Sea Delight |
Ranch Superb | Glowing Sea Delight |
3 normal form
Attribute Name |
Sample Value |
Sample Value |
Sample Value |
MEMBER_NUM |
214 |
235 |
214 |
MEMBER_NAME |
Alice B. VanderVoort |
Gerald M. Gallega |
Alice B. VanderVoort |
INVITE_NUM |
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 |
DINNER_ATTENDED |
Yes |
Yes |
No |
MEMBER_NUM |
214 |
235 |
MEMBER_ADDRESS |
325 Meadow Park |
123 Rose Court |
MEMBER_CITY |
Murkywater |
Highlight |
MEMBER_ZIPCODE |
12345 |
12349 |
MEMBER_NUM |
214 |
214 |
235 |
DINNER_CODE |
DI5 |
DI2 |
DI5 |
DINNER_DESCRIPTION |
Glowing Sea Delight |
Ranch Superb | Glowing Sea Delight |
MEMBER_NUM |
214 |
214 |
235 |
ENTREE_CODE |
EN3 |
EN5 |
EN3 |
ENTREE_DESCRIPTION |
Stuffed crab |
Marinated steak |
Stuffed crab |
MEMBER_NUM |
214 |
214 |
235 |
DESERT_CODE |
DE8 |
DE2 |
DE5 |
DESERT_DESCRIPTION |
Chocolate mousse with raspberry sauce |
Apple pie with honey crust |
Cherries Jubilee |
Attribute Name Sample Value Sample Value Sample Value MEMBER_NUM 214 235 214 MEMBER_NAME Alice B. VanderVoort...
PROBLEM STATEMENT: Suppose you have a client that has given you 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...