Events4Fun is an event management company in Europe with branches in South America as well. The company is well-known for its efficiency, good-quality services, and affordable charges. It manages various types of events throughout the year. These events include fashion shows, celebrity shows, charity shows and musical exhibitions. The details related to the type of events are stored in the EventType file. The details stored in this file consist of event type ID, description of the event, and charge per person for a particular event.
Events4Fun organizes events for its registered and new customers. The company stores details of its customers, such as customer ID, name, address, city, state, and phone numbers, in the Customers file. When a customer approaches the company for organizing an event, the customer has to specify the type of event and make payment for the selected type. The details of the selected event are stored in the Events file. The details stored in this file consist of:
- Event ID
- Event name
- Event type ID
- Location of the event
- Start date
- End date
- Staff required for the event
- ID of the employee managing the event
- Customer ID
- Number of people attending the event
In addition, the payment details, which include payment ID, event ID, payment amount, payment date, credit card number, card holders name, credit card expiry date, payment method ID, and cheque number, are stored in the Payments file.
All the Events4Fun events are managed by its efficient employees. The company stores employee details, such as employee ID, first name, last name, address, designation, and phone numbers, in the Employee file.
Due to the high quality of its service, the company has seen a tremendous increase in the number of customers. Consequently, maintaining information about events, customers, and employees manually has become difficult. Therefore, the management has decided to use a computerized event management system. For this, the management approaches MagicTech Inc. to develop the application.
At MagicTech Inc., Harry and his team have been assigned the task of creating the required application. Being the database developer in the team, you have been assigned the task of analyzing the application and creating the required database and tables.
You need to analyze the requirements of the preceding application and perform the following tasks:
1. Identify the various entities and their attributes involved in the application.
2. Identify the attributes of the entities that are unique to each entity.
3. Identify the relationships that may exist among the entities of the application.