CS 430: Database Systems (Spring 2017)

  • To give you a broad overview of Database Management Systems (DBMS)
  • Introduce you to the fundamental concepts and methods
  • Introduce you to an example DBMS
  • Lectures: 1:00 pm to 1:50 pm on Mondays, Wednesdays and Fridays at Clark A 203.

    Previous enrollment in CS 314.  Students are expected to have a background in discrete mathematics.

    Required Recommended
    Topic Reading
    Overview of Database Systems Chapter 1
    Introduction to Database Design Chapter 2
    Relational Model Chapter 3
    Relational Algebra and Calculus Chapter 4
    SQL: Queries, Constraints and Triggers Chapter 5
    Relational Database Design Chapter 19
    Overview of Storage and Indexing Chapter 8
    Tree Structured Indexing Chapter 10
    Hash-based Indexing Chapter 11
    Overview of Query Evaluation Chapter 12
    External Sorting Chapter 13
    Query Processing and Optimization Chapters 14, 15
    Crash Recovery Chapter 18
    Transaction Processing Chapters 16, 17
    Class Participation   5%
    Homework Assignments 30%
    Midterm Examinations 45%
    Final Examination 20%

    To pass this course, you must satisfy BOTH the requirements stated below.

    You are expected to do the assignment on your own. The assignments are given in a portable document format. To view the assignments you need an Adobe Acrobat Reader.

    There is no late policy. All your assignments are due before class on the due date. The due date may be extended only under exceptional circumstances.

  • All examinations are closed book.
  • Examinations must be taken individually.
  • Make-up examinations will not be given under normal circumstances.
    Examination Date Time Venue
    Exam 1  Feb 20 1:00 to 1:50 pm Clark A 203
    Exam 2  Mar 24 1:00 to 1:50 pm Clark A 203
    Exam 3  Apr 14 1:00 to 1:50 pm Clark A 203
    Final  May 9 4:10 to 6:10 pm Clark A 203
  • Instructor:
       Indrakshi Ray
        Office Hours: M 10:30 am-12:30 pm
        Office: 440 CSB
        Phone: (970) 491-7986
        Fax: (970) 491-2466
        Email: iray@cs.colostate.edu 
    Teaching Assistant:
     Dipesh Gogia
      Office Hours: F 10:00 am-12:00 pm, 6:00 pm- 8:00 pm
      Office: 120 CSB
      Email: dipesh.gogia@colostate.edu 
    January 18 First Day of Class
    February 20 Exam 1
    March 11 Spring Break begins
    March 19 Spring Break ends
    March 24 Exam 2
    April 14 Exam 3
    May 5 Last Day of Class
    May 9 Final Exam

    ©Indrakshi Ray (http://www.cs.colostate.edu/~iray/)