 |
CSCI A114 / INFO I111
Course Syllabus
First semester 2001-2002
|
I believe that whatever we learn we learn by doing.
Therefore the lab modules are going to be a central part of this course. We are going to follow the Shelly Cashman
Pratt book Microsoft
Access 2000 (Comprehensive Concepts and Techniques) in the lab and we will undertake the following projects.
- ONE
- Creating a Database Using Design and Datasheet Views
- TWO
- Querying a Database Using the Select Query Window
- THREE
- Maintaining a Database Using the Design and Update Features of Access
Publishing to the Internet Using Data Access Pages
- FOUR
- Report, Forms, and Combo Boxes
- FIVE
- Enhancing Forms with OLE Fields, Hyperlinks, and Subforms
Creating an Application System, Using Macros, Wizards, and the Switchboard Manager
- SIX
- Creating a Report Using Design View
- SEVEN
- Customizing Forms Using Visual Basic for Applications, Charts, and PivotTable Objects
- EIGHT
- Administering a Database System
While the focus will be on real-life applications, the lectures will also try to provide adequate theoretical background.
Obtaining Access proficiency will provide students with significant immediate and short-term benefits. Here is a list of
topics
that will be presented in the lectures with the long-term benefit of the student in mind:
- BASIC CONCEPTS
- An Architecture for a Database System
An Introduction to Relational Databases
- THE RELATIONAL MODEL
- Relational Data Objects: Domains and Relations
Relational Algebra
Relational Calculus
The SQL Language
- DATABASE DESIGN
- Functional Dependencies
Normalization
The Entity/relationship Model
- DATA PROTECTION
- Recovery
Concurrency
Security
Integrity
- FURTHER TOPICS
- Object-Relational DBMSs: The Next Great Wave
We hope this combination will provide students with the right mix of theoretical and practical skills.
Last updated: August 28, 2001 by Adrian German for A114/I111