LBSC 690 Section 0201 Midterm Exam                                                              March 20, 1997

Read each question carefully.  The maximum possible score on this exam is 100 and the minimum possible score is -8.  You may use your own personal copy of Oakman (including any notes made in your own handwriting), an electronic calculator, and the Excel, Access, FTP, telnet and calculator software on your teaching theater computer.  You may telnet and FTP only to WAM, and you may use only the pine and ftp software there.  You may not display or execute any other file on the teaching theater computer or on WAM that existed before taking this test.  In particular, you may not refer to any electronic class notes or to the class web page.  It is a violation of academic integrity to provide information about this exam directly or indirectly to any student in section 0201 who has not yet completed the midterm exam.

1.	[24 points] Answer each of the following multiple choice questions.  Each correct answer will earn 6 points, but each incorrect answer will be penalized by -2 points.  It is possible to receive a negative score on this question. 

a.	 [+6 or -2 points]  The greatest compression for recorded speech can be obtained with:

A. 	MPEG compression
B. 	GIF compression
C. 	lossless compression
D. 	lossy compression

b. 	[+6 or -2 points]  In Java, objects are:

A. 	weaker than data structures
B. 	instances of classes
C. 	another name for methods
D. 	coded in assembly language

c. 	[+6 or -2 points]  Which operation distinguishes a relational database from one which lacks relational capabilities?

A. 	join
B. 	restrict
C. 	project
D. 	all of the above

d. 	[+6 or -2 points]  HTML is used to construct

A. 	structured documents
B. 	web pages
C. 	hypertext
D. 	all of the above

2.  [25 points]

a.	[7 points]  Construct a diagram in which the following devices are placed in order of decreasing speed with which they can provide or consume information:  Hard Disk, Random Access Memory (RAM), Central Processing Unit (CPU), Wide Area Network (WAN).
	
b.	[6 points]  On your diagram, show where Network Cache and Cache Memory would be placed to accommodate the different speeds of two connected devices.
	
b. 	[9 points] Explain how each of the four devices in part (a) of this question is used to process a  web page between it’s transmission to you by the web server and the completion of its processing in your computer.

3. 	[25 points]

a.	 [15 points]  Specify the tables for a relational database which contains exactly two tables for tracking packages that  have been sent using an overnight shipping service.  For each package, record the name and phone number of the sender and recipient, the weight of the package, and the present location of the package.  

b. 	[10 points] Specify a query which will determine the name of the addressee (and nothing more) for every package that is presently located on flight number FX287.

4. 	[26 points]

a.	[13 points] Using Excel on the teaching theater computer, construct a spreadsheet to calculate the number of seconds required to transmit an uncompressed 1024x768 pixel 24-bit color image over a 33.6 kilobit per second modem connection.  Assume that 10 bits must be transmitted over the modem for each byte.  Copy the spreadsheet into the exam book by hand, specifying the formula for each cell that contains one and the value or label for every other cell.  Also place the answer in your exam book and circle it.

b. 	[13 points] Save your spreadsheet in your M: drive with the name MODEM.XLS, FTP the answer to your WAM account and then mail it to both jharding@wam.umd.edu and oard@glue.umd.edu as an attachment using pine.  WAM response time may be slow, so you may not want to wait until the last minute to do this.