SQL/MX 2.x Reference Manual (H06.04+)

Sample Database
HP NonStop SQL/MX Reference Manual—540440-003
D-2
Sample Database Entity-Relationship Diagram
Sample Database Entity-Relationship Diagram
Figure D-1 shows the names of columns and tables and the relationships between the
tables in the sample database.
Figure D-1. Sample Database Tables
empnum
first_name
last_name
deptnum
jobcode
salary
custnum
custname
street
city
state
postcode
credit
suppnum
suppname
street
city
state
postcode
deptnum
deptname
manager
rptdept
location
ordernum
order_date
deliv_date
salesrep
custnum
PERSNL Schema
SALES Schema
INVENT Schema
EMPLOYEE Table
CUSTOMER Table
SUPPLIER Table
DEPT Table ORDERS Table
JOB Table
ODETAIL Table PARTSUPP Table
PARTLOC TablePARTS Table
PROJECT Table
ordernum
partnum
unit_price
qty_ordered
partnum
partdesc
price
qty_available
loc_code
partnum
qty_on_hand
partnum
suppnum
partcost
qty_received
jobcode
jobdesc
projcode
empnum
projdesc
start_date
ship_timestamp
est_complete
Legend
One to one
One to many
VST002.vsd