Ask a question to Desklib · AI bot


Introduction To MySQL | Assignment

3 Pages742 Words304 Views

Added on  2019-09-22

BookmarkShareRelated Documents
Introduction to MySQLDelivery MethodYou will hand in four files that are contained in a tarball. The first file, named queries.txt, will contain the text of the 3 queries you generate. The remaining three files 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 sample employee 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 it and submit the resulting output. You are responsible for getting access to a mysql environment. You can use the CS virtual machine or any other machine you want that you can install mysql on. It is an exercise for the student to install mysql on whatever machine they choose.In your virtual machine (or whichever Linux environment you are using), install the sample database into mysql. Follow the instructions on this github page for installation.’s a good idea to run the validation script that generates and compares checksums to ensure your installation is correct.Once you have the database installed, start a mysql client and execute the following commands:mysql> show databases;There should be an employees database listed.
Introduction To MySQL | Assignment_1

Found this document preview useful?

Related Documents
Decomposing to Third Normal Form.

Website Development | Assignment

Installing & getting started with Cloudera QuickStart on VMWare

Database management system - Assignment

First National Bank - User Registration, Login, Account Management and Transactions

System Security : Report