WRITE IN MySQL THE PROBLEM:

Homework 1 Consider the following ER diagram: Rent Lease 1 M M 1 TENANTS SPACES BUILDINGS The relations will contain (but are not limited to) the following attributes: . . . TENANTS (name, email, phone_number, contact_person) SPACES (number, floor, area, price) BUILDINGS (name, street_address, city, country) 1. Create the tables corresponding to each relation and implement the associations indicated in the ER diagram. Explain the choices for the data types and the constraints that are used and why SPACES is considered a weak entity. (10p) 2. Populate your tables with at least two records each. (5p) 3. Write a statement that will generate the following result and explain the relational algebra operations which are required: "Display the list of buildings in a particular city, containing the buildings names, addresses, and total deasable area ordered by the total leasable area in descending order". The city will be one of the ones from exercise 2 and the result will include the following attributes: (100) name street_address city country total area 4. Write a statement to delete one of the tenants from exercise 2. Based on your database design, explain the implications of the operation. (5p)