CITA 310 Lab
Lab 6 SQL:
Remember: Document, Document, and Document!
Please document your new setup in your lab notebook – due next week’s lab period!
For this lab sharing of ideas and of successful techniques between teams is encouraged. However, as
always, make sure your documentation is your own for your team’s system.
Materials needed:
- ICY DOCK external drive(s) configured with operating systems
Objective:
- Install SQL Server and MySQl and demonstrate that they work by adding a simple database.
Part I: MySQL:
1) Using your text (pages 324-327) as a guide, and making modifications where necessary:
a) Install MySQL, if needed.
i) Use System > Administration > Services to see if it is already installed. If it is, Enable the service if
necessary.
ii) Use System > Administration > Add/Remove Software if needed to add the package if it is not
already installed.
b) Start the MySQL service and verify that it is running.
c) Edit rc.local to make MySQL start whenever Linux starts. Prove this is working.
d) With FC 10, I found it unnecessary to take separate steps to set a password. Your mileage may vary.
e) Once you get the login and password set, follow the steps on page 326-327 to create a simple employee
database with one table. You will find the hr.sql script on the R: drive under course materials. Make sure
you have a total of three records.
i) Create a second script to add all the members of your team. DO NOT ENTER YOUR REAL SSN!
Also, obviously you won’t be mounting a floppy. Make appropriate changes to access the data in the
hr.sql script.
ii) NOTE – IMPORTANT: Remember to end every mysql command with a semi-colon (;)!
f) Capturing the text output of the command in step 6 on page 327 will prove that the database and table
were created. You should end up with something like this (except with your team’s names added):
mysql> select * from employee;
+-----------+-----------+----------+-------+--------+
| ssn | firstname | lastname | depno | salary |
+-----------+-----------+----------+-------+--------+
| 553879098 | Lynn | Gweeny | 10 | 55000 |
| 623827368 | Elark | Kaboom | 10 | 60000 |
| 756838998 | Bernard | Flapdoodle | 20 | 45000 |
+-----------+-----------+----------+-------+--------+
3 rows in set (0.00 sec)
Part II: SQL Server:
2) Use your text, starting on page 315 as a guide for Installing SQL Server. Adjust for any differences with
Server 2008.
3) Continue following the text as a guide and create the hr database as on page 321.
4) Create the employee table by using SQL create table statements (not the wizard).
5) Capture documentation to show that you were successful in doing this.
