Copyright © T. H. Merrett
COMP 612 Principles of Database Programming Week 1
The Ad-hoc Cars Database
DATA FILE NO. RECD. FORM CONTENT
_____________________________________________________________________________
owner 885 char[40] name
char[33] address
char[7] phone
makes 101 char[40] model/company
colour 1 [20]char[10] colour
years 1 [60]int year
regis 1000 char[6] licence no.
DIRECTORY NO. RECD. FORM CONTENT
_____________________________________________________________________________
ownptr 3 [885]int -> owner
makptr 1 [2]int sizes
[119]{int -> makes
[3]int tree -> tree
int} kpos
dbptr 1000 int -> regis
int -> colour
int -> years
int -> makptr
int -> ownptr(0)
The file "owner" can be found on the teaching machines as
/course/cs612/carsdata/owner
and similarly for each of the other seven files.
Java programs to query: dbptr and
makptr.