COOKIE ASSIGNMENT (UNGRADED)

Complete by March 20, 2006 09:00 a.m.

Note: Cookie assignment aims to teach you how to use Microsoft Access database management system. This assignment will also prepare you for the first midterm scheduled on March 20, 2005. You are not required to turn in this assignment officially. Yet questions in the midterm will be similar to the ones given here. Follow the instructions, download the Cookie database 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 assignment.

If you wish to complete your Cookie assignment on your personal computer, you can do so. Make sure you have MS Access available on your PC and download the Cookie database 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 Cookie2006.zip file and copy it under your own directory. The Cookie2000.mdb file that you use to answer queries is located in the compressed Cookie2006.zip file. Here are the instructions to download this file. Go to the course web site (http://yunus.hacettepe.edu.tr/~tonta/courses/spring2006/dok322/. Double click on the file name called Cookie2006.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 Cookie2006.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 "Cookie2006" 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 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 Megatrends? (Megatrends adlı kitabın yazarı kimdir?)

2. Find the publisher name and address of the book Megatrends. (Megatrends adlı kitabın yayıncısını ve adresini bulunuz.)

3. Which library or libraries own the book Megatrends? (Megatrends adlı kitap hangi kütüphanelerde vardır? )

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

5. List the authors and titles of books owned by the Stanford University Libraries on the subject of "Higher Education" and published by "Mcgraw-Hill Book Co" along with their call numbers. (Stanford Üniversitesi Kütüphanelerinin sahip olduğu “Yüksek Eğitim” (Higher Education) konu başlıklı ve “Mcgraw-Hill Book Co.” yayınevi tarafından yayımlanmış olan kitapların yazarlarını ve eseradlarını yer numaralarıyla birlikte listeleyiniz.)

6. List all the books owned by the San Francisco Public Library and its branches along with their call numbers, prices, and number of copies. (San Francisco 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? How much would it cost to replace all the books owned by all libraries? What is the average price of the books owned by all libraries (Tüm kütüphanelerde kaç kitap bulunmaktadır? Tüm kütüphanelerin sahip olduğu kitapların tüm kopyalarıyla birlikte toplam fiyatı ne kadardır? Kütüphanelerin sahip oldukları kitapların ortalama fiyatları nedir?)

9. 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 27, 2006