Sample Midterm for LBSC 690 (Fall 97) section 0201.

You may use and redistribute this sample exam for any purpose.

You have one hour and 15 minutes to complete this exam.  Answer every
question.  The maximum possible score on this exam is 100 (the
minimum possible score is -8).


1) [25 points] The HyperText Markup Language (HTML) can be viewed as a
programming language.  Explain this statement by identifying:

a) [10 points] The type of abstract machine HTML "programs" are
designed to run on.

b) [10 points] The types of applications for which HTML "programs" are
useful.

c) [5 points] Whether HTML is typically compiled, interpreted, or both.


2) [25 points] Create a spreadsheet to compute your grade on this exam
based on the number of points for each question or separately lettered
part of the question.  Identify the rows and columns in your
spreadsheet in the manner used by Quattro Pro (and most other
spreadsheets).  For each cell, specify the label, value or formula
that you will place in that cell.  You may use Quattro Pro's means of
identifying this if you like, but all that is required is that it is
clear which things you intend to be labals, which to be values, and
which to be formulas.


3) [24 points] Select the best answer each of the following multiple
choice questions.  Each correct answer is worth 6 points and each
incorrect answer COSTS 2 points.

a) [+6 or -2] The slowest type of memory in a typical personal
computer is:

  A) Cache
  B) Floppy disk
  C) Hard Disk
  D) RAM

b) [+6 or -2] The time required to transfer a 100 kilobyte .au sound
file using a 28.8 kilobit per second modem (assuming 10 bits per byte)
is:

  A) under 1 minute
  B) 5 minutes and 47 seconds
  C) 17 minutes and 2 seconds
  D) over 30 minutes

c) [+6 or -2] JPEG is:

  A) A losless commpression technique
  B) Often used for astronomical images
  C) Used to compress still photographic images
  D) All of the above

d) [+6 or -2] The File Transfer Program (FTP) can be used to:

  A) Transfer text files.
  B) Transfer spreadsheet files
  C) Limit access to files using password protection
  D) All of the above


4) [26 points] You are working with a database in a special library
that contains three tables with the following fields:

Table 1:  LastName, FirstName, OfficeCode, PhoneNumber, EmployeeNumber

Table 2:  ProfileSpecification, ProfileNumber

Table 3:  EmployeeNumber, ProfileSpecification

a) [6 points] State the condition(s) that must be satisfied by a field
before it can be chosen as a primary key for a table.

b) [20 points] Specify the project, restrict and join operations that
must be performed to construct the "Answer Table: shown below for
employees with office code "N35".  You may sketch the Paradox Query By
Example (QBE) script, give appropriate Structured Query Language (SQL)
code for the answer, or explain the necessary operations in English.

Answer Table:  LastName, FirstName, PhoneNumber, ProfileSpecification

--------------------------------------- End -------------------------