Database Design Assignment You are designing a database for a corporate event management company. The company organizes paid events and hires event workers (e.g., staff, technicians, coordinators) to manage them. The company needs to track the events, workers hired for each event, locations where the events take place, and customer feedback on the events. Your manager discussed with you the logic of this database. Below are the requirements: e Workers can participate in multiple events, and each event requires many workers to manage. e Each event takes place in one single location. Based on the different dates of events, however, one location may be used to host many events. e When an event is over, multiple pieces of feedback are collected from customers. There are a total of five events and the revenues are in parentheses: e Corporate Gala ($5000): An elegant gala for corporate clients. 5/15 e Product Launch ($3000): Launch event for a new product. 5/25 e Networking Mixer ($1500): Casual networking event for professionals. 6/18 e Annual Conference ($7000): A full-day corporate conference. 7/3 e Team Building Retreat ($4500): Outdoor activities for team building. 8/31 HR provides you with a list of workers at those events. FirstName | LastName Role HourlyRate John Doe Technician 25 Maria Smith Coordinator 30 Ali Khan Event Staff 20 Sarah Lee Technician 25 Emma Brown Coordinator 30 Michael Johnson Event Staff 22 Jessica White Photographer 35 Besides, HR also provides you the information about participation. e John Doe, Emma Brown, and Jessica White were assigned to the Corporate Gala event. Each of them worked 5 hours. . aria Smith, Michael Johnson, and Jessica White were assigned to the Product Launch 'ent. Each of them worked 8 hours' e Ali Khan and Sarah Lee were assigned to the Networking Miser event. Each of them worked 3 hours. e Maria Smith, Ali Khan, Sarah Lee, and Jessica White were assigned to the Annual Conference event. Each of them worked 6 hours. e All of them except Jessica White where assigned to the Team Building Retreat event. Each of them worked 12 hours. Your intern reports to you the locations that were used for those events, and the customer feedback for each event. LocationName | Address City Grand 123 Ballroom Main St. New Yark Event Hall 456 Elm Boston St. Conference 789 Oak San Center St. Francisco 0 ceanfront 321 Bay Miami Hotel St. Mountain 654 Pine Denver Resort St. Event FeedbackDate | Rating Corporate Gala 5/17/2024 Corporate Gala 5/31/2024 Product Launch 6/5/2024 Annual Conference 7/4/2024 Team Buildin Retreat : Y2224 Product Launch 6/6/2024 Corporate Gala 5/18/2024 Annual Conference 7/15/2024 ZipCode Event Corporate Gala Product Launch Annual Conference Networking Mixer Team Building Retreat Comments Fantastic event, very well organized. Need more space. Great Launch! The schedule was too tight. Fun and engaging team-building activities. Too long. Wonderful. Poor organization Your manager has some requirements based on information you have