To study of the theory and application of database management systems and learn to use application packages such as MicroSoft Access. Topics include database design, data normalization, SQL, and transaction management.
Week of | Lectures & Reading | Assignments | Exams |
Jan 10 | Introduction
Post Ch 1 & Groff pp 48-53 |
Assignment 1
Class Project |
|
Jan 17 | (No class Monday) Database Design Post Ch 2 UML reference |
Assignment 2 | |
Jan 24 | Data
Normalization Post Ch 3 & Groff pp 53-64 |
||
Jan 31 | Data
Normalization (continued) Post Ch 3 & Groff pp 53-64 |
Assignment 3
Example Solution |
|
Feb 7 | Queries Post Ch 4 & Groff Chs 2, 5, & 6 |
Assignment 4
Example Solution |
|
Feb 14 | Queries
(continued) Post Ch 4 & Groff Chs 2, 5, & 6 |
Exam 1 | |
Feb 21 | Advanced
Queries Post Ch 5 & Groff Chs 7, 8, & 9 |
Assignment 5 | |
Feb 28 | Advanced
Queries (continued) Post Ch 5 & Groff Chs 10,13 & 14 |
Assignment 6 | |
March 6 | (Spring Break: No classes) | ||
March 13 | Forms and Reports
Post Ch 6 |
Assignment 7 | |
March 20 | Database Programming
Post Ch 7 |
Assignment 8 | |
March 27 | Database Programming
(continued) Post Ch 7 |
Exam 2 | |
April 3 | Applications
Post Ch 8 & Groff Ch 8 |
Assignment 9 | |
April 10 | Applications
(continued) Post Ch 8 & Groff Ch 8 |
Assignment 10 | |
April 17 | Physical Design
Post Ch 9 |
||
April 24 |
Database Adminstration review for final | ||
May 1 | Project Presentations Last day of classes: May 3 |
||
May 5-May 11 | Final Exam Week: (CSCI 343: Wed, May 10, 10:00-12:30) |
Final Exam |
Exam grades | 100 x 2 | 200 |
Assignment grades | 15 x 9 | 135 |
Project grade | --- | 100 |
Final Exam grade | --- | 150 |
Total Points | --- | 585 |
Lectures: A roll is not taken. Students are expected to attend all class lectures. Failure to do so will be considered a lack of interest in success on the part of the student.
Exams: If you must miss an exam or quiz due to illness you must telephone or send email before the scheduled time and perhaps something can be arranged to avoid a zero for this exam. Failure to notify me prior to the scheduled time will produce an automatic zero for the exam.
Hand out sheets with instructions will be given in class for each assignment. These assignments will involve:
The program writing projects are your way of telling me about your mastery of this course. Because this is a course about writing programs you are expected to take these assignments very seriously. Your programs must be clearly different than those turned in by others in the class and represent a unique and special effort on your part.