1. Explain why the data in the table is not in First Normal Form. 2. Explain why the data in the table is not in Third Normal Form. • For this question you cannot say "Because it's not in First (or Second) Normal Form". You need to explain why specifically it is not in Thir 3. Reorganize the attributes into Third Normal Form (create separate aggregates that conform to 3NF). Underline the candidate key for each aggregate, like this example from the Snotify case study: o Artist: {Artist ID, Stage Name, Last Name, Middle Name, First Name, Date of Birth} • Do not invent any new attributes when doing this.

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...
icon
Related questions
Question

Question 2 and 3 only  please and thank you so much

Guest House Paradiso
The Guest House Paradiso used to be a splendid place to stay. But things haven't been updated in a while. Including the way that room bookings are recorded. At the moment
they're recorded in a spreadsheet like this:
Bookings Table
Room
Number
Number of
Nights
Arrival Date
Departure Date
Guest Last Name
Guest Phone Number
Optional Extras
203
Mar 18 2022
Mar 20 2022
Howard
555-2381
bug-free bed
101
Mar 18 2022
Mar 21 2022
3
Gallagher
555-3619
clean towels, hot water
302
Mar 18 2022
Mar 19 2022
1
Mortimer
555-0856
bug-free bed, clean towels
103
Mar 18 2022
Mar 23 2022
5
McQueen
557-2428
hot water
...
203
Mar 20 2022
Mar 23 2022
3
Carraclough
554-8652
clean towels, hot water
Optional Extras
There are three types of 'Optional Extras' available in all rooms, and guests can order any combination of these:
• hot water
• bug-free bed
• clean towels
NOTE: For this scenario we will assume that a guest's phone number never changes and is unique.
Transcribed Image Text:Guest House Paradiso The Guest House Paradiso used to be a splendid place to stay. But things haven't been updated in a while. Including the way that room bookings are recorded. At the moment they're recorded in a spreadsheet like this: Bookings Table Room Number Number of Nights Arrival Date Departure Date Guest Last Name Guest Phone Number Optional Extras 203 Mar 18 2022 Mar 20 2022 Howard 555-2381 bug-free bed 101 Mar 18 2022 Mar 21 2022 3 Gallagher 555-3619 clean towels, hot water 302 Mar 18 2022 Mar 19 2022 1 Mortimer 555-0856 bug-free bed, clean towels 103 Mar 18 2022 Mar 23 2022 5 McQueen 557-2428 hot water ... 203 Mar 20 2022 Mar 23 2022 3 Carraclough 554-8652 clean towels, hot water Optional Extras There are three types of 'Optional Extras' available in all rooms, and guests can order any combination of these: • hot water • bug-free bed • clean towels NOTE: For this scenario we will assume that a guest's phone number never changes and is unique.
Questions
1. Explain why the data in the table is not in First Normal Form.
2. Explain why the data in the table is not in Third Normal Form.
• For this question you cannot say "Because it's not in First (or Second) Normal Form". You need to explain why specifically it is not in Third Normal Form.
3. Reorganize the attributes into Third Normal Form (create separate aggregates that conform to 3NF).
Underline the candidate key for each aggregate, like this example from the Snotify case study:
o Artist: {Artist ID, Stage Name, Last Name, Middle Name, First Name, Date of Birth}
• Do not invent any new attributes when doing this.
Transcribed Image Text:Questions 1. Explain why the data in the table is not in First Normal Form. 2. Explain why the data in the table is not in Third Normal Form. • For this question you cannot say "Because it's not in First (or Second) Normal Form". You need to explain why specifically it is not in Third Normal Form. 3. Reorganize the attributes into Third Normal Form (create separate aggregates that conform to 3NF). Underline the candidate key for each aggregate, like this example from the Snotify case study: o Artist: {Artist ID, Stage Name, Last Name, Middle Name, First Name, Date of Birth} • Do not invent any new attributes when doing this.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY