6 Colonial Adventure Tours.docx - Colonial Adventure Tours Case 1.Design a database to produce the following reports Do not use any surrogate keys in

6 Colonial Adventure Tours.docx - Colonial Adventure Tours...

This preview shows page 1 - 2 out of 2 pages.

Colonial Adventure Tours Case 1.Design a database to produce the following reports. Do not use any surrogate keys in your design.Guide (GuideID(PK), LastName, FirstName, Address, City, State, PostalCode, PhoneNum, HireDate) Ak PhoneNumSK LastNameTrip(TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season)SK TripNameFK NoneTripGuide (TripID, GuideID)FK TripID->TripFK GuideID->GuideReservation (ReservationID, TripID, TripDate, NumPersons, TripPrice, CustomerNum)SK TripDateFK TripID->TripFK CustomerNum->CustomerCustomer (Customer Num(PK), LastName, FirstName, Address, City, State, PostCode, Phone)AK PhoneSK LastName2. Expand the database design you created in Exercise 1 so that it will support the following situation: A reservation agent handles each reservation. Along with all the details concerning a reservation listed in Exercise 1, list the number, last name, and first name of the agent that handled the reservation.
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '17

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture