TripGuides TripGuides (continued) 20 SLO 21 AM 22 UGO 23 DH)1 Customer 563 BRO K

Question

TripGuides TripGuides (continued) 20 SLO 21 AM 22 UGO 23 DH)1 Customer 563 BRO Ka Siata 132 Main St. e1 East Hantd CT 06108 0-35 KSo1 NY 1499085-s5.5321 RID01 24 BRO1 049 207-555-69BROI 3 Highland Ae Vaccari Am 1282Ocan Walk Occan Cay NI 022 609-555-523111 KS0 Markanirs Cherry Bson St.WesmouhMA 02188 617-555-6665 UG01 33 UXi 34 KS01 lld enon Otlauh 132South St. Apt 27 Mande ter NH 03101 fn3-555-3476 90-555-9876 16 KS02 Karn 12 Foster St. 585-555-0800 17RHO HGuice sika Late Spring R RO H 1H 18 Biking Harly Pall SLO Suva Li 5 Ria ouoa ME0 5-908 623014 Ca VT 05825 903-538-3339 92014 SiNEU Gkry FaieS CT 00 3-5-453

Explanation / Answer

Answer:

CREATE TABLE Reservation
(
ReservationID int NOT NULL,
TripID int NOT NULL,
TripDate Date,
NumPersons int,
TripPrice money,
OtherFees money,
CustomerNum int NOT NULL,
FOREIGN KEY (CustomerNum)
REFERENCES Customer(CustomerNum)

FOREIGN KEY (TripID)
REFERENCES Trip(TripID)
PRIMARY KEY (ReservationID)
);

/*This query will create a table named Reservation with the given values*/

ReservationID is the Primary key,

CustomerNum is the Foreign key referenced from Customer table.

TripID is the foreign key referenced from Trip table.

Output:

Table(s) Created.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.