(Solved) : Luxury Oriented Scenic Tours Lost Provides Guided Tours Groups Visitors Rotorua City Recen Q30698815 . . .
Luxury-Oriented Scenic Tours (LOST) provides guided tours togroups of visitors to Rotorua City. In recent years, LOST has grownquickly and is having difficulty keeping up with all of the variousinformation needs of the company. The company’s operations are asfollows. • LOST offers many different tours. For each tour, thetour name, approximate length (in hours), and fee charged isneeded. Guides are identified by an employee ID, but the systemshould also record a guide’s name (first and last name), homeaddress (street, city, postcode), and date of hire. Guides take atest to be qualified to lead specific tours. It is important toknow which guides are qualified to lead which tours and the datethat they completed the qualification test for each tour. A guidemay be qualified to lead many different tours. A tour can have manydifferent qualified guides. New guides may or may not be qualifiedto lead any tours, just as a new tour may or may not have anyqualified guides. Tours are identified by tour number however thesystem should also keep the record of tour name, length and fee. •Every tour must be designed to visit at least three locations. Foreach location, a name, type, and official description are kept.Some locations (e.g. the Te Puia) are visited by more than onetour, while others (e.g. Rotorua Lake) are visited by a singletour. All locations are visited by at least one tour. Each tourcovers multiple locations and the order in which the tour visitseach location should be tracked as well. • When a tour is actuallygiven, that is referred to as an “outing.” LOST schedules outingswell in advance so they can be advertised and so employees canunderstand their upcoming work schedules. Outings are identified byouting number. A tour can have many scheduled outings, althoughnewly designed tours may not have any outings scheduled. Eachouting is for a single tour and is scheduled for a particular dateand time. All outings must be associated with a tour. All tours atLOST are guided tours, so a guide must be assigned to each outing.Each outing has one and only one guide. Guides are occasionallyasked to lead an outing of a tour even if they are not officiallyqualified to lead that tour. Newly hired guides may not have everbeen scheduled to lead any outings. Tourists, called “clients” byLOST, pay to join a scheduled outing. For each client, the firstname, last name, address (street, city, postcode), and telephonenumber are recorded. Clients may sign up to join many differentoutings, and each outing can have many clients. Information is keptonly on clients who have signed up for at least one outing,although newly scheduled outings may not have any clients signed upyet.
Based on the provided information, draw an Entity-Relationship (ER)Diagram using the Crow’s foot model symbols and include allattributes. (a) Identify all possible entities and relationships.(b) Identify (i) strong and weak entities and (ii) identifying andnon-identifying relationships. (c) Identify the main attributes ineach entity including all primary and foreign keys (d) Identify theconnectivity for each relationship. (e) Identify themandatory/optional dependencies for the relationships. (f) Resolveall M:N relationships.
Expert Answer
Answer to Luxury Oriented Scenic Tours Lost Provides Guided Tours Groups Visitors Rotorua City Recen Q30698815 . . .
OR