Practise with basic SQL using SQLite
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:
From the toolbar select
Database > Import
Select the files you just downloaded. You can select the file using
Select File button.
Please insert the data type for each column
according to the following figure:
Try to find the correct SQL statement for each of the following Queries:
SELECT bdate, address FROM employee WHERE lname = 'King'
SELECT fname, lname FROM employee WHERE minit = 'A'
SELECT dname, fname, lname FROM employee, department WHERE ssn=mgrssn
Hint: a married employee should have a spouse
SELECT fname, lname FROM employee, dependent WHERE essn=ssn AND relationship=='Spouse'
SELECT dname, department.dnumber FROM department, dept_locations WHERE department.dnumber= dept_locations.dnumber AND dlocation='Houston'
Hint: you maight need to use
Please use the following button to submit your SQL statements