IS371 Lab 2

Practise with basic SQL using SQLite

Getting Started

Make sure you have correctly installed SQLite add-on on your machine. A description is found here.


Create a directory on your machine for holding the IS371 lab session files, say C:\IS371 or similar. Then download this zip file and unpack it in that directory. This should create a subdirectory IS371_lab1 containing six files.

Open SQLite GUI:

SQLite

Uploading tables

From the toolbar select Database > Import Select the files you just downloaded. You can select the file using Select File button.


Very Important! You should Tick the option "First row contains column names".
This is in order to have the coulumn names correctly set.

SQLite_Alert
Select OK button.


SQLite_Alert
Select OK button.


Please insert the data type for each column
SQLite_Alert

according to the following figure:

SQLite_Alert
Select OK button.



Success! You should repeat this process untill you have all 6 tables successfully uploaded.

SQLite_Alert

Queries

Try to find the correct SQL statement for each of the following Queries:

  1. Retrieve the birthdate and address of the employee(s) whose last name is king













Please use the following button to submit your SQL statements