LBSC 690    Fall 98    Section 0301    Midterm Exam    October 28, 1998

You have one hour and fifteen minutes to complete this exam, which
will begin after we have read through the exam together.  You may use
your own personal copy of Oakman, along with any notes that you
personally have handwritten into that book.  You may also use a
calculator if you brought one.  You may use any program on the
teaching theater computer, but YOU MAY NOT USE ANY FILES THAT YOU HAVE
PREVIOUSLY CREATED (whether in the teaching theater, on WAM, or
elsewhere).  You may also not communicate with any other person during
this exam, (except the professor or the TA), either in person or using
an electronic means.

Except where otherwise stated, you should record all of your answers
in the exam booklet that has been provided.  Be sure to put your name
on the booklet!  You may record your answers in any order, so long as
we can find them.  You must also turn in your exam itself, although we
will not grade any marks that you make on it.

It would be a violation of academic integrity to discuss any aspect of
this exam with (or in the presence of) any person who did not take it
at the same time you did, until the exam itself is posted on the web.
This exam will be posted on the web once all registered students in
sections 0101 and 0103 have completed the midterm exam that was
prepared for their section.

--------------------------------- Begin ---------------------------------

1. (25 points total) You are planning a trip to Hawaii, so you decide
to surf the net to find the information you need.

a. (5 points) Find a web page that provides information about surfing
(the kind you do in the ocean) in Hawaii.  For example, you might find
a review of good places to surf or a report on the current surf
conditions (wave heights, etc.).  Record the URL your exam booklet.

b. (10 points) Create a web page called surf.htm that contains your
name and a link to the web page that you found.  (If you were not able
to do part (a), then create a link to some other page instead.)  Store
the web page that you create in your personal directory (your
"M:" drive) in the teaching theater.

c. (10 points) FTP your surf.htm file to your WAM account and then
email it to your TA as a MIME attachment.  If you are concerned that
it might not arrive, you may also send a copy of the web page to me
(oard@glue.umd.edu) as an insurance policy.

2. (24 points total) Answer the following multiple choice questions.

a. (+6 for a correct answer, -2 for an incorrect answer) Inspired by
what you have learned about Hawaii, you decide to post a note to the
USENET newsgroup known as rec.travel to solicit some ideas about what
to do while you are there.  The rec.travel USENET newsgroup is an
example of which of the following categories that we discussed in
class?

A. person-person, many-many, asynchronous
B. person-computer
C. person-person, one-one, synchronous
D. computer-computer

b. (+6 for a correct answer, -2 for an incorrect answer) While flying
to Hawaii, it turns out that you are sitting next to Fred Brooks, the
author of "The Mythical Man-Month." As you discuss how things
have changed since he wrote that, you realize that one aspect of
object-oriented programming is designed to overcome the communication
problems that he described.  Which of the following is it?

A. Polymorphism
B. Inheritance
C. Encapsulation
D. Bytecode

c. (+6 for a correct answer, -2 for an incorrect answer) While on the
plane, you pull out your laptop computer and write up the first draft
of your LBSC 690 project specification using Microsoft Word.  What
kind of software is Microsoft Word?

A. Operating system
B. Programming language
C. Application software
D. Embedded software

d. (+6 for a correct answer, -2 for an incorrect answer) You promised
to send your draft of the project specification to your teammates
before you left, but there just wasn't time.  Now that you have
finished it you want to send it immediately.  You see that the
airphone at your seat has a data jack, but a quick skim of the
inflight magazine confirms that calls cost $2.50 per minute.  You
check the file size and find that it is 40 kilobytes.  If your modem
were to connect at 19.2 kilobits per second, how long would it take to
send the entire file?

A. about 2 seconds
B. about 20 seconds
C. about 2 minutes
D. about 20 minutes

3. (26 points total) You land in Hawaii and head for the hotel.  When
you get there, you connect your computer to the Internet so that you
can check your email.

a. (15 points) What is the Internet?  (I know the Internet is big, but
try to keep your answer to a paragraph or so).

b. (6 points) Today was a holiday in Maryland and you have received no
email, so you decide to head to the beach to try out your new digital
camera.  It takes 24-bit "true color" pictures with 480 lines
and 640 pixels per line, and it compresses them to 10% of their
original size using JPEG.  You want to send some of these pictures to
your parents so that they can see what a good time you're having,
but they don't have email yet.  How many of these pictures can you
fit on a single 1.44 megabyte floppy disk that you could mail to them
at the post office?  (Show your work if you would like the opportunity
for partial credit.)

c. (5 points) At the beach you run into a gaggle of geeks who insist
on talking about information technology.  In order to try to fit in
you start talking about what you have learned about structured
documents.  You point out that structured documents need to be
"rendered" in a format suitable for viewing, and that HTML can
be thought of as a language for creating structured documents.  What
is the software that performs rendering for HTML called?

4. (25 points total) Escaping from the geeks, you decide to leave the
beach and go see some of the island.  Someone hands you a flyer
advertising submarine rides to see the sunken ships in Pearl Harbor
and that sounds like fun so you go to buy a ticket.  It will be a
little while before the next trip, so you get to talking with their
database programmer while you wait.  They turn out to be a graduate of
LBSC 690 who came here last year and liked Hawaii so much that they
dropped out of school and stayed, and they show you how their database
actually works.  There are three tables:

Customer:  customer_number, first_name, last_name, hotel
Excursion: trip_number, date, departure time
Booking:   customer_number, trip_number

customer_number is the primary key in the Customer table
trip_number is the primary key in the Excursion table

a. (10 points) Depict the table that would result from performing a
join operation on the Excursion and Booking tables, using some sample
data that you make up to illustrate how the join operation works.

(15 points) Specify a query that would print out the names of all the
people that will be on the submarine with you (you can assume that you
know your departure date and time, but not the trip number).  You can
specify the query by simply stating the join, project and restrict
operations that need to be performed, without worrying about what
order the system will actually perform them in.

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