CSCI 343 -- Database Management Systems


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.






Tentative Course Schedule

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

Attendance Policy:

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.

Policy on Assignments:

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.

CSCI logo Return to the UNCA Computer Science home page