Sample Value 214 Sample Value 235 Sample Value 214 Attribute Name MEMBER NUM MEMBER NAME Alice B. VanderVoort Gerald M. Gallega Alice B. VanderVoort MEMBER ADDRESS 325 Meadow Park 123 Rose Court 325 Meadow Park Murkywater 12345 Murkywater 12345 MEMBER CITY Highlight 12349 MEMBER ZIPCODE INVITE NUM 8 9 10 INVITE DATE 23-Feb-2006 12-Mar-2006 23-Feb-2006 ACCEPT DATE 27-Feb-2006 15-Mar-2006 27-Feb-2006 DINNER DATE 15-Mar-2006 17-Mar-3006 15-Mar-2006 DINNER ATTENDED Yes Yes No DINNER CODE DI5 DI5 DI2 Glowing Sea Delight EN3 Glowing Sea Delight Ranch Superb DINNER DESCRIPTION ENTREE CODE EN3 EN5 ENTREE DESCRIPTION Stuffed crab Stuffed crab Marinated steak DESERT CODE DE8 DE5 DE2 DESERT DESCRIPTION Chocolate mousse Cherries Jubilee Apple pie with honey with raspberry sauce crust
Sample Value 214 Sample Value 235 Sample Value 214 Attribute Name MEMBER NUM MEMBER NAME Alice B. VanderVoort Gerald M. Gallega Alice B. VanderVoort MEMBER ADDRESS 325 Meadow Park 123 Rose Court 325 Meadow Park Murkywater 12345 Murkywater 12345 MEMBER CITY Highlight 12349 MEMBER ZIPCODE INVITE NUM 8 9 10 INVITE DATE 23-Feb-2006 12-Mar-2006 23-Feb-2006 ACCEPT DATE 27-Feb-2006 15-Mar-2006 27-Feb-2006 DINNER DATE 15-Mar-2006 17-Mar-3006 15-Mar-2006 DINNER ATTENDED Yes Yes No DINNER CODE DI5 DI5 DI2 Glowing Sea Delight EN3 Glowing Sea Delight Ranch Superb DINNER DESCRIPTION ENTREE CODE EN3 EN5 ENTREE DESCRIPTION Stuffed crab Stuffed crab Marinated steak DESERT CODE DE8 DE5 DE2 DESERT DESCRIPTION Chocolate mousse Cherries Jubilee Apple pie with honey with raspberry sauce crust
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
Related questions
Question
1. Break the table down to 1NF, 2NF anf 3NF.
![Sample Value
214
Sample Value
235
Sample Value
214
Attribute Name
MEMBER NUM
MEMBER NAME
Alice B. VanderVoort
Gerald M. Gallega
Alice B. VanderVoort
MEMBER ADDRESS
325 Meadow Park
123 Rose Court
325 Meadow Park
Murkywater
12345
Highlight
12349
MEMBER CITY
Murkywater
12345
MEMBER ZIPCODE
INVITE NUM
8.
9.
12-Mar-2006
10
INVITE DATE
23-Feb-2006
23-Feb-2006
ACCEPT DATE
27-Feb-2006
15-Mar-2006
27-Feb-2006
DINNER DATE
15-Mar-2006
17-Mar-3006
15-Mar-2006
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
Apple pie with honey
DESERT DESCRIPTION
Chocolate mousse
Cherries Jubilee
with raspberry sauce
crust](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F11a240f3-b04e-4e3e-845d-5d80d7b66ae6%2Fc400adcf-f4d3-435b-80a4-acebbb6c9736%2F5vkurp_processed.png&w=3840&q=75)
Transcribed Image Text:Sample Value
214
Sample Value
235
Sample Value
214
Attribute Name
MEMBER NUM
MEMBER NAME
Alice B. VanderVoort
Gerald M. Gallega
Alice B. VanderVoort
MEMBER ADDRESS
325 Meadow Park
123 Rose Court
325 Meadow Park
Murkywater
12345
Highlight
12349
MEMBER CITY
Murkywater
12345
MEMBER ZIPCODE
INVITE NUM
8.
9.
12-Mar-2006
10
INVITE DATE
23-Feb-2006
23-Feb-2006
ACCEPT DATE
27-Feb-2006
15-Mar-2006
27-Feb-2006
DINNER DATE
15-Mar-2006
17-Mar-3006
15-Mar-2006
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
Apple pie with honey
DESERT DESCRIPTION
Chocolate mousse
Cherries Jubilee
with raspberry sauce
crust
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Systems Architecture](https://www.bartleby.com/isbn_cover_images/9781305080195/9781305080195_smallCoverImage.gif)
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage