Dorms

Introduction

In this exercise you will practice

Problem Description

You work for the housing department of a major university and want to analyze information in your residency database.

Solution Description

  1. Download dorms-schema.sql and dorms-data.sql
  2. On the command line, go to the directory where you downloaded the dorms database scripts.

  3. If on macOS, make sure your MySQL server is running:

     $ mysql.server start
 Starting MySQL
 SUCCESS!

  4. Run the ~dorms.sql~ script like this (can leave off -p if your password is blank):

    $ mysql -u root -p < dorms-schema.sql
$ mysql -u root -p < dorms-data.sql

Running Queries on the Dorms Database

Start MySQL’s client and ~use~ the ~dorms~ database.

```sh
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
...
mysql> use dorms
...
Database changed
mysql>
```

Exploring the Database

Get a list of the tables:

mysql> show tables;
+-----------------+
| Tables_in_dorms |
+-----------------+
| dorm            |
| student         |
+-----------------+
2 rows in set (0.00 sec)

See the structure of a table:

mysql> describe dorm;
+---------+---------+------+-----+---------+-------+
| Field   | Type    | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| dorm_id | int(11) | NO   | PRI | NULL    |       |
| name    | text    | YES  |     | NULL    |       |
| spaces  | int(11) | YES  |     | NULL    |       |
+---------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)

Simple Queries on Dorms Database