How did you normalize the following relation? When the PK is (Room#, Reservation#). Name Phone email Room = Room Type Check Check Room rate Actual Room Rate Reservation Card Number Card Type Card Expiry Out Room Actual Room Rate Card Phone Room Type Check in Check Out Room Rate Reservation Card Card Type Expiry Bob Smh bsm th@y ahoo com 02-18-2019 905-506- 8767 99 111222333 121 King Standard 02-15-2019 35-4678 MC 1222 Jane Doe 129 416-565- 7340 jdoe@yan 205 00 com King Sute 02-15-2019 02-22-2019 119 128734 222333444 VISA 1120 416-555 8730 jchnson @gmalc 03-22-2019 0-27-2019 121 King Standard 90 984637 33344455 MC 1021 Johnson Bob Sm 905-565- 6767 bsmthay ahoo com 03-01-2019 03-02-2019 190328 125 King Standard 90 111222333 MC 1222 905-565- 9876 07-22-2019 868777686 mbiown@ 132 07-15-2019 120674 MISA 0922 Mary Brown King Standad 90 hotmal co 905-566- 9876 2 Queen Standard 07-22-2019 0922 133 07-15-2019 109 12674 888777666 VISA Mary Brown hotmal.co S19-565- 3214 jaoet@y 201 ahoo com 2 Queen Sute Jane Doe 04-01-2019 04-06-2019 135 135 372890 66655444 AMEX 0821 BHs 403-565- 8456 bharse gmal.com 920195 333222111 125 King Standard 01-12-2019 01-15-2019 MC 1120 Room Rate: The room rental price in general depends on its type. Actual room rate: actual price at which it is rented to the customer on a specific reservation.

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.11CP
icon
Related questions
Question
How did you normalize the following relation?
When the PK is (Room#, Reservation#).
Name Phone email Room = Room Type Check Check
Actual
Room Rate
Reservation Card
Number
Room
Card
Card
Type Expiry
In
Out
rate
Name
Phone
emal
Room
Room Type
Check in
Check Out
Room
Actual
Room Rate
Card
Reservation
Card
Card
Rate
Type
Expiry
Bob
Sm th
905-560-
8767
bsm th@y
ahoo com
121
02-15-2019
02-18-2019
99
89
354678
111222333
MC
1222
King
Standard
416-565-
7340
Jane Doe
jdoe@yah
205
King Suite
02-15-2019
02-22-2019
129
119
128734
222333444
VISA
11.20
00.com
JI
416-555-
johnson
egmalc
121
King
Standard
03-22-2019
03-27-2019
99
99
984637
333444555
MC
1021
Johnson
8730
bsmith@y
ahoo.com
Bob
905-565-
125
King
Standard
03-01-2019
03-02-2019
99
89
190328
111222333
MC
1222
Smith
8767
mbrowne
hotmail co
09.22
Mary
Brown
905-565-
9676
132
King
Standard
07-15-2019
07-22-2019
90
89
128674
888777666
VISA
Mary
Brown
2 Queen
Standard
VISA
905-565-
mbrowne
hotmal.co
133
07-15-2019
07-22-2019
109
99
128674
888777666
0922
9876
2 Queen
Sute
Jane Doe
519-565-
AMEX
jdoe6s@y
ahoo.com
201
04-01-2019
04-06-2019
135
135
372890
666555444
0821
3214
bharns@
gmal.com
Bi Harts
403-555-
125
01-15-2019
MC
1120
King
Standard
01-12-2019
99
920195
333222111
8456
Room Rate: The room rental price in general depends on its type.
Actual room rate: actual price at which it is rented to the customer on a specific
reservation.
Transcribed Image Text:How did you normalize the following relation? When the PK is (Room#, Reservation#). Name Phone email Room = Room Type Check Check Actual Room Rate Reservation Card Number Room Card Card Type Expiry In Out rate Name Phone emal Room Room Type Check in Check Out Room Actual Room Rate Card Reservation Card Card Rate Type Expiry Bob Sm th 905-560- 8767 bsm th@y ahoo com 121 02-15-2019 02-18-2019 99 89 354678 111222333 MC 1222 King Standard 416-565- 7340 Jane Doe jdoe@yah 205 King Suite 02-15-2019 02-22-2019 129 119 128734 222333444 VISA 11.20 00.com JI 416-555- johnson egmalc 121 King Standard 03-22-2019 03-27-2019 99 99 984637 333444555 MC 1021 Johnson 8730 bsmith@y ahoo.com Bob 905-565- 125 King Standard 03-01-2019 03-02-2019 99 89 190328 111222333 MC 1222 Smith 8767 mbrowne hotmail co 09.22 Mary Brown 905-565- 9676 132 King Standard 07-15-2019 07-22-2019 90 89 128674 888777666 VISA Mary Brown 2 Queen Standard VISA 905-565- mbrowne hotmal.co 133 07-15-2019 07-22-2019 109 99 128674 888777666 0922 9876 2 Queen Sute Jane Doe 519-565- AMEX jdoe6s@y ahoo.com 201 04-01-2019 04-06-2019 135 135 372890 666555444 0821 3214 bharns@ gmal.com Bi Harts 403-555- 125 01-15-2019 MC 1120 King Standard 01-12-2019 99 920195 333222111 8456 Room Rate: The room rental price in general depends on its type. Actual room rate: actual price at which it is rented to the customer on a specific reservation.
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning