Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started