*****************************************************
CPE 365                                 Alex Dekhtyar
Cal Poly		  Computer Science Department
San Luis Obispo                College of Engineering 
California                   dekhtyar@csc.calpoly.edu   
*****************************************************
		   CSU DATASET
                   Version 1.0
                September 25, 2007
*****************************************************
Sources:
        California State University 
        Statistical Abstract 2004-2005
        http://www.calstate.edu/AS/abstract.shtml

        California State University 
        Statistical Reports
        http://www.calstate.edu/as/stats.shtml
******************************************************

This file describes the CSU dataset used in the CPE 365,
Introduction to Databases Class.

The dataset describes various information about the
California State University 23 campus system of higher
education.

General Conventions.

 1. All files in the dataset are CSV (comma-separated values) files.
 2. First line of each file provides the names of
    columns. Second line may be empty, or may contain
    the first row of the data
 3. All string values are enclosed in single quotes (')

The dataset consists of the following files:

 - Campuses.csv   - list of CSU campuses with some general information
 - csu-fees.csv   - historic information about student fees charged
                    by different campuses
 - degrees.csv    - historic information about the number of undergraduate
                    degrees conferred by campuses
 - discipline-enrollments.csv - information about enrollments by 
	            discipline at each campus in 2004-2005 AY.
 - disciplines.csv - list of disciplines taught at CSU
 - enrollments.csv - historic information about the number of students
                     enrolled at each campus
 - faculty.csv     - historic information about the number of full-time
                     faculty equivalents at each campus

Detailed descriptions of each file format are given below.

************************************************************************

Campuses.csv

   Id, Campus, Location, County, Year

       Id : unique identifier for each campus
   Campus : the name of each campus (e.g., "Sonoma State University")
 Location : city/town where the campus is located
   County : county where the campus is located
     Year : year the campus opened (not necessarily as part of CSU)

************************************************************************
 
csu-fees.csv

    Campus, Year, CampusFee

   Campus  : unique identifier of campus (see Campuses.Id)
     Year  : academic year
 CampusFee : student fee assessed by campus (not full tuition)


************************************************************************
 
degrees.csv
 
     Year, Campus, Degrees
        
      Year : academic year
    Campus : unique identifier of campus (see Campuses.Id)
   Degrees : number of undergraduate degrees conferred


************************************************************************
 
discipline-enrollments.csv

      Campus, Discipline, Year, Undergraduate, Graduate

       Campus : unique identifier of campus (see Campuses.Id)  
   Discipline : unique identifier of the academic discipline
               (see disciplines.Id)
         Year : academic year
Undergraduate : undergraduate enrollment
     Graduate : graduate enrollment

************************************************************************

disciplines.csv

    Id, Name

         Id : unique identifier of the academic discipline
       Name : name of the discipline (e.g., "Engineering")


************************************************************************

enrollments.csv

      Campus, Year, TotalEnrollment_AY, FTE_AY

    
            Campus : unique identifier of campus (see Campuses.Id) 
              Year : academic year
TotalEnrollment_AY : total number of students enrolled during given 
                     academic year
            FTE_AY : number of full-time equivalent students enrolled
                     during academic year

*************************************************************************


faculty.csv

       Campus, Year, Faculty

        
	 Campus : unique identifier of campus (see Campuses.Id)              
           Year : academic year
        Faculty : number of full-time equivalent faculty lines


**************************************************************************
**************************************************************************

Permission granted to use and distribute this dataset in its current form, 
provided this file  is kept unchanged and is distributed together with the 
data.

Permission granted to modify and expand this dataset, provided this
file is updated accordingly with new information.

**************************************************************************
**************************************************************************