Description

Instructor:
Russ Wakefield
Office: 240 CS Building
Office Hours: As arranged
Email: Russ.Wakefield@colostate.edu
GTA:
Subhojeet Mukherjee
Office: Online
Office Hours: As arranged
Email: subhomuk@cs.colostate.edu
Lecture Time and Place:
Video, Weekly, Online

Course Goals

This is an introductory course on Database Systems. It introduces the students to the fundamental concepts and methods necessary for designing and implementing database systems. Emphasis will be on the theory and implementation of database systems rather than any commercially available database system.

Course Objectives

Upon completion of this course, students should be able to understand and/or handle the following database components:
  • Database Management Systems
  • Relational Models
  • Relational Algebra and Calculus
  • SQL
  • Relational Database Design
  • Storage and indexing
  • Tree-based indexing
  • Hash-based indexing
  • Overview of Query Evaluation
  • Transaction Management
  • Concurrency Control
  • Recovery

Prerequisites

CS314 or CS370
Knowledge of Java is a requirement.

Grade of C required.

Textbook (Required)

    A. Silberschatz, H. Korth, S. Sudarshan
    Database System Concepts, 6th edition,
    McGraw Hill

Exams

This course requires that all exams are proctored. Proctors are individuals who administer the exam process following the guidelines provided by Colorado State University to ensure academic integrity.

In accordance with Colorado State University proctoring guidelines, students have three options for having online exams proctored for this course:

  1. Take the exam in the CSB110 lab during a scheduled exam period. The schedule will be posted. There is no cost for taking the exam using this option.
  2. Take the exam at the University Testing Center (UTC) on-campus in Fort Collins, CO. Schedule an appointment in advance by calling 970-491-6498. The cost to take an exam at the UTC is included in the cost of the course for those in section 801, those in section 401 are charged a proctoring fee.
  3. Use ProctorU, an online proctoring service, which requires that your computer has a webcam and a microphone. As long as your computer meets the technical requirements, you can take exams on your own computer from the privacy of your own home.

    You must schedule your exams at least three days in advance to avoid paying a fee. Schedule your exams through the ProctorU feature in Canvas. ProctorU offers appointments seven days a week, including night and weekend hours. For full system specifications, please visit: http://proctoru.com/tech.php. The cost for online proctoring through ProctorU is included in the cost of the course. Students are responsible for purchasing any software that may be needed for exams taken with ProctorU, including a webcam and microphone. For more information regarding the ProctorU test-taking process, please visit the following link: How it Works - Test Taker.

All other course material, including course announcements, lecture notes, online quizzes, and assignments may be obtained from the course Canvas page, accessible through http://canvas.colostate.edu/ .

Canvas includes a class bulletin board which is ideal for asking questions about the course, assignments, computer help, etc. Other students may respond with appropriate answers before the instructors or GTA even read the question. As long as no homework solutions are posted, although some hints are permissible, this is perfectly okay. Of course, other students need to judge whether or not these responses are correct. If an answer is questionable, an instructor or GTA will eventually post a response.

All Homeworks & Lab Reports must be submitted electronically through the Canvas course page.

It is critically important that students check out the Schedule on the course website 2-3 times a week. All tests and assignment due dates are posted there. Sometimes this may be the only announcement of an assignment. It is the student's responsibility to continually check for new assignments. Assignment due dates are usually posted 10 days to 2 weeks ahead of time.

Grading

Here are the formally graded elements of the course and associated weighting:

Activity Weight
Lab Assignments 20 %
Homework Assignments 20 %
Quizzes (Canvas) 10 %
Midterm 25 %
Final Exam 25 %

Semester grades are determined by the weighted sum of points earned in each of these areas.

Exams and assignments will be done individually and grades assigned on an individual basis. Further, students not already familiar with the CSU Honor Pledge should review this clear and simple pledge and always adhere to it.

Late and Makeup Policy

Midterm and Finals: Make-up exams are only given for extraordinary circumstances (e.g., illness, family emergency). Students must consult with the instructor as soon as possible, preferably before the start of the exam. Course examination dates are listed in the syllabus; be aware of them and plan accordingly.

Projects: Unless otherwise specified, programming assignments are to be submitted electronically through Canvas. Specifics will be included in each assignment. Always check the assignment page for due dates and late policies.

Important Dates

Midterm ExamsJune 23rd (on campus)
June 21-23 (online)
Final Exams Aug. 3rd (on campus)
August 1-3 (online)

Midterms and final exams will be done as on-line quizzes

Professional Conduct

All students are expected to conduct themselves professionally. We (the instructors and GTAs) assume you are familiar with the policies in the student information sheet for the department. Additionally, you are computing professionals, albeit perhaps just starting. You should be familiar with the code of conduct for the primary professional society, ACM. You can read the ACM Code of Conduct HERE.

We work to maintain an environment supportive of learning in the classroom and laboratory. Towards that end, we require that you be courteous to and respectful of your fellow participants (i.e., classmates, instructors, GTAs and any tutors). In particular:

  • Please turn off the ring on your cell phone. If you are expecting an emergency call, sit near the door and slide out discretely to take it.
  • In class use of electronic devices in general, and laptops specifically, is permitted as a courtesy so that you may better participate and learn. If at any time the instructor judges that an electronic device is becoming a distraction the student may be asked to to turn it off and put it away.
  • All exams and quizzes will be proctored.