LBSC 690 Section 0201 Midterm Exam                  October 22, 1997 
 
1. [20 pts total] Short Answer 
 
a) Usenet News--for many to many communication.  This is like a
bulletin board where many people can post messages, and anyone can
come and read them.  It is asynchronous because you can read the messages
and reply at your convenience.

Mailing List--for one to many communication.  You sign up for this list,
and can receive and send messages from your personal e-mail account.  This
is asynchronous for the reason stated above.
 
b) IRC, Sync Web Chat, or Net Meeting.  These are communications that are
"scheduled" in that everyone has to be present at the time communication
is going on (synchronous). 

2.

a) TestScore or ComputeScore
 
b) The score is 65.
 
c) It's easier!

3. 
a) ANSWER: D

b) ANSWER: C
 
c) ANSWER: B
 
d) ANSWER: C
 
4.
a)

Possible reasons:

You wouldn't be able to specify data relationships.
You wouldn't be able to edit data as easily.
It would be difficult to ensure integrity *if* used by multiple persons.
It would be easier to do reports/queries, using join, project, and
restrict.
 
b)
Possible reasons:

A database would eliminate redundancy (or duplication).
A database would provide for better consistency.
This problem is too complex for a spreadsheet.

c) a lossy compression format.

d) JPEG 
 
e)

Open File Manager, and double click on N:share/class
Drag the two files up to your M: directory.
Rename the files that are in the M: directory to exam.mdb and exam.ldb
Open Access, then open the database
Click on Query, then new
Add both tables
join on Student Name/Childs Name
Project: Student Name, Parents Name, Work Phone, and Teacher
un-"show" Teacher, by clicking on the X.
restrict Teacher to "Mills" in the criteria field.
Save the Query, then Open it.