RJLRef: $PH/06f522/asgnt3/SISschema_and_data.061010.txt
(symlink to  $PH/COOL-GEN/SISschema_and_data.061010.txt)

1. Schema definition:
---------------------
The two files :

        $PH/COOL-GEN/SISrev061011.{sch,ppt}

contain my proposed StudentInfoSystem schema
and my new ERDiagram for it.

The schema was adapted from

        $CASE/02f522/SISProj/rjl_test/SIS.sch

by renaming two tables (ST to CT and ET to EN)
and adding a few more fields for Candidate Key use.


The test metadata which defines table CK and 
the CK-->CA<--TA associations are TBD by you-all.
The test data which defines value lists for TT-->CK
input queries is also TBD by you.

SISrev061011.dat only pre-loads the test database
against which queries are made by your tests.
I have no idea whether the sample data is adequate
to glean queries from. More table rows may be needed.


2. Sample database content:
----------------------------
File $PH/COOL-GEN/SISrev061011.dat 
contains test data which you can pr_load to initialize
schooldb. I have revised it to conform to the 
revised schema. Please try it but check it if errors 
appear during loading. Note that two tables are empty 
(AD and CS). They are not needed for asgnt3.

Note the absence of spaces inside fields except the 
last column of a table.  Chgen's API does not 
check this and can't verify an extra column exists 
if you split one field, so it is important to avoid 
a value that splits a field. 

[tnn insted of cnn is allowed as the type of the 
last field of a schema table, to enable chgen to enforce
a requirement that only types in the last column 
may contain internal whitespace. This prevents 
pr_parse from deriving  the actual field = column count,  
but chgen does not yet enforce that.]