Question: Event Manager Event assign Equipment Include Engagement make Client Sample Values 2 E011 Corporate Dinner Indoor Adults G0909 25 June 2015 8pm 17 July 2015

Event Manager Event assign Equipment Include

Event Manager Event assign Equipment Include

Event Manager Event assign Equipment Include Engagement make Client Sample Values 2 E011 Corporate Dinner Indoor Adults G0909 25 June 2015 8pm 17 July 2015 Entity Attributes Sample Values 1 Event Event ID E001 Description Birthday Party for Kids Event Type Outdoor Target Audience Family Engagement Engagement ID G0001 Date of Engagement 20 June 2015 Time of Event 10am Date of Event 31 August 2015 Duration (hours) 3 Capacity (pax) 100 Location Hilton KL Entity Attributes Sample Value 1 Client Client ID C1001 Client Name Sunlight Tadika Contact Person Nina Choo Phone 03-89898987 Email NULL Equipment Equipment No 10000 Description Sound Systems Charge per day 1500.50 Event Staff ID 1008900 Manager Name Edline Youn Phone 012-9876543 200 MMU Grand Hall Sample Values 2 C2001 MMU Sabri Yusoff 03-83123456 Sabri@mmu.edu.my 89000 Camera 500.00 1007890 Hafiz Hashim 013-1234567 1. Complete the ER-diagram above with appropriate connectivity and cardinality based on the following business rules: a. Each event has many engagements. An engagement is associated with one and only one event b. Each engagement is handled by an event manager. But, an event manager handles more than one engagement C. Each engagement is associated with one and only one client, but a client has many engagements. d. Each engagement uses a many pieces of equipment. Each piece of Equipment can used in many engagements

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!