It
is important to note your assumptions so that you can explain
your results.
Determine
how the conditions of the question relate to data fields in
a table
The data request will likely be English text -- you must translate
this to the appropriate database field values. For example if
you were asked for a list of Chinese/Chinese Americans you would
need to look for ethnic_codes which were = 2. You may have to
query a lookup table (ethnic_codes in this case) to determine
such values.
This
step may require considerable familiarity with the database
and with UCSD codes and rules. Don't hesitate to verify with
an experienced co-worker that you are interpreting the codes
or fields correctly.
Extract
data
Apply the conditions you have decided are appropriate and run
the query.
Sanity
- check the results
Look at the results carefully and verify that they are within
reason. For example a query listing current Biological Sciences AP&S
employees with 546 names on the list is obviously in error.
Note
any assumptions you have made
If you have made any assumptions, note them in the output or
in a cover letter or email.
Format
output if necessary
If the requester requires fancy printing or a data file format,
tranlate the results into the required format.