Customer Trip Guide CustomerNum TripID GuideNum LastName TripName StartLocation LastName FirstName FirstName Address State Distance Address City State PostalCode MaxGrpSize Туре Season City State PostalCode PhoneNum Phone HireDate Reservation ReservationID TripID TripDate NumPersons
Customer Trip Guide CustomerNum TripID GuideNum LastName TripName StartLocation LastName FirstName FirstName Address State Distance Address City State PostalCode MaxGrpSize Туре Season City State PostalCode PhoneNum Phone HireDate Reservation ReservationID TripID TripDate NumPersons
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question

Transcribed Image Text:Customer
Trip
Guide
CustomerNum
TriplD
GuideNum
LastName
TripName
StartLocation
LastName
FirstName
FirstName
Address
State
Address
City
State
PostalCode
Distance
MaxGrpSize
Туре
Season
City
State
PostalCode
PhoneNum
Phone
HireDate
Reservation
ReservationID
TripID
TripDate
NumPersons
TripPrice
OtherFees
CustomerNum
TripGuides
TripID
GuideNum

Transcribed Image Text:Normalization and Functional Dependencies: Chapter 5
cification:
1. Using the types of entities found in the Colonial Adventure Tours database (trips, guides,
clients, and reservations), create an example of a table that is in first normal form but not in
second normal form. Explain your why your answer is in 1NF but not 2NF, show how to
convert to the third normal form. Choose a simple example.
2. Using the types of entities found in the Colonial Adventure Tours database (trips, guides,
clients, and reservations), create an example of a table that is in second normal form but
not in third normal form. Explain your why your answer is in 2NF but not 3NF, show how to
convert to the third normal form. Choose a simple example.
3. Identify the functional dependencies in the following unnormalized table. Convert the table
to third normal form. Show each step (1NF, 2NF, and 3NF).
Reservation (ReservationID, TripID, TripDate, TripPrice, OtherFees,
(ClientNum, ClientLastName, Client FirstName, Address, City, State,
ZipCode, Phone))
4. Currently, each trip is identified with only season. For example, the Arethusa Falls trip is
offered only in the Summer season. Colonial Adventure Tours is considering offering the
same trip in more than one season; that is, the Arethusa Falls trip could be offered in both
the Summer and Late Spring seasons. Using this new information, identify all dependencies
and convert the current Trip table to third normal form. You may need to make some
assumptions. Identify these assumptions in your solution.
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

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

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON

Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education