For this homework, we begin to build a database for the brain trauma data. Due date: midnight, Thursday Nov 8 Points: 15 Tasks... * Download the sample data from blackboard - click on "Content" on the left, Brain Trauma Data, then download and extract the zip file. * Reading the info.txt file that has some basic information about the files. Note that for now this sample data is only for a single patient. * Choose 3 of the files to load into your database. * Create a database and tables for the 3 files. * Load the data into your database. Notes... * The sample data is a small subset of the actual data. I chopped off each of the files after 1000 lines. Some of them had something like 300,000 lines originally. * The sample data is tab-separated, I believe. * For your tables, I'd use just the short abbreviation for the monitoring data. For example, the column for heart rate would be called HR * I believe all the data are floating point values, so you can use some corresponding number type in mysql. * I don't have logins for you on any of the CS computers yet. Just get it working on your own system, but keep track of everything so you'll be able to easily put things onto one of the servers when we're ready for that. So, for example, create a .sql text file that has the commands to create your tables. Then to put the database on another server, you'll just run mysql with that .sql file as the input. * I'll have some queries to test your database on at some point, but not yet.