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.
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.
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.11CP
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps
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
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage