Question
A fully expanded and complete ERD diagram. The diagram must be an image that has been generated in www.diagrams.net. The diagram must follow the ERD
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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started