CS 430: Database Systems (Spring 2018)


  • 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: 5:00 pm to 6:15 pm on Tuesday and Thursday 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.

    All Assignments will be posted on canvas.

    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 22 5:00 pm to 6:15 pm Clark A 203
    Exam 2  Apr 3 5:00 pm to 6:15 pm Clark A 203
    Exam 3  Apr 24 5:00 pm to 6:15 pm Clark A 203
    Final  May 8 8:30 pm to 10:30 pm Clark A 203
  • Instructor:
       Indrakshi Ray
        Office Hours: TBD
        Office: 440 CSB
        Phone: (970) 491-7986
        Fax: (970) 491-2466
        Email: iray[at]cs.colostate.edu 
    Teaching Assistant:
     Rejina Basnet
      Office Hours: Tuesday and Thursday 8:00 am to 10:00 am
      Office: 120 CSB
     
     
      Email: rejina.basnet[at]colostate.edu 
    Teaching Assistant:
     David White
      Office Hours: Tuesday 2:00 pm to 4:00 pm and Thursday 10:00 am to 12:00 am
      Office: 120 CSB
     
     
      Email: david.white[at]colostate.edu 

    Course Email: cs430[at]cs.colostate.edu

    January 16 First Day of Class
    February 20 Exam 1
    March 10 Spring Break begins
    March 19 Spring Break ends
    March 20 Exam 2
    Aprily 24 Exam 3
    May 4 Last Day of Class
    May 8 Final Exam

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