Database Systems – CSCI 3410

Spring 2020

Clément Aubert

March 25, 2020

Quick Facts


Course Description

This course offers an introduction to database systems as a key concept in information management. The course covers logical and physical database organization, data models, file structures, indexing, hashing, query optimization, and design issues. This course will cover the design and implementation of databases.

Learning Outcomes

Upon successful completion of this class, the student will:

Format and Procedures

Lectures are devoted to general explanations of the concepts and ideas underlying the topic at stake. All practical work, coding, programming, testing, etc. will be carried at home.

Homework assignments will assist the students in making sure they understand classes expectations and the content of the lecture, as well as to practice their coding and problem-solving skills. The progression of the students will be regularly tested and assessed through quizzes and exams. Active and relevant participation during the lectures is appreciated.

Teaching Philosophy

It is our mutual interest for you to succeed: I love to share knowledge and to expand it by helping students, and students want to gain a useful and agreeable experience that will prove valuable in their future endeavors. To this end, here is:

What I’m expecting from you

  • Check periodically your email account and read the email I send.
  • Read this entire syllabus carefully.
  • Participate actively in all class discussions.
  • Do the homework wisely: read your notes before starting the homework assignment, make sure you understand it completely before considering it done.
  • Come prepared and on time to classes, exams and quizzes.

What you should expect from me:

  • Clear and accessible lectures.
  • Fair and impartial grading.
  • Availability, during office hours, by appointment, and by email.
  • Open hear to your suggestions to improve this class.
  • Commitment to the principles of universal design.
  • Dedication to your success!

Course Requirements

Practical Information

Getting Help

I should be your first point of contact for any question regarding the content of this class, but many other resources are available:

ACM Club

There is an A.C.M club at Augusta University.

It is the ideal place to get to meet fellow students, to work on exciting projects, and to learn more about various aspects of Computer Science and Information Technology. Join the discord chat at or contact its president, Mark Holcomb, to get more information about it.


Students will be evaluated using four different types of evaluation:

  1. Homework assignments will be given during the course of the semester: they are not expected to be handed back, and won’t be graded, but quizzes with questions taken or inspired from those assignments will be given. Those quizzes are closed book and timed (± 10 min.).

  2. Projects will be carried at home.

  3. There will be in-class exams, held during the regular class periods.

  4. The final exam will take place during the exam period.

Refer to the planned schedule for precise dates.

Your grade will be computed as follows:

Quizzes (×4) 10%
Project (×2) 10%
In-class Exams (×2) 40%
Final Exam 40%

using the following course grade scale:

Below 65 65–70 70–79 80–89 90–100

Planned Course Schedule

The week starts on Monday.

Week Date Note Topic
1 01/06 - Syllabus, Introduction
2 01/13 - The Relational Model
3 01/20 01/20: MLK, 01/22 : Quiz -
4 01/27 - SQL
5 02/03 02/05: Project -
6 02/10 02/12: Exam Review Session
7 02/17 - Entity-Relationship Model
8 02/24 02/26: Quiz, 02/27: Midterm E.R.-to-Relational Models Mapping
9 03/02 03/05–06 Spring Pause Guidelines and Normal Form
10 03/09 - Unified Modeling Language Diagram
11 03/16 03/18: Quiz Introduction to Data Programming Using Java
12 03/23 03/25: Project -
13 03/30 04/01: Exam Review Session
14 04/06 04/06–10: Spring Break -
15 04/13 - Introduction to NoSQL
16 04/20 04/22: Quiz -
17 04/27 04/29: End of class Wrapping up
18 05/04 05/06 (2–4pm): Final -

This schedule is subject to change and enhancements, but provide an indication of the pace, assignments, and major deadlines that you will need to plan for the semester.