CSc 4710/6710 (Spring 2008) HW7

CSc 4710/6710, Database Systems
Spring 2008
Homework 7 (Due: 7 April, 2008 - Monday)

Repeat Homework 2 Queries in Datalog. You must use the Datalog interpreter that is available as part of the aql.jar package(s). Here is a sample usage of the Datalog interpreter on tinman server (Note: Each query is stored in a separate file and executed :

[~][11:29am] more c1
answer(F,M,L) :- 
  employee(F,M,L,S,_,_,_,_,_,5),
  works_on(S,P,H),
  projects('ProductX',P,_,_),
  H >= 10.0.
$
[~][11:29am] java edu.gsu.cs.dlg.DLOG company
type "help;" for usage...
Message: Database Provided: Database Directory is ./company
DLOG> @c1;
------------------------------------
answer(F,M,L) :- 
  employee(F,M,L,S,_,_,_,_,_,5),
  works_on(S,P,H),
  projects('ProductX',P,_,_),
  H >= 10.0.
$
------------------------------------
ANSWER(F:VARCHAR,M:VARCHAR,L:VARCHAR)

Number of tuples = 2
John:B:Smith:
Joyce:A:English:

DLOG> exit;
Exiting...
[~][11:29am]

To submit, please name the query files ca,cb,cc, etc for company database queries and ma,mb,mc, etc for mailorder database queries. Also please zip or tar all the files into one file called hw7.zip or hw7.tar before submitting hw7.zip or hw7.tar electronically.

Page Maintained by raj@cs.gsu.edu