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.
You've reached the end of your free preview.
Want to read both pages?
- Fall '17