Database 
Systems
Term 1, 2006
]
gray arrow Home
gray arrow Homework
gray arrow Course Information
Class Photo
gray arrow Textbooks
Certification
Mailing List
Class Notes
Links
gray arrow Presentations
Paper Topics
Paper Format
Trivia Contest
 
A database is a collection of data that is organized so that its contents can easily be accessed, managed, and updated. The most prevalent type of database is the relational database, a tabular database in which data is defined so that it can be reorganized and accessed in a number of different ways. A distributed database is one that can be dispersed or replicated among different points in a network.

Students will gain an in-depth understanding of databases by designing and creating them using Microsoft Access.

Don't even think about taking this class unless you have taken both IFSM 300 and CMIS 102 (C++ or Java).  If you like this course, and want more, try IFSM 411 and IFSM 420.

As an additional feature, this class should prepare you to take Microsoft® Office User Specialist exam in Microsoft Access 2003.  For more details, see the links below. 

NEWS

This is it!
Final and Presentations on Friday!
MOS Access 2003 Certification Counter: 1

Photo is posted!
Class starts @ 1800, in Room 205!
The mailing list is online, so sign up before class!

 

Homework 
 
Date Day
#
Assignments
Sep 06
W
01
  • Register for the class
  • Buy the book
  • Sign up for the mailing list!
  • Read Chapter 1
  • Sep 08
    F
    02
  • Friday Class
  • Read Chapter 2
  • Load Access 2003 on your laptop and bring to class
  • Moore Database Information - Print This Out, Bring to Class
  • Sep 11
    M
    03
  • Read Chapter 3
  • Hand in / email MOORE.MDB (follow instructions on mailing list)
  • Bring 2 printouts of your project proposal 
  • Sep 13
    W
    04
  • Read Chapter 4
  • Download and install metaedit on your laptops - bring to class
  • Sep 15
    F
    05
  • Friday Class
  • Homework - Problem 6, Page 138 (Automata, Inc)
  • Exam - Covers Classes 1-3
  • Sep 18
    M
    06
  • Read Chapter 5
  • Sep 20
    W
    07
  • Read Chapter 9
  • Homework - Page 178, Problems 15-17
  • Sep 25
    M
    08
  • Read Chapters B, C
  • ER Tool selection to mailing list by start of class
  • Sep 27
    W
    09
  • Exam - Covers Classes 5-8
  • Before exam, we will do problems 18-20 on page 179 
  • Sep 29
    F
    10
  • Friday Class
  • ER Tool presentations
  • Oct 02
    M
    11
  • Group Work - Design Freeze
  • Oct 04
    W
    12
  • Read Chapter 10
  • Oct 11
    W
    13
  • Design Presentation
  • Read Chapter 12
  • Oct 16
    M
    14
  • Read Appendix F
  • Read Chapter 15
  • Oct 18
    W
    15
  • Read Chapter 7
  • Oct 20
    F
    16
  • Friday Class
  • Final Exam
  • Project Presentations
  • Class Photos 
     
     
    Click here to see the class photo!
    Course Information
    Textbooks

     
     

     

    Certification

     
     

     

    Mailing List

     
     

     

    I have set up a mailing list for all the students in the class.  We can use this list to discuss class topics, assignments, problems, tips, etc...  I require all the students to sign up for this list.

    Note: You need to use an email address that reflects your name.  If I can't figure out your email, you will get a 0 for the assignment.  Honest.
     
    To subscribe to the list, send mail to ifsm461-061-subscribe@thinairlabs.com
    In the body of the message enter: subscribe

    Note: It is best if you cut and paste this information.  You are sending email to an automated program, not a person.  Follow the directons exactly, and you will be added to the list.  You will have to reply to the confirmation message that is sent.  Students have reported problems with Hotmail.  Gmail is recommended.

    Remember, everyone can read all messages sent to the mailing list.  Send personal email to, but any and all class related message need to be sent to the mailing list.

    Class Notes

     
     

     

    You should download and read the lecture notes before class.  The lecture notes are in PDF format, you might have to download a reader for your machine.  Note: You need Version 4.0 or better.  You should visit the websites, and download the programs and run them (many of them are already installed in the lab.) Note: Do not print any of this information in the UMAD computer lab.  Also, the lecture notes may not be complete, and should not serve as a substitute for attending class.
     
     
    Date # Notes Topic / Links
    060906
    01
    PDF
  • Topic: Introduction to Databases
  • PriceWatch - check the prices before you buy
  • FBI may scrap $170 million project
  • EndNote - bibliographic reference management 
  • IMA KORO MWR Libraries
  • The Long Tail - The Article, The Blog, and The Book
  • 060908
    02
    PDF
  • Topic: Database Fundamentals, Microsoft Access 2003
  • Friday Class
  • Moore Database Information - Print This Out, Bring to Class
  • Microsoft Access Query Tips and Techniques
  • Using Parameter Queries
  • Microsoft Access Tutorial
  • Creating a Simple Query in Microsoft Access
  • History of the world-famous London Underground Tube map
  • History of the London Tube Maps
  • PDF Annotator - mark up and highlight pdf documents
  • 060911
    03
    PDF
  • Topic: Relational Database Model
  • Primary and Foreign Keys
  • Relational Database Model
  • WiJET.G 802.11G Wireless Display Adapter
  • 060913
    04
    PDF
  • Topic: Entity Relationship Modeling
  • ER-Diagrams
  • 060915
    05
     
  • EXAM
  • Friday Class
  • Topic: Group Work
  • 060918
    06
    PDF
  • Topic: Normalization
  • MCSD for Microsoft .NET Certification Requirements
  • Courses 2936-2944: Free Microsoft SQL E–Learning Course
  • 060920
    07
    PDF
  • Topic: Database Design
  • Self Test Software Practice Exam (This is the basis for the final exam)
  • Microsoft Access Tutorial from Function X
  • Microsoft Access 2002 Tutorial from Loyola College
  • Microsoft E-Learning Library from Loyola College
  • 060925
    08
    PDF
  • Topic: Case Study
  • Appendix B:  University Lab - Conceptual Design
  • Appendix C:  University Lab - Implementation
  • 060927
    09
     
  • EXAM
  • Topic: Group Work
  • 060929
    10
     
  • Topic: ER Tool Presentations
  • Friday Class
  • 061002
    11
     
  • Topic: Group Work
  • 061004
    12
    PDF
  • Topic: Transaction and Concurrency Control
  • Group Work
  • Meetings with Teacher
  • 061011
    13
    PDF
  • Topic: Distributed Database Management
  • Design Presentations
  • 061016
    14
    PDF
  • Topic: Client / Server Technology, Database Administration
  • Group Work
  • 061018
    15
    PDF
  • Topic: SQL
  • MySQL Page
  • MySQL Downloads
  • Windows MySQL download
  • MySQL Documentation
  • Google's secret of success? Dealing with failure
  • Google Research Publications
  • Google Hardware 1998
  • Wikipedia: Google platform
  • 061020
    16
  • Topic: Final Exam
  • Friday Class
  • Project Presentations
  •  
    Links

     
     

     

    Presentations 
     
    Team  Submitter Tool Presenter
    1 Joe Burton Jacob Tuuao
    1 Dave Taylor Min Chung
    2 Kim, Dong Eunice Lee
    2 Kim, Jae-Young Rim, Jun
    3 Lee, Dong H Perry Marquette
    3 Simon Park Jerry Williams
    4 Tyrome Myatt Peter Kanelos
    4 Bob Henderson Gayle Simpson
    5 Chris Schrebe Jeff Schouweiler
    5 Daniel Lu Al Quimby
    Projects
     
     
    #
    Name
    Members
    1
     Neo Posse
    1. Doug Jones
    2. Joe Burton
    3. Min Chung
    4. Dave Taylor
    5. Jacob Tuuao
    2
    Fire Starters 
    1. Alex Temporado
    2. Kim, Jae-Young
    3. Rim, Jun
    4. Kim, Dong-Woo
    3
     Going Postal
    1. Maurice Yoshikawa
    2. Lee, Dong H
    3. Perry Marquette
    4. Jerry Williams
    5. Simon Park
    4
     Trouble, Inc.
    1. Wayne Elliot
    2. Tyrome Myatt
    3. Bob Henderson
    4. Peter Kanelos
    5. Gayle Simpson
    5
    IA ROKS
    1. Jack Kennedy
    2. Al Quimby
    3. Chris Schrebe
    4. Daniel Lu
    Trivia High Scores
     
    Just for Fun!
     
    #
    Name
    4
    Burton, Joseph 
    5
    Chung, Mi-jung 
    6
    Elliott, Wayne 
    6
    Henderson, Bob 
    3
    Jones, Douglas 
    6
    Kanelos, Peter
    9
    Kennedy, Jackie 
    3
    Kim, Dong
    4
    Kim, Jae-young
    3
    Lee, Dong
    4
    Lu, Daniel
    4
    Myatt, Tyrome 
    7
    Park, Simon 
    4
    Perry, Marquette 
    6
    Quimby, Al
    5
    Rim, Jun 
    4
    Schrebe, Chris 
    4
    Simpson, Gayle
    6
    Taylor, David 
    5
    Temporado, Alexander 
    6
    Tuuro, Jacob
    9
    Williams, Jerry 
    6
    Yoshikawa, Maurice