Ask a question from expert

Ask now

Introduction To MySQL | Assignment

3 Pages742 Words304 Views
   

Added on  2019-09-22

Introduction To MySQL | Assignment

   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. https://dev.mysql.com/doc/employee/en/employees-installation.htmlIt’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

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Decomposing to Third Normal Form.
|2
|458
|341

Website Development | Assignment
|14
|1218
|21

Installing & getting started with Cloudera QuickStart on VMWare
|25
|2909
|245

Database management system - Assignment
|34
|4683
|127

First National Bank - User Registration, Login, Account Management and Transactions
|9
|830
|301

System Security : Report
|13
|999
|347