Requirements:

1. Create a fully expanded ERD based on the above information and some examples in Appendix A.

2. Create a Relational Schema based on the ERD.

3. Create a Network Diagram based on your relation schema.

Melbourne Adventure Hub (MAH) Business Narrative Melbourne Adventure Hub (MAH) runs camping and motel adventures around Australla. The adventures originate in Melbourne and go to places such as Philip Island, Great Ocean Road and Central Australia. Each adventure is run on a number of occasions each year (each occasion is known as an event). Each event has one tour leader. Each event may have many tour assistants. All leaders and assistants are employees of MAH. An employee who is a leader of one event may be an assistant of a different event. All emplovees possess a number of skills (such as cooking. first aid, bus driver). No two events for the same adventure code ever commence on the same date. People interested in participating in an adventure usually write to or ring MAH requesting an adventure brochure. MAH immediately assigns that person a customer identification code and also records the name, address and phone number of the person making the brochure request. MAal also records that date the request was made. A printed brochure is normally sent out the same day. At some pcint of every event, MAH has a special activity evening. Activities may include shark feeding, Shopping. Rock Climbing. Toga Party, Attending a Movie etc. Each activity has an activity code and an activity description. MAH administration specify which activities are available for each event (e.g., this will change from event to event depending upon weather conditions, access to resources, time of year etc.). For each customer attending an event, MAH assigns the customer a customer identification code funless the person has previously been assigned a customer identification code via a brochure request or a previous booking) and records the name, address and phone number. MAH also records the fee charged (same value as the current event price) to the customer*. They also record the total payment that has been made by the participant. (A customer may pay half the money at the time of the booking and then pay the remainder at a later date). MAH also records which activities the participant has a preference for iparticipants are encouraged to nominate for more than one activity in case one or more activities are cancelled due to unforeseen circumstances). Obviously, customers can only choose activities that are available for the event they have selected. - The current price of eoch odventure is stored in the dotabase. However, this price does change from time to time (due to inflotion and increases in fuel costs etc). Therefore, MAH need recard the price of an adventure for every booking that is mode (this is called a fee). Note: You are not expected to attempt to validate data such as: - To ensure customer books on two tours that overlap - To ensure staff members are no allocated to two tours that overlap Page 2 of 7 - To ensure customers have not underpaid or overpaid their booking payments These are beyond the scope of this assignment. Such restrictions would normally be programmatically solved using Stored Procedures/ Functions, Triggers or some other programming technique. Requirements: 1. Create a fully expanded ERD based on the above information and some examples in Appendix A. 2. Create a Relational Schema based on the ERD. 3. Create a Network Diagram based on your relation schema. Appendix: Information derived from existing documents Below are copies of various word-processed reports/documents that are manually prepared by staff. Adventures Event (tour) Calendar Page 5 of 7 Prepared by Ravinda Wijesinghe 2/10/2022 Aletivities Cuctoiner antails Prepared by Ravenda Wiesinghe Brochure Repuects