Sybase DC38133-01-0902-01 manual Adaptive Server Anywhere sample database, Asademo.db

The Adaptive Server Anywhere sample database

Many of the examples throughout the documentation use the Adaptive

Server Anywhere sample database.

The sample database is held in a file named asademo.db, and is located in your SQL Anywhere directory.

The sample database represents a small company. It contains internal information about the company (employees, departments, and finances) as well as product information and sales information (sales orders, customers, and contacts). All information in the database is fictional.

The following figure shows the tables in the sample database and how they relate to each other.

asademo.db

product

id	integer	<pk>
name	char(15)
description	char(30)
size	char(18)
color	char(6)
quantity	integer
unit_price	numeric (15,2)
	customer
id	integer	<pk>
fname	char(15)
lname	char(20)
address	char(35)
city	char(20)
state	char(2)
zip	char(10)
phone	char(20)
company_name char(35)
	contact
id	integer	<pk>
last_name	char(15)
first_name	char(15)
title	char(2)
street	char(30)
city	char(20)
state	char(2)
zip	char(5)
phone	char(10)
fax	char(10)

sales_order_items

Employee

id

integer

<pk,fk>

emp_id

integer

<pk>

line_id

smallint

<pk>

manager_id

integer

prod_id

integer

<fk>

emp_fname

char(20)

quantity

integer

id = prod_id

emp_lname

char(20)

ship_date

date

dept_id

integer

<fk>

street

char(40)

emp_id = sales_rep

city

char(20)

id = id

state

char(4)

zip_code

char(9)

phone

char(10)

sales_order

status

char(1)

ss_number

char(11)

id

integer

<pk>

salary

numeric(20,3)

cust_id

integer

<fk>

start_date

date

order_date

date

termination_date

date

fin_code_id

char(2)

<fk>

birth_date

date

id = cust_id

region

char(7)

bene_health_ins

char(1)

sales_rep

integer

<fk>

bene_life_ins

char(1)

bene_day_care

char(1)

sex

char(1)

code = fin_code_id

fin_code

dept_id = dept_id

code

char(2)

<pk>

type

char(10)

emp_id = dept_head_id

description

char(50)

code = code

department

fin_data

dept_id

integer

<pk>

dept_name

char(40)

year

char(4)

<pk>

dept_head_id

integer

<fk>

quarter

char(2)

<pk>

code

char(2)

<pk,fk>

amount

numeric(9)

xv