http://yunus.hacettepe.edu.tr/~tonta/courses/spring2000/dok322/d322dersamac2000.htm/

Hacettepe University Department of Information Management

DOK 322 Database Management Systems (Spring 2004) Yaşar Tonta

NORTHWIND HOMEWORK

Note: Please use the Northwind database to answer the following questions. Before you start, please ask the research assistant for login id and password to get access to your own folder (subdirectory) under "Network Neighborhood/Bby/dok322".  Folders are ordered according to your student numbers.  Then, go to the course web site and download the Northwind.zip file and copy it under your own directory.  The Northwind.mdb file that you use to answer queries is located in the compressed Northwind.zip file.  Here are the instructions to download this file.  Go to the course web site (http://yunus.hacettepe.edu.tr/~tonta/courses/spring2004/dok322/. Double click on the file name called Northwind.zip.  The download window should be opened and you will be asked to identify the folder under which you wish to copy the file.  The default folder is My Download Files.  Change it to "Network Neighborhood/bby/<yourfolder>.  You will be asked to enter your password in order to be able to download the file. Enter it. The file Northwind.zip will then be downloaded.  When download is completed, you will be asked if you wish to "Extract" the zipped file.  Say "yes" and "Extract" the file under the same folder.  When the process is complete, double click on the file named "Northwind.mdb".  (The procedure of downloading may vary. If you are not asked if you wish to exrtact the zipped file, then use the Windows Explorer to go to your folder under Network Neighboırhood/Bby/, locate the file name "Northwind" and double click on it. When the Winzip program starts, "Extract" the contents of the zipped file on to your folder. Then click on the file named "Northwind.mdb".) This should start the MS Access 2000 program and open the named file.  You are ready to complete your assignment.

Please note, the downloading process for the cookie2004.zip file is the same.  Use the same address given above and download the file.  Uncompress it and complete your Cookie assignment.   

The assignment is due 29 March, 2004.  

No late assigments shall be accepted.  

Both Nortwind and Cookie assignments shall be placed in  your own folder under Network Neighborhood/Bby/.  No other method of assignment submission (via e-mail or on floppy-diskettes) is acceptable.  

Please note that on March 29, 2004, your access to your directory will be blocked temporarily to grade your assignments. 

  QUERIES

1.      Find the names of all “sales representatives” who work in London.

2.   Find the name of the female "sales representative" who work in London and report to the Sales Manager Mr. Steven Buchanan. (Please do not enter any criterion under the "ReportsTo" field when answering this query.)

3.      Find the names and addresses of all the suppliers which can provide “tofu”.  (Note: You should be able to find two companies.)

4.      List the sales for orders shipped to France.

5.      Find the products on order from companies based in the UK.

6.      List all the orders taken by the sales representative Anne Dodsworth from the companies based in London along with the unit price and quantity of each order.

Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: Feb 26, 2004