Purdue Instructional Labs maintain about 2000 Samba or nfs clients (PCs, MACs, and SUNs) at 90 different locations on campus. Three Solaris servers store the software that runs on the local machines. The servers mirror one another and do load sharing. Installed software is keyed and managed by Sassafras KeyServer software. Instructional labs personnel need reliable information about what is stored on the servers, how things are keyed, and the progress of various installation tasks. Ultimately they would like to provide convenient web-based information to instructional lab users and other icd staff about what software can be used where - and what software is available in the instructional labs. I helped lead an analysis of what this application should look like. From several meetings with icd staff I evolved the dataflow diagrams and entity relationship diagram which you see below. After that I developed the system in Microsoft Access making use of forms, subforms, scripts and SQL queries.
In case you arrived here through the back door ...
