***************************************************** CPE 365 Alex Dekhtyar Cal Poly Computer Science Department San Luis Obispo College of Engineering California dekhtyar@csc.calpoly.edu ***************************************************** BAKERY DATASET Version 1.0 October 1, 2007 ***************************************************** Sources: this is a synthesized dataset. ****************************************************** This file describes the contents of the BAKERY dataset developed for the CPE 365, Introduction to Databases, course at Cal Poly. The dataset contains information about one month worth of sales information for a small bakery shop. The sales are made to known customers. The dataset contains information about the customers, the assortments of baked goods offered for sale and the purchases made. 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: - customers.csv : information about the bakery's customers - goods.csv : information about the baked goods offered for sale by the bakery - items.csv : itemized reciept infromation for purchases - reciepts.csv : general reciept information for purchases reciepts.csv stores information about individual reciepts (purchases by customers). Each purchase may contain from one two five items, regardless of whether any items purchased are of the same kind (e.g., two "chocolate cakes" will be billed as two separate items on the reciept). items.csv contains itemized reciept information. Individual files have the following formats. ************************************************************************** customers.csv Id: unique identifier of the customer LastName: last name of the customer FirstName: first name of the customer ************************************************************************** goods.csv Id : unique identifier of the baked good Flavor: flavor/type of the good (e.g., "chocolate", "lemon") Food: category of the good (e.g., "cake", "tart") Price: price (in dollars) ************************************************************************** items.csv Reciept : reciept number (see reciepts.RecieptNumber) Ordinal : position of the purchased item on the reciepts. (i.e., first purchased item, second purchased item, etc...) Item : identifier of the item purchased (see goods.Id) ************************************************************************** reciepts.csv RecieptNumber : unique identifier of the reciept Date : date of the purchase. The date is in DD-Mon-YYY format, which is the default Oracle's format for DATE data type. CustomerId : id of the customer (see customers.Id) ************************************************************************** ************************************************************************** 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. ************************************************************************** **************************************************************************