Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Database Instance: TRAVELER TriD TrName 0001 White 0002 Goodman 0003 Pinkman 0004 Fring 0005 Margolis TrPhone 5551234 5559876 5551609 5552112 5555150 BOOKING TouriD Travelerld 44890

image text in transcribed

Database Instance: TRAVELER TriD TrName 0001 White 0002 Goodman 0003 Pinkman 0004 Fring 0005 Margolis TrPhone 5551234 5559876 5551609 5552112 5555150 BOOKING TouriD Travelerld 44890 0001 44890 0002 86428 0004 12345 0001 70291 0004 TourDate 03-JUN-19 03-JUN-19 01-AUG-19 15-AUG-19 10-SEP-19 DType TOUR TID 12345 44890 70291 86428 DestinationID 002 016 002 003 Tlength 5 14 TPrice 4000 8000 2500 5000 DESTINATION DID DLocation 001 Cleveland 002 New York 003 Cozumel 004 Bermuda 016 Alaska City City Resort Cruise Cruise a. List the attribute(s) that make up the primary key (if one exists) in DESTINATION. b. List the attribute(s) that make up the primary key (if one exists) in TOUR. c. List the attribute(s) that make up the primary key (if one exists) in BOOKING. d. List the attribute(s) that make up the foreign key(s) (if any exist) in DESTINATION. e. List the attribute(s) that make up the foreign key(s) (if any exist) in TOUR. f. List the attribute(s) that make up the foreign key(s) (if any exist) in BOOKING. g. Construct a new tuple that can be inserted into BOOKING without violating any constraints. h. Construct a new tuple that cannot be inserted into BOOKING because doing so would violate referential integrity (but would not violate any other constraints) i. Construct a new tuple that can be inserted into TOUR without violating any constraints. j. Construct a new tuple that cannot be inserted into TOUR because doing so would violate a key constraint (and thus would also violate entity integrity), but would not violate any other constraints. k. Which of the tuples in DESTINATION could be removed without violating referential integrity? Explain why

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatio Temporal Database Management International Workshop Stdbm 99 Edinburgh Scotland September 10 11 1999 Proceedings Lncs 1678

Authors: Michael H. Bohlen ,Christian S. Jensen ,Michel O. Scholl

1999th Edition

3540664017, 978-3540664017

More Books

Students also viewed these Databases questions