LBSC 690 Final Exam Section 0201 Spring, 1997 Instructions: The maximum possible score on this exam is 100 and the minimum possible score is -7. There are five questions. The number of points available for each question is clearly indicated at the beginning of the question, as is the breakdown of points for each part of the question. You may use your own personal copy of Oakman and any notes that you have handwritten in your copy of Oakman, and you may use a calculator. You may use your own personal copy of Oakman (including any notes made in your own handwriting), an electronic calculator, and the Excel and Access applications on the computer at your desk. You may not use telnet, FTP, Netscape, any other computer applications, or any other material. Please put all of your answers in the exam booklet that has been provided. You may answer the questions in any order. Only answers written in your exam booklet will be graded. Please also turn in this exam by placing it inside your exam booklet. Because some students may take the exam late, it is a violation of academic integrity to reveal any information about this exam to any student that did not take it at the same time you did until the solutions are posted on the class web page. 1. [20 points] For full credit, using Microsoft Access, implement the following database and save it in a file called "M:\FINAL.MDB". Half credit is available for each part if you write the answer in your exam book but fail to implement and save it in the correct place. So you might want to copy your answers in the exam book anyhow even though that is not required. a. [10 points] Using Microsoft Access, design 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 recipient (and nothing more) for every package that is presently located on flight number FX287. [21 points] Choose the best answer for each of the following multiple choice questions. [+3 if right, -1 if wrong] The social rationale for using computers in education is best summarized by: Computers can be used to teach Computers will revolutionize education Knowing how to use a computer will help people get jobs Computers will be a part of the fabric of society in the future [+3 if right, -1 if wrong] The principal user interface for Windows 3.1 is Command line Direct manipulation Indirect manipulation Command manipulation [+3 if right, -1 if wrong] The "PGP" (Pretty Good Privacy) package includes: Private read keys Public write keys Digital signatures All of the above [+3 if right, -1 if wrong] In client-server computing, computing processes are usually: Run in batches rather than in response to user requests Split across several machines Run on a single large computer Connected using dialup telephone lines [+3 if right, -1 if wrong] Internet electronic mail is an example of which type of Computer Supported Cooperative Work (CSCW)? Synchronous local Synchronous remote Asynchronous local Asynchronous remote [+3 if right, -1 if wrong] When developing software, a model in which a small prototype is constructed first, a complete system is put together second, and then a final version is developed from scratch using what was learned in the first two attempts is called: A spiral development model A waterfall development model A spaghetti code development model An object oriented development model [+3 if right, -1 if wrong] In the URL http://oriole.umd.edu:8000/courses/690, the ":8000" specifies the: User number Port number Maximum number of users Maximum acceptable delay [19 points] The following Java program is supposed to print out the number of days that the specified month (1 through 12) will have in 1997, but it contains at least one error. Correct the program by changing the minimum possible number of lines. You only need to indicate the line numbers and the corrected content of those lines in your exam booklet. [20 points] You have been asked to design a distance education system to provide weekly one-hour training sessions for librarians in public libraries in Alaska. Your boss would like you to provide live two-way audio and video capabilities for 250 libraries ranging in size from a single room to an entire building and scattered over three time zones, and has given you a budget of $500,000 for hardware and $25,000 per month for communications services. [10 points] What type of equipment will you buy? For computer equipment, identify all of the input and output devices that you will need (including input and output devices that normally come with a computer). Justify your answer. [10 points] What type of communications service or services will you use? Justify your answer. [20 points] You have been put in charge of introducing an integrated library automation system for the first time for the Hilo, Hawaii public school district which includes 10 primary and secondary school libraries. [10 points] Describe the retrospective conversion problem and identify the steps that you will need to complete in order to solve it. [10 points] You plan to make your catalog available on the World Wide Web, and your vendor suggests that you do so using a Java applet. How is this different from a normal web page?