Question
For each entity, include the attributes, the primary key, and foreign keys (if any). Name each relationship and diagram both the minimum and maximum cardinalities.
For each entity, include the attributes, the primary key, and foreign keys (if any). Name each relationship and diagram both the minimum and maximum cardinalities. If you cannot infer the cardinalities from the case description?
a.. DC Tour s offers many different tours.. For each tour,, the tour name,, approximate length,, and fee rate is needed.. There are four types of fee rates , namely:: adult,, senior,, child (aage 2 - 11)),, child - free (uunder age 2)) b.. Every tour must be designed to visit at least tw o locations.. For each location,, a name,, type,, and official description are kept.. Some locations (ssuch as the White House)) are visited by more than one tour,, while others (ssuch as Arlington Cemetery)) are visited by a single tour.. All locations are visite d by at least one tour.. The order in which the tour visits each location should be tracked as well.. c.. When a tour is actually given,, that is referred to as an oouting.. A tour can have many scheduled outings,, although newly designed tours may not have any outings scheduled.. Each outing is for a single tour and is scheduled for a particular date and time.. All outings must be associated with a tour.. All tours at DC Tours are guided tours,, so a guide must be assigned to each outing.. Each outing has one an d only one guide.. d.. Guides are identified by an employee ID,, but the system should also record a guides name,, home address,, and date of hire , and contact number . Few experienced guides are identified as head guides.. A head guide may manage several guides,, and each guide is managed by one he ad guide.. e.. Tour ists pay to join a scheduled outing.. For each tourist , the name and telephone number are recorded.. Tourists may sign up to join many different outings,, and each outing ca n have many tourists . Information is kept only on tourists who have signed up for at least one outing,, although newly scheduled outings may not have any tourists signed up yet..
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started