L&I SCI 410: Database Information Retrieval Systems

(1)

L&I SCI – 410: Database Information Retrieval Systems

Instructor Information

Instructor: Kun Lu

Home page: http://www.uwm.edu/~kunlu

Meeting Time & Location: Tuesday, Thursday, 3:30 pm – 4:45 pm, Bolton Hall, Rm. 289 E-mail: [email protected]

Office Hours: Bolton Hall, Rm 668A, Tuesday, Thursday 2 pm – 3pm, or by appointments

Prerequisite

Junior standing

Course Description

The course introduces the database concepts and theories as well as practical design issues with a focus on relational databases. It covers both fundamental theories and hands-on practices. This course also introduces some popular database management systems including MS Access and MySQL. The main goal of this course is to teach students database manipulation skills and design principles.

Course Objectives

1. Understand basic database concepts and theories.

2. Learn the standard database language SQL to retrieve and process data in databases. 2. Learn database design principles and process.

(2)

Required Textbooks

1. New Perspectives on Microsoft Access 2010, Introductory, Joseph J. Adamski and Kathleen T. Finnegan, Course Technology 2010, ISBN-10: 0538798483, ISBN-13: 978-0538798488

Reference books

1. Database Systems: Design, Implementation, and Management, Seventh Edition, Peter Rob, Carlos Coronel, Course Technology 2006, ISBN-10: 1418835935, ISBN-13: 978-1418835934

Available from Amazon at:

http://www.amazon.com/Database-Systems-Design-Implementation-Management/dp/1418835935

2. SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, Second Edition, John L. Viescas, Michael J. Hernandez, Addison- Wesley Professional, ISBN-10: 0321444434, ISBN-13: 978-0321444431

http://www.amazon.com/SQL-Queries-Mere-Mortals-Hands-/dp/0321444434/ref=sr_1_1?ie=UTF8&qid=1311694884&sr=8-1

3. Database systems: a practical approach to design, implementation, and management, Fourth Edition, Thomas M. Connolly, Carolyn E. Begg. Addison-Wesley 2004, ISBN-10: 0321210255, ISBN-13: 978-0321210258

(3)

Required software

We will be working with MS Access 2010. The software is installed on all SOIS labs. If you are planning to work at home and don’t have MS Access already installed on your home computer, you need to buy MS Office 2010. It is available to be purchased at a discounted price $72 from WISC at

http://wiscsoftware.wisc.edu/wisc/productInfo.asp?id=57037&institution=1029

Students can request access to their web space at

http://www4.uwm.edu/sois/resources/it/webspace/register.cfm

They must have a SOIS account in order for it to work. If students do not have a SOIS account they can request one by emailing [email protected]

MySQL software will be available through at the virtual machine.

Grading Items

1. In-class exercises

The in-class exercises aim to let students to learn by practice. Students will complete the exercises in class together with the instructor. Instructor may ask students to show their work on the board. Then, instructor will answer any questions about each question. Exercises that cannot be addressed during class will constitute additional assignment. Exercises are due one week after the in-class session. Students are required to show their own work in the exercises.

2. Lab assignments

Students are required to submit their lab assignments for grading. Depending on the content of the lab session, students may need to submit either MS Access file or other format as required.

3. Paper/Project

The class will be divided into groups up to four students. Each group may choose to write a paper or a project.

(4)

For groups that choose to write a paper, a list of presentation topics will be provided by instructors during the semester. Each group will select a topic, write a paper about it and present to the class. Groups want to work on other topics that are not on the list may be allowed contingent on permission from the instructor. An outline of the paper will be due in the middle of the semester for reviewing by the instructor. Final paper will due at the end of the semester. As an alternative to papers, students who have strong technical interest and background may choose a database design project. The project involves designing a complete database management system to address a practical database need and implementing a relational database prototype in MS Access or with other programming language based on that design. Your database System should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization (e.g. music/ video/ book store). A project specification document will be due in the middle of the semester for reviewing by the instructor. A presentation of your system is required in the last two weeks of the semester. Final project will due at the end of the semester.

4. Final exam

A 2 hour in-class final exam will be held at the end of the semester. It may cover any topic addressed during the semester. Students may use their course materials or lecture notes. However, accessing resources from Internet is prohibited.

Grading Policy

Lab assignments: 20% In-class exercises: 25% Paper or Project: 25% Final exam: 30%

Grading Scale

A A- B+ B B- C+ C C- D+ D D- F

(5)

Policy on Late Work

All assignments must be completed and submitted by the due date. Each extra day of the late work will be penalized by 10% unless a notification is made to the instructor before the deadline and a new deadline is granted.

Course Schedule (Might change subject to progress during the

semester)

Week Tuesday Thursday Assignment Due

1 9/6 9/8

Course Introduction & Overview

--Goals and objectives --Schedule

--Show some application --Introduce software

Introduction to Database concepts and DBMS

2 9/13 9/15

Introduction to Microsoft Access

-- table, field, field types, field properties

-- query by example

Lab 1: QBE

3 9/20 9/22 Lab 1 Due on Saturday

9/24 midnight

SQL Exercise 1: SQL

4 9/27 9/29 Exercise 1 Due on

Saturday 10/1 midnight

Advanced SQL Exercise 2: Advanced SQL

Saturday 10/8 midnight Introduction to MySQL

--Command line --phpMyAdmin --Import & Export --SQL command

Lab 2: SQL

10/15 midnight Lab 3: Advanced SQL Lab 3: Advanced SQL

10/22 midnight Relational algebra Exercise 3: Relational algebra

Saturday 10/29 midnight Relational algebra Exercise 4: Relational algebra

(6)

9 11/1 11/3 Exercise 4 Due on Saturday 11/5 midnight

E-R Model E-R Model

Exercise 5

Saturday 11/12 midnight Relational Model Relational Model

Exercise 6

Saturday 11/19 midnight

Normalization Normalization

Exercise 7

12 11/22 11/24 Exercise 7 and

Presentation summary Due on Saturday 11/26 midnight

Lab 4:

Forms and reports

Thanksgiving no class

12/3 MS Access Macro and

Expressions

MS Access VBA

14 12/6 12/8

Database administration & security

Presentation

15 12/13 12/15

Presentation Review

16 12/20 Final paper/project due

on 12/20

Final exam

UWM and SOIS policies

This course falls under the usual policies of UWM and SOIS.

Disabled students: if you need specific accommodations to attend the class or fulfill the assignments and exams, please contact the instructor as soon as possible. You may also need to contact the Student Accessibility Center:

http://www.uwm.edu/Dept/DSAD/SAC/MainOffice.html See also: http://www.uwm.edu/Dept/DSAD/SAC/SACltr.pdf

Religious observance: please notify your advisor within the first three weeks of the semester of any specific dates on which you request relief from an academic requirement for religious observance.

(7)

Students called to active military duty:

See: http://www3.uwm.edu/des/web/registration/militarycallup.cfm

Incompletes: a notation of incomplete may be given in lieu of a final grade to a student who has carried a subject successfully until the end of the semester but who, because of illness or other unusual and substantial cause beyond the student's control, has been unable to take or complete the final examination or some limited amount of other term work.

See: http://www.uwm.edu/Dept/SecU/acad%2Badmin policies/S31.pdf

Discriminatory conduct:

See: http://www.uwm.edu/Dept/SecU/acad%2Badmin policies/S47.pdf and contact an appropriate SOIS administrator if you have more questions.

Academic misconduct:

See: http:////www.uwm.edu/Dept/OSL/DOS/conduct.html or contact the SOIS investigating Officer (currently the Associate Dean) for more information.

Complaints: Students may complaint to the SOIS Dean or Associate Dean. If the complaint allegedly violates a specific university policy, it may be directed to the appropriate university office responsible for enforcing the policy.

Grade appeal procedures:

See: http://www.uwm.edu/Dept/SecU/acad%2Badmin policies/S28.pdf

Final exam schedule: