IFS 106 Homework #2
Queries
Due Wed Sep 20, 2006
Complete the following database exercises. Please save your
database files on the k: drive in your homework folder (see
"Logistics" section below):
| Database |
Instructions |
| Babbage Bookkeeping |
ITL 2 (page 59)... start/import with
the web page in my data disk:
04_Babbage.htm |
| Dog Walkers |
C&P 1 (page 63)... start/import with
the Word file in my data disk:
06_DogWalkers.doc |
| Regional Books |
C&P 3 (page 63)... start/import with
the XML file in my data disk:
08_RegionalBooks.xml |
| Campus Housing |
C&P 4 (page 64)... start/import with
the text file in my data disk:
CampusHousing.txt |
On to Chapter 2 "Queries"... start with your homework #1 DB's and
complete the following exercises:
| Database |
Instructions |
| Ashton James College |
Chapter 2 (pages 66-106)... follow
along with the chapter in your own DB |
| Begon Pest Control |
AYK 1 (page 109) |
| Birds2U |
ITL 1 (page 109) |
| City Guide |
ITL 3 (page 111) |
| InPerson Fitness |
C&P 2 (page 112) |
I recommend copying your DB files from homework #1 into a new
folder (called homework2?) and starting from there.
query... yow, bill |