| Notes | The State of Florida has been collecting individual student, staff, finance and facilities information from its constituent universities since the mid 1970’s as snapshots in time. The development of the State University Database System (SUDS) will convert the existing flat file fixed field records into a state of the art relational database system. Legacy data will be loaded into the new system going back to the 1991-92 academic year. It is a requirement that reports from the new system create the same results as those generated in days gone by, though not necessarily in the same format.
Each entity in the SUDS database has a unique primary key that is a number generated from a Sequence. We have also opted to maintain a logical unique composite key (LUCK) in each entity that will allow joins between entities that are not directly linked via a primary key/foreign key relationship. Each entity also contains one or more columns reserved for university use. The number of such columns is a direct result of the space allotted in the legacy system.
|