co3ds13h.ch04.10 Check My Work Lasury-Oriented Scenie Tours LOST prov ides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with al of the various information needs of the company. The company's operations are as follows: . LOST offers many different tours. For employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a t r each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an est to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date , that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified des. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides Every tour must be designed to visit at least three locations. For each location, a name, type, and official description are kept. Some locations (such as t White House) are visited by more than one tour, while others (such as Arlington Cemetery) are visited by a single tour. All locations are tour. The order in which the tour visits each location should be tracked as well. visited by at least one When a tour is actually given, that is referred to as an "outing." LOST schedules outings well in advance so they can be advertised and so employees can understand their upeoming work schedules. 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 LOST are guided tours, so a guide must be assigned to each outing. Each outing has one and only one guide. Guides are occasionally asked to lead an outing of a tour even if they are not officially qualified to lead that tour. Newly hired guides may not have ever been scheduled to lead any outings. Tourists, called clients" by LOST, pay to join a many clients. Information is kept only on clients who have signed up for at least one outing, although newly scheduled outings may not have any clients signed up yet a. Create a Crow's Foot notation ERD to support LOST operations state that it is possible for a guide to lead an outing of a tour even if the guide is not officially qualified to lead outings of that tour. Imagine that the business rules instead specified that a guide is never, under any cireumstance, allowed to lead an outing unless he or she is qualified to lead outings of that tour. How could the data model in Part a. be modified to enforce this new constraint? To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the ile name. (Example: chq-problems Jones.doc) co3ds13h.ch04.10 Check My Work Lasury-Oriented Scenie Tours LOST prov ides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with al of the various information needs of the company. The company's operations are as follows: . LOST offers many different tours. For employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a t r each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an est to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date , that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified des. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides Every tour must be designed to visit at least three locations. For each location, a name, type, and official description are kept. Some locations (such as t White House) are visited by more than one tour, while others (such as Arlington Cemetery) are visited by a single tour. All locations are tour. The order in which the tour visits each location should be tracked as well. visited by at least one When a tour is actually given, that is referred to as an "outing." LOST schedules outings well in advance so they can be advertised and so employees can understand their upeoming work schedules. 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 LOST are guided tours, so a guide must be assigned to each outing. Each outing has one and only one guide. Guides are occasionally asked to lead an outing of a tour even if they are not officially qualified to lead that tour. Newly hired guides may not have ever been scheduled to lead any outings. Tourists, called clients" by LOST, pay to join a many clients. Information is kept only on clients who have signed up for at least one outing, although newly scheduled outings may not have any clients signed up yet a. Create a Crow's Foot notation ERD to support LOST operations state that it is possible for a guide to lead an outing of a tour even if the guide is not officially qualified to lead outings of that tour. Imagine that the business rules instead specified that a guide is never, under any cireumstance, allowed to lead an outing unless he or she is qualified to lead outings of that tour. How could the data model in Part a. be modified to enforce this new constraint? To upload and submit your assignment, click the Choose File button below to find and select your saved document. Make sure that the file is saved with your last name in the ile name. (Example: chq-problems Jones.doc)