TEST LOG NAMES:
Command messages __________
Table formatting __________
relcat, attrcat format __________
argc & argv ok __________
COMMAND
|
CORRECT RESULT
|
ACTUAL RESULT
|
prog1 mydb
|
create directory mydb with
|
|
|
relcat and attrcat
|
|
S
|
show default relcat (2 recs)
|
|
|
and attrcat (12 recs)
|
|
Q
|
quit
|
|
ls
|
relcat, 80 bytes;
|
|
|
attrcat, 672 bytes
|
|
|
|
|
prog1 mydb
|
change to mydb
|
|
S
|
show relcat (2) and attrcat (12)
|
|
C employee F C 20 name I id
|
create employee
|
|
S
|
show relcat (3) and
|
|
|
attrcat (14)
|
|
C student V C 20 name D gpa I id
|
create student
|
|
S
|
show relcat (4) and attrcat (17)
|
|
C parts V I id C 20 partname
|
create parts
|
|
S
|
show relcat (5) and attrcat (19)
|
|
C suppliers F I suppid I partid C 40 suppname C 80 address
|
create suppliers
|
|
S
|
show relcat (6) and attrcat (23)
|
|
C fred F I x1 I x2 I x3 I x4 I x5 I x6 I x7 I x8 I x9 I x10
|
create fred
|
|
S
|
show relcat (7) and attrcat (33)
|
|
Q
|
quit
|
|
ls
|
relcat, 280; attrcat, 1848;
|
|
|
employee, 0; parts, 0;
|
|
|
student, 0
|
|
|
|
|
prog1 mydb
|
change to mydb
|
|
S
|
show relcat (7) and
|
|
|
attrcat (33)
|
|
Q
|
quit
|
|
ls
|
same as above
|
| |