* Resources *
* Discussion *
The following is a tentative list of topics to be covered in the
course. Note that this list is subject to changes.
- STAIR and Databases: Application of the STAIR
Method in database design and application development.
- Database Tools: Discussion and comparison of
various database tools - DBMSs, servers and clients, and data
- Database Design: Designing databases: designing
tables, assigning keys and indices, deciding data types, sizes and
- Database Queries: Queries involving single and
multiple tables, multi-table queries, update and delete queries.
- Database Applications: Building database
application components - forms, and reports.
- Mar 9: Overview of course, initial student feedback,
introduction to databases.
Readings: CSCI A114 web site, firstclass
brochures, Microsoft Access manuals and other materials.
- March 10: UITS STEPS class on Microsoft Access. See
STEPS website for
- Mar 11: Microsoft Access quick tutorial.
Readings: Microsoft Access tutorial from STC
- Labs: Introduction to Access, Using database files,
Firstclass tutorial. No modules this week.
- Mar 15-19: No class, SPRING BREAK
- Mar 23: Intro to databases, Databases Vs. file-based
systems, advantages of using databases, STAIR in database
problem solving, history of databases.
Readings: Groth/Sengupta pages 1.1-1.12
- Mar 25: Database applications,
Database tools - Access, FoxPro,
Paradox, Sybase, etc.
Readings: Groth/Sengupta pages 2.1-2.12
- Labs: Import and export from databases, playing with
tables and other DB objects, Initial table design and
[Module 1 on Tue.]
- Mar 30: Simple design, tables, columns, data types and
sizes. Default values. Primary keys and their uses.
Readings: Groth/Sengupta pages 3.1-3.4
- Apr 1: Simple queries. The query construction method,
query functions, ordering and grouping.
Readings: Groth/Sengupta pages 3.5-3.16
WRITTEN ASSIGNMENT DUE!
- Labs: Designing single-table databases, writing simple
queries, query wizards.
[Module 2 on Tue.]
- Apr 6: Database models, relationships (one-one,
one-many, many-many), Indexes.
Readings: Groth/Sengupta pages 4.1-4.4
- Apr 8: Intermediate queries. Basic joins, Alias and
qualified fields, outer joins.
Readings: Groth/Sengupta pages 4.4-4.10
- Labs: Design of multi-table databases. Setting up
relationships, writing intermediate queries.
[Module 3 on Tue.]
- Apr 13: Advanced queries (update and delete
queries). Advanced conditions, Subqueries.
Readings: Groth/Sengupta pages 5.1-5.7
- Apr 15:
[Module 4 on Tue.]
- Apr 20: Developing database applications, Forms and
reports, wizards to the rescue.
Readings: Class notes and Lab material (see
FirstClass for details)
Project status report due
- Apr 22: Database development, Database applications, application
Readings: Groth/Sengupta Chapter 6
- Labs: Form and report wizards, application development.
[Module 5 on Tue.]
- Apr 27: More advanced queries (exists, set operations,
other correlated subqueries), future of databases.
Readings: Groth/Sengupta pages 5.7-5.13,
- Apr 29: Exam review session.
- Labs: Project help
[Module 6 on Tue.]
[Project due on Fri.]
- May 4: Finals week - no class.
- May 6: Final Exam: 10:15AM-12:15PM Lindley 102.
- Labs: Labs do not meet this week.