Normalize Table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State the action taken upon the table(s) for each Normal Form. For the INF in this case, only identify the Primary Key and keep the 1NF result in a single table. Then, split into new table(s) starting from 2NF onwards. a) Also, consider the following assumptions: One ReservelD can have multiple venues' booking. - One venue can only be booked once for the same ReservelD on the same ReserveDate ReservelD ReserveDate StartTime EndTime VenuelD VenueTag |10:00 13:00 VenueSize FeePerHour Purpose |150 210101-01 3-Jan-21 210101-02 3-Jan-21 210101-02 3-Jan-21 210101-02 3-Jan-21 15:00 20:00 Hibiscus |Lily Discussion v10 Small V22 Medium 260 Forum 13:00 20:00 V20 Petal Medium 260 Meeting 17:00 21:00 V10 Small Talk Hibiscus Hibiscus Muller 150 210101-02 4-Jan-21 210101-03 6-Jan-21 210101-03 6-Jan-21 210101-04 7-Jan-21 09:00 11:00 V10 Small 150 Post-eva Meeting 09:00 09:00 |16:00 |12:00 |17:00 Table 1: Details of ReserveVenue Table Large Morning Glory Small Small Appreciation Day Brain Storming Briefing V30 320 V11 150 14:00 V10 Hibiscus 150 (Hint: The hourly usage fee is charged based on size of the venue)
Normalize Table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State the action taken upon the table(s) for each Normal Form. For the INF in this case, only identify the Primary Key and keep the 1NF result in a single table. Then, split into new table(s) starting from 2NF onwards. a) Also, consider the following assumptions: One ReservelD can have multiple venues' booking. - One venue can only be booked once for the same ReservelD on the same ReserveDate ReservelD ReserveDate StartTime EndTime VenuelD VenueTag |10:00 13:00 VenueSize FeePerHour Purpose |150 210101-01 3-Jan-21 210101-02 3-Jan-21 210101-02 3-Jan-21 210101-02 3-Jan-21 15:00 20:00 Hibiscus |Lily Discussion v10 Small V22 Medium 260 Forum 13:00 20:00 V20 Petal Medium 260 Meeting 17:00 21:00 V10 Small Talk Hibiscus Hibiscus Muller 150 210101-02 4-Jan-21 210101-03 6-Jan-21 210101-03 6-Jan-21 210101-04 7-Jan-21 09:00 11:00 V10 Small 150 Post-eva Meeting 09:00 09:00 |16:00 |12:00 |17:00 Table 1: Details of ReserveVenue Table Large Morning Glory Small Small Appreciation Day Brain Storming Briefing V30 320 V11 150 14:00 V10 Hibiscus 150 (Hint: The hourly usage fee is charged based on size of the venue)
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
Transcribed Image Text:Normalize Table 1 to a set of Third Normal Form (3NF) relations. Your answer should show all
the three stages of normalization (1NF, 2NF and 3NF) by using the Database Design Language
format (underline all primary keys, composite keys and use an * to indicate the foreign keys). State
the action taken upon the table(s) for each Normal Form. For the INF in this case, only identify the
Primary Key and keep the INF result in a single table. Then, split into new table(s) starting from
a)
2NF onwards.
Also, consider the following assumptions:
- One ReservelD can have multiple venues' booking.
- One venue can only be booked once for the same ReservelD on the same ReserveDate
ReservelD ReserveDate StartTime EndTime VenuelD VenueTag
10:00
13:00
210101-01 3-Jan-21
210101-02 3-Jan-21
Hibiscus
Lily
VenueSize FeePerHour Purpose
|150
15:00
v10
Small
Discussion
20:00
20:00
21:00
V22
Medium
260
Forum
210101-02 3-Jan-21
13:00
V20
Petal
Medium
260
Meeting
210101-02 3-Jan-21
17:00
V10
Hibiscus
Small
150
Talk
210101-02 4-Jan-21
210101-03 6-Jan-21
210101-03 6-Jan-21
210101-04 7-Jan-21
09:00
11:00
V10
Hibiscus
Small
150
Post-eva Meeting
Large
Appreciation Day
09:00
09:00
16:00
V30
Muller
320
Morning Glory Small
Hibiscus
12:00
V11
150
Brain Storming
14:00
17:00
V10
Small
150
Briefing
Table 1: Details of ReserveVenue Table
(Hint: The hourly usage fee is charged based on size of the venue)
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 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