Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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
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
See similar textbooks
icon
Related questions
Question
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: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
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.
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Binary numbers
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education
SEE MORE TEXTBOOKS