All work is written NOT CODED, thank you and have a good day.

employee (ename, street, city) works (pname, cname, salary) company (cname, city) Figure 1. Employee database. 1) (6 points) Consider the Employee database of Figure 1. Write SQL DDL statements to create the three tables in the database. Your DDL statements must: - Use the appropriate data type for each attribute - Specify the primary key clause in each DDL statement (primary keys are underlined in the Figure) - Specify foreign key constraints if necessary 2) (6 points) Consider the employee database of Figure 1. Write SQL statements to express each of the following queries: - Find the name of each employee who lives in city "Dallas" - Find the name of each employee who lives in "Dallas" and whose salary is greater than $100000 - Find the name of each employee who does not work for "BigDallas