[ANSWER HAS TO BE IN RELATIONAL ALGEBRA NOT SQL]

This task asks us to write the relational schema, so there is no real data in this table. This is not asking us to write the SQL, it's relation schema.

Exercise 1 (Relational Algebra) [25 points] Consider the following relations for gyms. The primary keys are underlined. All attributes are of type string if not indicated otherwise. Customer (customer_ID, customer_name, SSN, customer_age: integer, customer_gender, address) Gym (gym name, location, type, membership_price: integer) o The values for the column named type are with Pool or without Pool. Guest (guest_name, customer ID, guest_age: integer, guest_gender) The gyms allow each customer to have guests associated with him/her. Member (customer ID, gym name) 1. [5 points) Find the names of gyms that have swimming pools in Gainesville. 2. [5 points] Find the names of guests who are brought by young customers (age