DATA BASE ASSIGNMENT: LSC 508

Diane Lanctot


DESCRIPTION: Annotations from students taking LSC 508 for the last five years have been compiled in a database for the use of all students in the library program who wish to access particular articles and/or journals concerning Information Science and Technology.

ORIGINAL FORM: The original form for these annotations can be accessed at the following link: SAMPLE ANNOTATIONS PAGE.

INPUT REQUIREMENTS AND DATA DEFINITIONS:
Field Data Length A/N
Name

Date

Title

Journal Name

Website

Volume/Pages

Annotation

35

4

65

40

50

15

2000

a

a

a

a

a/n

a/n

a

MAXIMUM SIZE PER RECORD: 2209 bytes

So that articles can be accessed easily and sample annotations noted, the authorsí last names are listed first, along with the dates of publication for students wishing to find current articles. The particular journal titles, article titles, websites, volume and page numbers listed enable students to retrieve these for their own use. Annotations themselves help students determine how relevant or useful the various articles might be for their research purposes. Various queries can be run through the database so that students can best target their own needs and print out results.

ESTIMATED SIZE OF THE DATABASE:

Maximum size per record: 2209 bytes

Number of records per student: 15

Number of students over 5 years: 250

Maximum size of file in 5 years: 8.28 MB

My computerís RAM is sufficient to handle the anticipated growth of this database over 5 years, with 512 MB of RAM available.

There will be no authorization necessary to access this database, which will be linked to the GSLIS home web page.

NEW FORM: Please see printed form enclosed in report.

DISCUSSION: I used Microsoft Access to design and run the queries for this project. I had taken a brief mini-course at a public library on the usage of Access about a year ago, but had had no previous hands-on experience.

This seems to be a fairly user-friendly software. I had no trouble setting up the basic design for the project and running several different queries. In addition, I was able to print out the basic form to input new records. Though I had a bit of confusion in toggling between screens, queries, and views, I did find it easier to work from scratch than to use some of the design wizards. I was able to print out the records individually and manipulate them quite easily with little familiarity with the program.

Certainly this database could be a springboard for any number of projects within a library, helping to compile small and large amounts of data and, by refining queries to elicit very specific kinds of information, help librarians to monitor any number of systems and compile pinpoint statistics, from user patterns to circulation records to cataloguing issues, or serve as a targeted or specialized reference database for patrons.


Home Page