User guide

Sample Data Base
C–2 058058 Tandem Computers Incorporated
Figure C-1. Diagram of Sample Relational Data Base
ordernum
orderdate
deldate
salesman
custnum
ORDER ENTRY RECORDS
ORDER
RECORD
custnum
custname
address
city
state
CUSTOMER
RECORD
partnum
suppnum
partcost
FROMSUP
RECORD
ordernum
partnum
quantity
ODETAIL
RECORD
partnum
partname
inventory
location
price
PARTS
RECORD
suppnum
suppname
address
city
state
SUPPLIER
RECORD
regnum
regname
location
manager
EMPLOYEE RECORDS
REGION
RECORD
regnum
branchnum
branchname
manager
BRANCH
RECORD
empnum
empname
regnum
branchnum
job
age
salary
vacation
EMPLOYEE
RECORD