CIS113

1
CIS113

• Introduction to Database Systems

2
Course Goals

• This course will provide students with the
  understanding of how to use a database management
  system to implement projects requiring the
  organization, manipulation, and retrieval of data.

3
Learning Objectives

• Students should be able to
• Understand the basics of database design
• Create, update, and modify a database
• Structure and modify database queries
• Create forms and reports

4
Course Topics

• Working with an existing database
• Basics of database design
• Designing and creating a new database
• Creating a table
• Defining table relationships / referential
  integrity
• Creating queries
• Creating forms and reports
• Creating advanced queries
• Creating custom forms and reports
• Integrating Access with the web
• Advanced topics switchboard security

5
Model Curriculum Learning Units

• IS 2002.P0 Personal Productivity with IS
  Technology
• Learning Units 1-4, 13.1-13.9, 13.12

6
Projects Presentations

• Students must design their own database,
  implementing a one-to-many relationship.
  Students must create their own tables, forms,
  queries, and reports. A presentation and written
  report are also required. This project must be
  implemented individually.

7
Text / Software / Hardware

• Adamski/Finnegan, Microsoft Access 2003 (Course
  Technology)
• Microsoft Access 2003
• PC Based
• Prerequisites NONE

8
Assessment

• Grade Distribution
• Labs, Homework, Projects, Exam, and Final are all
  20 of final grade
• Overall class percent achieved for each
• Labs 71.9
• Homework 61.722
• Paper projects 73.667
• Exam 86.967
• Final 66.36
• Final Grades Given 2 A, 1 A-, 1 B, 1 B, 2 B-,
  1 C, 1 C, 1 D, 4 F (74.9333)

9
Changes

• Textbook software change from last year
  (upgraded from XP to 2003)
• Microsoft Office Access 2003, New Perspectives,
  Adamski/Finnegan (Course Technology)
• Microsoft Office Access 2003