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.

Relational schema for the MAH database:

Adventure(Adventure_Code, Adventure_Duration, Adventure_Price, Adventure_Accom_Type, Adventure_Description)

Event(Adventure_Code, Event_Code, Event_Start_Date, Event_Leader)

Customer(Customer_ID, Customer_Name, Customer_Address)

Staff(Staff_ID, Staff_Name, Skills)

Assistant(Event_Code, Staff_ID)

Activities(Activity_Code, Activity_Name)

Event_Customer(Event_Code, Customer_ID)

Preference(Adventure_Code, Event_Code, Customer_ID, Activity_Code)

Brochure_Request(Request_Code, Date_Requested, Date_Sent, Customer_Name, Customer_ID, Customer_Address, Adventure_Code)

Booking(Booking_Code, Customer_ID, Adventure_Code, Event_Code, Booking_Fee, Activities_Selected)

Payment(Booking_Code, Payment_Code, Customer_ID, Adventure_Code, Event_Code, Payment_Date, Payment_Amount)

Event_Staff(Event_Code, Staff_ID)

Event_Activity(Event_Code, Activity_Code)