$PH\COOL-GEN\schooldbInfo061010.txt $PH/06f522/asgnt3 focus is $CASE/02f522/SISProj/rjl_test/* -------------------------------------------------------- saturn.cs.uml.edu(68)> find $CASE -name school??.sch find: No match. saturn.cs.uml.edu(69)> find $CASE -name schooldb.sch /usr/proj3/case/02f522/genjavaProj/ntrivedi/code/test/schooldb.sch /usr/proj3/case/02f522/genjavaProj/ntrivedi/code/Test1/schooldb.sch /usr/proj3/case/02f522/genjavaProj/avasanth/Code/test/schooldb.sch find: /usr/proj3/case/02f522/JPsimProj_js_tk: Permission denied find: /usr/proj3/case/gen/ver_13/chgen/obj/alpha/CVS: Permission denied /usr/proj3/case/gen/ver_13/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/gen/ver_13/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/gen/ver_12/lechner/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/gen/ver_12/lechner/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/gen/ver_8/test/schooldb12/schooldb.sch /usr/proj3/case/gen/ver_8/test/schooldb8/schooldb.sch /usr/proj3/case/gen/ver_8/test/alpha/schooldb.sch /usr/proj3/case/gen/ver_11/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/gen/ver_11/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/gen/ver_10/chgen/schooldbtest/schooldb.sch /usr/proj3/case/gen/ver_10log/executables/alpha/schooldb.sch /usr/proj3/case/gen/ver_10log/test/schooldb.sch /usr/proj3/case/gen/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/gen/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_8/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_8/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_9/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_9/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10log/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10log/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10dflt/test/alpha/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10dflt/test/gendft/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10dflt/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/asabnis/ver_10dflt/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_9/base/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_9/base/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_8/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_8/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_8/test/alpha/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_8/test/gendft/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/test/schooldb12/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/test/schooldb8/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_10log/Test/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_10log/executables/alpha/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_8test/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_10test/schooldb.sch /usr/proj3/case/gen/genmerge/mampatel/ver_9test/schooldb.sch /usr/proj3/case/95s523/genv10/cwu/test/schooldb.sch /usr/proj3/case/95s523/genv10/cko/test1/schooldb.sch /usr/proj3/case/97f522/toolProjects980927/genlog/ver_10log/executables/schooldb.sch /usr/proj3/case/97f522/toolProjects980927/genlog/ver_10log/executables/alpha/schooldb.sch /usr/proj3/case/97f522/toolProjects980927/genlog/ver_10log/executables/decstation/schooldb.sch /usr/proj3/case/97f522/toolProjects980927/genlog/ver_10log/schooldb/schooldb.sch /usr/proj3/case/96s523/bdesym/rcostell/macro.test/schooldb.sch /usr/proj3/case/96s523/bdesym/rcostell/chgen.test/schooldb.sch /usr/proj3/case/96s523/bdesym/rcostell/instructions.test/schooldb.sch /usr/proj3/case/96s523/bdesym/rcostell/macro.test.2/schooldb.sch /usr/proj3/case/96f522/rwright/TraceLog/schooldb/schooldb.sch find: /usr/proj3/case/97s523/bde2gif: Permission denied /usr/proj3/case/98f/genmerge/palee/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/98f/genmerge/palee/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/99s523/yxu/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/99s523/yxu/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/99s523/zlu/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/99s523/zlu/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/test/schooldb/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb/chgenv11/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb/chgenv10/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb/chgenv11-dat/schooldb.sch /usr/proj3/case/99s523/genmerge/chgenv11/chgen/test/schooldb/schooldb.dir/schooldb.sch /usr/proj3/case/bdelog2ks/ntansala/gencpp/test/Log_Replay_GENCPP/schooldb.sch /usr/proj3/case/bdelog2ks/ntansala/gencpp/test/CHGEN_GENCPP/GENCPP/schooldb.sch /usr/proj3/case/bdelog2ks/ntansala/gencpp/test/CHGEN_GENCPP/CHGEN11/schooldb.sch /usr/proj3/case/bdelog2ks/ntansala/gencpp/test/CHGEN_GENCPP/CHGEN11/test-log/schooldb.sch /usr/proj3/case/2kf522/gencpp2kf/mottesen/genjava/public_html/test/schooldb/schooldb.sch /usr/proj3/case/03f522/bdegencpp03f/fyang/bdegencpp/gencpptest3/schooldb.sch /usr/proj3/case/04f522/lechner/bdegen13/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lechner/bdegen13/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/lechner/genv13Notag/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lechner/genv13Notag/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/lechner/genv13SBLMMM_Final/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lechner/genv13SBLMMM_Final/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/lechner/genTtag01f522/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lechner/genTtag01f522/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/ngross/chgen/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/ngross/chgen/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/sboddire/ProjectNoTag/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/sboddire/ProjectNoTag/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/sboddire/backup/projectNoTag/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/sboddire/backup/projectNoTag/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/hjha/final/bdegen13/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/hjha/final/bdegen13/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/hjha/final/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/hjha/final/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/lmalladi/new/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lmalladi/new/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/lmalladi/CHGEN13/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lmalladi/CHGEN13/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/04f522/lmalladi/FinalProject/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/04f522/lmalladi/FinalProject/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/bdegen13/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/bdegen13/chgen/test/schooldb8/schooldb.sch /usr/proj3/case/05f523/smandava/genjava/mydb/schooldb.sch /usr/proj3/case/05f523/smandava/genjava/school_test/schooldb.sch /usr/proj3/case/05f523/lechner/chgen/test/schooldb12/schooldb.sch /usr/proj3/case/05f523/lechner/chgen/test/schooldb8/schooldb.sch saturn.cs.uml.edu(70)> saturn.cs.uml.edu(131)> pwd /tmp_mnt/nfs/galaxy/misc/proj3/case/05f523/lechner/chgen/test saturn.cs.uml.edu(132)> lg $CASE/05f523/lechner/chgen/test/schooldb*/schooldb.sch -rwxr-xr-- 1 lechner 05f523 1162 Jun 22 1996 /usr/proj3/case/05f523/lechner/chgen/test/schooldb12/schooldb.sch -rwxr-xr-- 1 lechner 05f523 1087 Jun 22 1996 /usr/proj3/case/05f523/lechner/chgen/test/schooldb8/schooldb.sch saturn.cs.uml.edu(71)> find $CASE -name schoolDB.sch find: /usr/proj3/case/02f522/JPsimProj_js_tk: Permission denied find: /usr/proj3/case/gen/ver_13/chgen/obj/alpha/CVS: Permission denied find: /usr/proj3/case/97s523/bde2gif: Permission denied saturn.cs.uml.edu(72)> =================================== saturn.cs.uml.edu(160)> pwd /tmp_mnt/nfs/galaxy/misc/proj3/case/02f522/SISProj/rjl_test saturn.cs.uml.edu(161)> lg $CASE/02f522/SISProj/rjl_test/SIS.dat -rw-r--r-- 1 lechner fac 1594 Jan 16 2003 /usr/proj3/case/02f522/SISProj/rjl_test/SIS.dat saturn.cs.uml.edu(162)> ---------------------------- AA040001 DE040001 DOE,John 3.00 AA040002 DE040002 RUBBLE,Barney 3.50 AA040003 DE040003 JONES,Susan 2.00 AA040004 DE040003 JONES,David 4.00 DE040001 MATHEMATICS DE040002 PHYSICS DE040003 COMPUTER SCIENCES TM040001 FALL 1997 TM040002 SPRING 1998 TM040003 FALL 1998 FY040001 DE040001 Prof. JOHNSON FY040002 DE040002 Prof. TURING FY040003 DE040003 Prof. MAYHEM FY040004 DE040004 Prof. SMITH CO040001 DE040001 CALCULUS I CO040003 DE040003 ALGORITHMS CO040004 DE040003 COMPUTING I CO040011 DE040003 UNDG ALGORITHM RT040001 AA040001 TM040001 4 0 300 RT040002 AA040003 TM040001 3 0 250 RT040003 AA040001 TM040002 3 0 300 RT040004 AA040004 TM040001 9 0 200 ST040001 TM040001 FY040001 CO040001 30 5 15 ST040003 TM040001 FY040003 CO040003 30 5 20 ST040004 TM040001 FY040004 CO040004 30 5 30 ST040005 TM040002 FY040003 CO040011 30 5 30 ET040001 RT040001 ST040001 4.0 A ET040002 RT040002 ST040003 3.0 AB ET040003 RT040002 ST040001 3.0 I/B ET040004 RT040004 ST040001 3.0 C ET040005 RT040004 ST040003 3.0 A ET040006 RT040004 ST040004 3.0 I/F ET040007 RT040003 ST040005 3.0 B PQ040001 CO040003 CO040011 ~ -------------------------------------------------------- saturn.cs.uml.edu(164)> cat SIS.vdf define_view DefaultView write view_element DefaultView AA 0 view_element DefaultView DE 0 view_element DefaultView TM 0 view_element DefaultView FY 0 view_element DefaultView CO 0 view_element DefaultView RT 0 view_element DefaultView ST 0 view_element DefaultView ET 0 view_element DefaultView PQ 0 view_element DefaultView CS 0 saturn.cs.uml.edu(165)> ------------------------------------ saturn.cs.uml.edu(165)> cat SIS.sch Student AA /* Student Attribute Table */ { AAid NodeID c8 1 /* Student ID Primary Key */ DEid DepartmentDEidID c8 1 /*Created via linked parent*/ AAsnm AAsnm c32 0 /* Student Name */ AAgpa AAgpa f4 0 /* Acumulate GPA,was f5 */ } Department DE /* Department Table */ { DEid NodeID c8 1 /* dEPARtment ID Primary Key */ DEhead DEhead c30 0 /* Department Name */ } Term TM /* Term or Semester Table */ { TMid NodeID c8 1 /* Semester ID Primary Key */ TMname TMName c15 0 /* Sem. Name, was NodeID c8 */ } Faculty FY /* Faculty Table */ { FYid NodeID c8 1 /* Faculty ID Primary Key */ DEid DepartmentDEidID c8 1 /*Created via linked parent*/ FYnm FYnm c32 0 /* Faculty Name */ } Course CO /* Course Table */ { COid NodeID c8 1 /* Course ID Primary Key */ DEid DepartmentDEidID c8 1 /*Created via linked parent*/ COtit COtit c24 0 /* Course Title */ } Address AD /* Student Addresse Table, was AA-AD */ { ADid NodeID c8 1 /* Address ID Primary Key*/ AAid StudentID c8 1 /*Created via linked parent */ ADstree ADstree c30 0 /* Number & Street */ ADcity ADcity c13 0 /* City */ ADstat ADstat c2 0 /* State */ ADzip ADzip c9 0 /* Zip Code */ ADctry ADctry c2 0 /* Country */ } StudentTer RT /* Student- Term Table */ { RTid NodeID c8 1 /* Student-term ID Primary Key*/ AAid StudentID c8 1 /*Created via linked parent */ TMid TermID c8 1 /*Created via linked parent */ RTattem RTattem i2 0 /* credits attempted*/ RTearne RTearne i2 0 /* credits earned */ RTgpa RTgpa f4 0 /* Current GPA */ } StudTermSe ST /* Student-Term-Section Table*/ { STid NodeID c8 1 /* StudTermSe ID Primary Key*/ TMid TermID c8 1 /*Created via linked parent */ FYid FacultyID c8 1 /*Created via linked parent */ COid CourseID c8 1 /*Created via linked parent*/ STmax STmax i4 0 /* Maximum Enrollment */ STmin STmin i4 0 /* Minimum Enrollment */ STcur STcur i4 0 /* Current Enrollment */ STstatu STstatu c1 0 /* section status */ } PreReqLinK PQ /* Prerequisite Table */ { PQid NodeID c8 1 /* PreReqlink ID Primary Key*/ COid1 CourseID c8 1 /*Created via linked parent*/ COid2 PQcourseID c8 1 /* pre-requisite course ID */ } Enrollment ET /* Enrollment Table, was RTSP */ { ETid NodeID c8 1 /* Enrollment ID Primary Key*/ RTid StudentTerRTidID c8 1 /*Created via linked parent */ STid StudTermSeSTidID c8 1 /*Created via linked parent */ SPcred SPcred i4 0 /* Credits */ SPgrad SPgrad c3 0 /* Grade*/ } CourseSche CS /* Course-Schedule Term, was STSD*/ { CSid NodeID c8 1 /*Course- Sched ID Primary Key*/ STid StudTermSeSTidID c8 1 /*Created via linked parent */ SDdays SDdays c3 0 /* Lecture Day like MWF */ SDtime SDtime c6 0 /* Lecture Time like 430PM */ SDbldg SDbldg c3 0 /* Building */ SDroom SDroom c3 0 /* Room */ } -------------------------------