***************************************************** CPE 365 Alex Dekhtyar Cal Poly Computer Science Department San Luis Obispo College of Engineering California dekhtyar@csc.calpoly.edu ***************************************************** STUDENTS DATASET Version 1.0 October 1, 2007 ***************************************************** Sources: this is a synthesized dataset. ****************************************************** This file describes the contents of the STUDENTS dataset developed for the CPE 365, Introduction to Databases, course at Cal Poly. The dataset contains information about students of a small elementary school. Each student goes to a specific classroom and a specific grade. A teacher is assigned to each classroom. 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: - list.csv : list of students - teachers.csv : list of teachers Individual files have the following formats. ************************************************************************** list.csv LastName : last name of the student FirstName : first name of the student Grade : grade the student attends Classroom : classroom the student is assigned to ************************************************************************** teachers.csv LastName : last name of the teacher FirstName : first name of the teacher Classroom : classroom the teacher is assigned to ************************************************************************** ************************************************************************** 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. ************************************************************************** **************************************************************************