Download a dataset from Baltimore Open Data (https://data.baltimorecity.gov/). Do not use a dataset that we used in class. Import the dataset into MySQL using the “load data local infile...” command....

Download a dataset from Baltimore Open Data (https://data.baltimorecity.gov/). Do not use a dataset that we used in class. Import the dataset into MySQL using the “load data local infile...” command. The name of the database should be _a1, so in my case it would be Ellington_a1. Create a small Java application that connects to the database and executes two queries. Each query should have a WHERE condition, and should be limited to one table only. The name of the class should be _a1.java. Create a file that contains the two queries. Name the file _a1_queries.sql. For each query, show the following: • The query, and • A comment that describes in plain English the purpose of the query. Export the MySQL database (schema) to a .sql file using the ‘mysqldump’ command. The dump file name should be _a1_schema.sql. Notes Your application should run in the virtual machine that will be used throughout the course. Failure to follow the naming conventions outlined above will result in a deduction of 5 points for each misnamed file. Turn in Turn in the following material: 1. The Java file that contains the small program (_a1.java); 2. A SQL file which contains the two queries as well as an explanation of what each query fetches (_a1_queries.sql); 3. The SQL file that contains the database that you imported into your MySQL server (_a1_schema.sql).