Normalize the given database to 3NF (3rd normal form). Show all the dependencies: Fully, Partial dependency, and transitive dependencies. Draw the normalized database.

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

Normalize the given database to 3NF (3rd normal form). Show all the dependencies: Fully, Partial dependency, and transitive dependencies.

Draw the normalized database.

Name
Phone
Email
Room#
Room-Type
Check-in
Check-Out
Room-Rate
Actual-Rate
Reservation#
Card#
Card-Type
Card-Expiry
Saleem
50882
s@yahoo.com
121
Standard
01-04-22
03-04-22
80USD
90USD
1234
1112233
VISA
12/23
Ali
34332
a@gmail.com
205
Single
15-04-22
19-04-22
50USD
50USD
1234
235565
MC
10/22
Nabeel
50822
s@yahoo.com
121
Standard
01-04-22
19-04-22
80USD
90USD
2345
1112233
VISA
12/23
Gul
76543
g@yahoo.com
203
Single
07-03-22
10-03-22
30USD
35USD
9003
338899
VISA
07/22
Transcribed Image Text:Name Phone Email Room# Room-Type Check-in Check-Out Room-Rate Actual-Rate Reservation# Card# Card-Type Card-Expiry Saleem 50882 s@yahoo.com 121 Standard 01-04-22 03-04-22 80USD 90USD 1234 1112233 VISA 12/23 Ali 34332 a@gmail.com 205 Single 15-04-22 19-04-22 50USD 50USD 1234 235565 MC 10/22 Nabeel 50822 s@yahoo.com 121 Standard 01-04-22 19-04-22 80USD 90USD 2345 1112233 VISA 12/23 Gul 76543 g@yahoo.com 203 Single 07-03-22 10-03-22 30USD 35USD 9003 338899 VISA 07/22
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

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