School of Library and Information Science

21:120 - Design of Automated Systems

Syllabus

Term Paper

Sample Topics from previous semesters (in no particular order)

• Library Automation and the Deskilling of Librarians: Past Trends and Future Possibilities
• Relational Database Modeling: A New Way to Look at Bibliographic Databases and the USMARC Format
• Z39.50
• Cataloging and User Interface: data structure considerations
• Automation in Interlibrary Loan
• Disability Issues in Library Automation
• Database Performance
• Access to Online Library Catalogs for the Blind and Visually Impaired
• A Comparison of World Wide Web-Based Interfaces for Library Catalogs and Databases
• The Online Catalog
• Librarian Meets Technology: the shift under sensible shoes
• More than Money: Special Concerns in Automating Rural Libraries
• Library Automation in Corporations
• Issues in Interface Design for Public Library OPACs

Final Exam sample

Sample Midterm Exam (solution )

Sample Final Exam

---

Exercises

• Exercise #1 , due February 20, 2002.
• Exercise #2 , due March 11, 2002.
• Exercise #3 , due April 29, 2002.
• Exercise #4 , due April 22, 2002.
  

Sample Exercises

1. Sample Exercise #1 ... solution
2. Sample Exercise #2
3. Sample Exercise #3

---

Lecture Material

• The Software Life Cycle (PowerPoint) , (PDF)
• Database Design Issues ( 2-up )
• Data Modeling, part 1 (PowerPoint) , (PDF)
• Data Modeling, part 2 (PowerPoint) , (PDF)
• Entity-Relationship Examples
• Normalization
• Library Requirements
• JSP Examples
• Catalog
• Figure 5-2
• Figure 5-3
• Figure 5-4
• Figure 5-5
• Figure 5-8
• Figure 5-9
• Figure 5-10
• Figure 5-11
• Figure 5-15
• Figure 5-16
• Circulation (PDF )
• Figure 6-1
• Figure 6-2
• Figure 6-3
• Figure 6-4
• Figure 6-5
• Acquisitions (PDF )
• Figure 7-1
• Figure 7-2
• Figure 7-3
• Figure 7-4
• Figure 7-5
• Figure 7-6
• Figure 7-7
• Serials (PDF )
• Figure 8-1
• Figure 8-2
• MARC specification
• MARC Parsing Example
• Z39.50 Web site
• Z39.50 specification
• Z39.50 brochure
• Z39.50 Made Simple
• Z39.50 and Networks
• Z39.50 in a Nutshell
• Z39.50 Overview
• XML - Extensible Markup Language
  • Dissertation example schema
  • W3C XML Primer
  • Mongin's XML Primer
• Image Retrieval

---

Supplemental Reading

• Kent, W., "A Simplified Guide to Five Normal Forms in Relational Database Theory, " Communications of the ACM,vol. 26, no. 2, February 1983, pp. 120-125.
• Java Server Pages Specification
  • JSP site at Sun Microsystems
• Shneiderman, B. " Designing information-abundant web sites: issues and recommendations ," International Journal of Human-Computer Studies, vol. 47, no. 1, 1997, pp. 5-29.
• Winter, K., "'MyLibrary' Can Help Your Library," American Libraries, vol. 30, no. 7, August 1999, pp. 65-67.

---

And Now For Something Completely Diffferent...

• The Risk of Information
• Y2k bug...

---

Reference Material & Tools

• A list of commercial automation packages
• Details on Winnebago installation
• PDF, or Portable Document Format files are designed to be read with the Adobe Acrobat reader on almost any computer platform. Here are some websites where you can download Acrbat reader directly and then view the PDF files for the syllabus.
• http://www.adobe.com/prodindex/acrobat/readstep.html
• http://www.claytonwallis.com/downacro.htm

Last modified: April 10, 2002.