COOKIE ASSIGNMENT (UNGRADED)

Complete by March 21, 2005 09:00 a.m.

Note: Cookie and DiveShop (coming soon) assignments aim to teach you how to use Microsoft Access database management system. These assignments will also prepare you for the first midterm scheduled on March 21, 2005. You are not required to turn in these two assignments officially. Yet questions in the midterm will be similar to the ones given here. Follow the instructions, download the Cookie and DiveShop databases and try to answer questions using MS Access available in the Computer Lab. Teaching assistants (Yurdagül Ünal or İrem Soydal) and myself are prepared to answer your questions regarding Cookie and the subsequent DiveShop assignments.

If you wish to complete your Cookie and DiveShop assignments on your personal computer, you can do so. Make sure you have MS Access available on your PC and download the Cookie and DiveShop databases from the course web site by following the instructions given below.

Before you start, please ask the teaching assistants (TAs) for login id and password to get access to your own folder (subdirectory) under "Network Neighborhood/bilgi/". Folders are ordered according to your student numbers.

If not already created, please create a path under the C: drive in the form of C:/MSOFFICE/ACCESS/COOKIE. To do this, go to the C: drive. Under the "File" menu of Windows Explorer, pick "New" option. A new option should appear with a folder icon named "Folder". Click on it. You will be asked to give a name to this folder. Name it as "MSOFFICE". Then, repeat the same steps given above to create subfolders under C:/MSOFFICE and C:/MSOFFICE/ACCESS, respectively. Needless to say, folder names should be "ACCESS" and "COOKIE" in the second and third steps, respectively.

Then, go to the course web site and download the Cookie2005.zip file and copy it under your own directory. The Cookie2000.mdb file that you use to answer queries is located in the compressed Cookie2005.zip file. Here are the instructions to download this file. Go to the course web site (http://yunus.hacettepe.edu.tr/~tonta/courses/spring2005/dok322/. Double click on the file name called Cookie2005.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/bilgi/<yourfolder>. You will be asked to enter your password in order to be able to download the file. Enter it. The file Cookie2005.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 "Cookie2000.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 Neighborhood/bilgi/, locate the file name "Cookie2005" 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 "Cookie2000.mdb".) This should start the MS Access 2000 program and open the named file. You are ready to complete your assignment.

Use the Cookie database to answer the following questions.

QUERIES

1. Who is the author of the CD-ROM in the Library? (CD-ROM in the Library adlı kitabın yazarı kimdir?)

2. Find the publisher name and address of the book CD-ROM in the Library. (CD-ROM in the Library adlı kitabın yayıncısını ve adresini bulunuz.)

3. Which library or libraries own the book CD-ROM in the Library? (CD-ROM in the Library adlı kitap hangi kütüphanelerde vardır? )

4. Which subject headings are assigned to the book CD-ROM in the Library? (CD-ROM in the Library adlı kitaba hangi konu başlıkları verilmiştir?)

5. List the authors and titles of books owned by the Moffitt Library on the subject of "Education" and published by "Dell Publishing" along with their call numbers. (Moffitt Kütüphanesinin sahip olduğu “Eğitim” (Education) konu başlıklı ve “Dell Publishing” yayınevi tarafından yayımlanmış olan kitapların yazarlarını ve eseadlarını yer numaralarıyla birlikte listeleyiniz. )

6. List all the books owned by the Berkeley Public Library and its branches along with their call numbers, prices, and number of copies. (Berkeley Halk Kütüphanesinin ve şubelerinin sahip olduğu tüm kitapları yer numaraları, fiyatları ve kopya sayılarıyla birlikte listeleyiniz. )

7. List the duplicate books owned by all libraries that cost more than 10 dollars in descending order by price. (Tüm kütüphanelerdeki fiyatı 10 dolardan daha fazla olan duplike kitapları en pahalısından en ucuzuna doğru listeleyiniz.)

8. How many books do all libraries own? (Tüm kütüphanelerde kaç kitap bulunmaktadır?)

9. How much would it cost to replace all the books owned by all libraries? (Tüm kütüphanelerin sahip olduğu kitapların toplam fiyatı ne kadardır?)

10. What are the subject headings assigned to the book authored by Veysey and owned by the Library of Congress? (Kongre Kütüphanesindeki Veysey tarafından yazılan kitaba hangi konu başlıkları verilmiştir?)

Think of at least three questions that can be solved by using the Cookie database. Use at least three tables. Formulate and execute them.

ANSWERS FOR COOKIE ASSIGNMENT

Yaşar Tonta

tonta@hacettepe.edu.tr

Last updated: February 28, 2005