top - download
⟦ef12c07aa⟧ Wang Wps File
Length: 1240 (0x4d8)
Types: Wang Wps File
Notes: Spelunked
Names: »~ORPHAN45.03«
Derivation
└─⟦550b0bab9⟧ Bits:30006219 8" Wang WCS floppy, CR 0276A
└─ ⟦this⟧ »~ORPHAN45.03«
WangText
2. Please illustrate how the following queries
would be coded in the system that you are proposing.
Include simulation of any necessary file or
data specification statements and ssume that
the response will be directed back to the inquirer's
Video Display Unit (VDU).
a. List all non-high school gruduates in Division
123 showing name, rank, serial number,
years of service, and unit.
It is assumed that airman and offcer data all
are placed in one relation named "PERSONNEL"
with the data elements shown in RFP figure
C-11, and C-12 and that
o non-high school graduates means ED-LVL
B
o division 123 means ORG-DET-NO = 123
o name means NAME
o rank mens the abbreviation from nomenclature
table in RFP figure C-23 identified by
GR-CURR
o serial number means SSAN
o years of service means 82-(year of ADSCD
(name of ADSCY))
o unit means ORG-NR
The conversion from GR-CURR to RANK is madeby
a table lookup in the relation NOMENCLATURE
with GR-CURR as key and RANK as target data.
The query will then be phrased
RANGE OF N IS NOMENCLATURE
RANGE OF P IS PERSONNEL
SHOW (P.NAME, N.RACK, P.SSAN, AGE = (82-P.ADSCY),
P.ORG-NR)
