In each exercise, represent your answer in both DBDL and with a diagram. 1. Design a database to produce the following reports. Do not use any surrogate keys in your design. a. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. Guide (GuideNum , LastName, FirstName, Address, City, State, ZipCode, PhoneNum, HireDate) b. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. Trip (TripID , TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season) Guide (GuideNum , LastName, FirstName, Address, City, State, ZipCode, PhoneNum, HireDate)
You've reached the end of your free preview.
Want to read all 4 pages?
- Fall '19