![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781285427102/9781285427102_largeCoverImage.gif)
(a)
To design a
List the guide number, guide last name, guide first name, address, city, state, postal code, telephone number and date hired for each guide.
(b)
To design a database, using DBDL and ER diagram, for the following user view:
For each trip list the trip ID, name of trip, starting location of trip, state in which trip originate, distance of trip, maximum group size of trip, type of trip and season of trip. Along with that list the guide number, first name, last name of each guide for the trip with the following constraints: a guide may lead many trips and a trip may be led by many different guides.
(c)
To design a database, using DBDL and ER diagram, for the following user view:
For each customer provide customer number, last name, first name, address, city, state, postal code and telephone number.
(d)
To design a database, using DBDL and ER diagram, for the following user view:
For each reservation provide trip ID number, trip date, number of persons included in reservation, per person price of trip, additional charges per person along with customer number, his/her first name, and last name.
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Chapter 6 Solutions
Concepts of Database Management
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)