Introduction To MySQL | Assignment
Added on - 22 Sep 2019
Introduction to MySQLDelivery MethodYou will hand in four files that are contained in a tarball. The first file, namedqueries.txt, will contain the text of the 3 queries you generate. The remaining threefiles will contain the redirected output generated by each of the three queries.DescriptionAs an introduction to mysql, you will import and submit queries against a sampleemployee database provided with mysql. The database contains about 300,000 employeerecords with 2.8 million salary entries. The database size is approximately 167 MB,which is not huge, but heavy enough to be non-trivial for testing.ProcedureIn this assignment you will import this database, perform various SQL operations on itand submit the resulting output.You are responsible for getting access to a mysql environment. You can use the CSvirtual machine or any other machine you want that you can install mysql on. It is anexercise for the student to install mysql on whatever machine they choose.In your virtual machine (or whichever Linux environment you are using), install thesample database into mysql. Follow the instructions on this github page for installation.https://dev.mysql.com/doc/employee/en/employees-installation.htmlIt’s a good idea to run the validation script that generates and compares checksums toensure your installation is correct.Once you have the database installed, start a mysql client and execute the followingcommands:mysql> show databases;There should be anemployeesdatabase listed.