Qnestion $2(30$ marks$)$

Create a fully developed Crow's Foot notation ERD to support the following business operations Use Lucialkart to produce the ERD, Cops$-$and$-$paste the ERD directly from Lucidchart outo WORD to produce a clear pucture $($refrim from screen capturing$).$ The font size set in L scidchart should be large enough to make the text clearly readable after pasting the ERD onto WORD.

i$.$ Miror Tours $($MI$)$ prosides guided touss to groups of visitors in Hong Kong. For each tour, the tour name, approximate length $($in hours$),$ and fee charged is needed Guides are identified by an employee ID$,$ but the system should also record a guide's name, home address, and date of hire Guides take a teet to be qualified to lead specific tours. It is important to knorv 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 toars, A tour can have many different qualified guider. New guides may or may not be qualified to lead any tours, jurt as a new tour may or may not have any qualified grides.

ii Every tour must be designed to cisit at least three locations. For each location, a name, type, and official description are kept. Some locations $($such as the Peak$)$ are visited by more thas one tour, while others $($such as Ocean Park$)$ are visited by a single tour. Ail locations are visited by at least one tour. The order in which the tour visits each location should be tracked as well.

iii. When a tour is actarlly given, that is referred to as an "outing," MT schedules outingr well in advance so they cas be advertised, and so employees can understand their upcoming work schedules. A tour can have many schoduled outings, although pewly designed tours mary pot hesic any gatings :cheduled. Fach outing is for a single tour and is schedaled for a particular date and tume. All ortinga must be associated with a tour and a guile qualified for that tour. Each outing has one and only one qualfied guide. Newly hired guides mayy not have ever been scheduled to lead any outinga. and telephose number are recorded. Clients may sugu up to join many different outings, and each outing can have many clients. luformation is kept only on clients who have signed up for at lest one outing, although neuly schedaled outings may not have any cirits nenol up yet.

The Crow's Fool ERD should be fully attributed, including all entities, attributes, relatiombips $($consectivities$),$ and contraints $($primary keys, foreign keys$).$ Design all appropriate attributes, relationhips, and constraints in the ERD. The diagram should include exactly the following entities:

TOUR QUALIFIED, GUIDE, STOP, LOCATION, OUTING, BOOKING, CLIENT

Here, STOP records the locations viuted by the toums. QUALIFIED records the guides qualified to lead the fours. BOOKING records the clients joining the outing?