Robert E. Larson
Introduction to relational database theory and technology from an information science perspective. Focuses on traditional transactional database theory, architecture and implementation in a user-centered systems context. Introduces set and graph theory, relational algebra, and data warehouses. Credit/no-credit only. Prerequisite: LIS 511 or LIS 540.
The course will have two distinct tracks: relational database skills and database theory.
Relational Database Skills
We will cover the techniques and skills of building and using a relational database application using Microsoft Access as the vehicle. A portion of each week will involve working with hands-on tutorial style exercises that will cover the skills required of someone called on to develop and implement a database. SQL querying will be covered in a combined skills and theory module.
Book (Required): Microsoft Office Access 2003: Comprehensive Concepts and Techniques, CourseCard Edition by Shelly, Cashman, Pratt, Last. ISBN: 1-4188-4363-6 Publisher: Thomson – Course Technology
Each week will include readings (PDFs), lectures and online discussions of the following topics: systems analysis, information systems, data modeling, process modeling, relational modeling, normalizing a database, database security, client/server database concepts and advantages, XML and related technologies like RFID. There will be individual projects for each major topic.
Book (Required): None – All readings will be PDFs or web based. Full list and downloads will be on the course website.
Student learning goals
General method of instruction
Each student will need Microsoft Access 2003 – it is a part of Microsoft Office Professional.
We will use the ePost online discussion boards for weekly discussions, peer help and general course communication.
Students will select, or be assigned, a peer review partner to evaluate and offer feedback on all course module projects. The goal is to provide rapid feedback and support. Peer groups will be encouraged to implement IM (Windows Live Messenger) as well as email and ePost to facilitate this communication.
Class assignments and grading