Client clientnum clientlastname clientfirstname

  • No School
  • AA 1
  • coreyjohnson2014
  • 2
  • 100% (3) 3 out of 3 people found this document helpful

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

CLIENT (CLIENT_NUM, CLIENT_LASTNAME, CLIENT_FIRSTNAME, ADDRESS, CITY, STATE, POSTAL_CODE, TELEPHONE_NUM)2.Colonial Adventure Tours is considering offering outdoor adventure classes. These classes would better prepare people to participate in hiking, biking, and paddling adventures. Only one class is taught on any given day. Participants can enroll in one class or several classes. Classes are taught by the guides that Colonial Adventure employs. Colonial Adventure Tours needs your help with the database design for this new venture. In each step, represent your answer in DBDL with a diagram. You may use any of the styles presented in this chapter for the diagram. Colonial Adventure Tours needs to produce the following reports:a.For each participant, list his or her number, last name, first name, address, city, state, postal code, telephone number, and date of birth.PARTICIPANT (PARTICIPANT_NUM, LAST_NAME, FIRST_NAME, ADDRESS, CITY, STATE, POSTAL_CODE, TELEPHONE_NUM, BIRTH_DATE)b.For each adventure class, list the class number, class description, maximum number of persons in the class, and class fee.
Background image
Image of page 2

You've reached the end of your free preview.

Want to read both pages?

  • Fall '19

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture