This database contains the annotations found on the Annotation page of this website. This database could be used by students in the LSC 508 class or in the GSLIS or anyone who wanted more information on library or information sciences. The database can be searched by author, article title or journal. The fields I included in my database are: author, article title, journal title (including volume number, issue and page numbers when applicable), the annotation of the article, the source type (print, electronic version or web only) and the date retrieved.The data type for the author, article title, journal, type, volume, issue and pages fields was ìTextî and the sizes were 75, 110, 100, 50, 10, 10, 15 respectively. The data type for the publish date was ìNumberî and the field size was ìinteger.î The data type for the date retrieved was ìDate/Timeî and the data type for the annotations was ìMemo.î
Assuming that each class has 25 students who each do 15 annotations for two sessions the fall and spring semesters will produce 1500 annotations and the summer semester will produce 250 for a total of 1750. After a period of 5 years 8750 annotations will be written. Currently my database containing 7 annotations is using 628 KB of storage. The database when filled with all the annotations will need approximately 785,000 KB. The current amount of free memory on my computer right now is 12.68 so it should be able to handle the database at full capacity.
Since I want my database to be available to anyone who wants information on library and information science I would not need any security to prevent unauthorized people from using the database. To prevent unauthorized people from entering information into the database I could make the database inaccessible to anyone without administrator permission.
The Access software was fairly useable. It was easy to enter the data and define the fields however it was difficult to make the searches return the correct material.