please answer question in detail!

The Olympic facilities are divided into multisport sport complexes. Such complexes have areas of the complex designated for each sport with a location indicator (e.g., center, NE corner, and so on). A complex has a location, chief organizing individual, total occupied area, and so on. Each complex holds events. For each event, there is a description, a planned date, duration, and number of participants. Officials involved with the event should also be recorded. Different equipment is needed for the events (e.g., goal posts, poles, parallel bars). Information about each piece of equipment should be recorded. (5 pts) Draw an E/R diagram capturing the above description. (5 pts) Translate your E/R diagram into a relational schema using the E/R approach and write the SQL statements for the table creation. Specify primary keys and foreign keys. Hint. Use surrogate keys to simplify your design in terms of keys, e.g. cid (complex id), eventid, etc