http://yunus.hacettepe.edu.tr/~tonta/courses/spring2002/dok322/d322cookie-queries.htm/


Hacettepe University Department of Information Management
DOK 322 Database Management Systems (Spring 2003) Yaþar Tonta

COOKIE QUERIES

NOTE: The procedure of downloading the Cookie and Northwind files is explained at the beginning of the Northwind assignment. Please refer to it. 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 second and third steps, respectively.

1.      Who wrote Microcosmographia Academica?

2.      How many pages long is Alfred Whitehead’s The Aims of Education and Other Essays?

3.      Which branches in Berkeley’s public library system are open on Sunday?

4.      What is the call number of Moffitt Library’s copy of Abraham Flexner’s book Universities: American, English, German?

5.      What books on the subject of higher education are among the holdings of Berkeley libraries?

6.      Print a list of the Mechanics Library holdings, in descending order by height.

7.      What would it cost to replace every copy of each book that contains illustrations (including graphs, maps, portraits, etc.)?  (Here, you can use a formula in the form of "Sum(price*copies)" to find the cost.)

8.      Which library closes earliest on Friday night?

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

Yaþar Tonta
tonta@hacettepe.edu.tr
Last updated: Feb 24, 2003