Project 1

Jan 11, 2011

Objective

Install and run SQLite, open your first SQLite database.

Requirements

Read SQLite pages 17 - 18 ("Where to Get SQLite").

Windows users: also read chapter 2 pages 18 - 20.

POSIX users: also read chapter 2 pages 30 - 32.

Download and install SQLite on your workstation. Configure your PATH (POSIX users, create an alias) so you can run SQLite from any directory.

Verify your path settings:
Open a console window. Type sqlite3. Did it work? Change to another directory ( eg, cd ..). Type sqlite3. Did it work?

Create a dedicated working directory for our projects called cs403. Where you put this directory is up to you.

Download this SQLite database, save it to your cs403 directory, and open it with the SQLite CLP.

sqlite project01.db

From the SQLite CLP prompt, execute the following:

SELECT COUNT(*) FROM countries;

And also:

.schema

To exit the SQLite CLP, enter .quit (or even just .q , isn't that charming).

Create a README file inside your cs403 directory that contains your name, a short description of what this directory is, and the installation location of sqlite on your machine (eg, "/usr/local/bin/sqlite" or "C:\Program Files\SQLite\bin").

An example README might look like this:

Tupac Shakur
This directory contains all my project materials for CSCI403 Database Management.
Spring 2012
SQLite is installed as: /usr/bin/sqlite3

Grading Criteria (15 pts)

Via Blackboard, submit the contents of your README file (copy and paste, do not attach) and the output of the SELECT statement and .schema command mentioned above.

This is due by midnight on Saturday, January 14.