You are the DBA for Colonial Adventure Tours. The company is considering accepti

Question

You are the DBA for Colonial Adventure Tours. The company is considering accepting reservations from sports clubs,

such as hiking clubs. The reservation would be for the entire group. What changes to the database structure would

you need to make to accommodate accepting reservations from groups or organizations as well as individuals?

Current tables are:

Customer(CustomerNum, LastName, FirstName, Address, City, State, PostalCode, Phone)

Reservation(ReservationID, TripID, TripDate, NumPersons, TripPrice, OtherFees, CustomerNum)

Trip(TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season)

TripGuides(TripID, GuideNum)

Guide(GuideNum, LastName, FirstName, Address, City, State, PostalCode, PhoneNum, HireDate)

Explanation / Answer

Lets have a member tourist: who could be an individual or group.
Its like an is a relationship.
Leaving other tables as it is, lets add another table Group.
Group(GroupID, GroupName, Address, City, State, PostalCode, GroupLeadPhone, NumOfMembers)
This will work fine, if we are not interested in every individual details, if they registered
as a group. Where as, if we also need the individual details, who could be a member of a group,
now Customer relation should be altered.
Customer(CustomerNum, LastName, FirstName, Address, City, State, PostalCode, Phone, MemberOf)
Where MemberOf is a reference key to group, and is allowed to be NULL.

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.