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.
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...
Related questions
Question
Question 2 and 3 only please and thank you so much
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.
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
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
Recommended textbooks for you
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
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 Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
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
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY