CS 430: DATABASE SYSTEMS, SPRING – 2026, Sections 001, 801
DESCRIPTION
CS430 Database Systems is a senior-level undergraduate course exploring various topics in Database Systems.
See the syllabus and course description for more details and important information related to the teaching format we will use.
IMPORTANT DATES
|
Event |
Date |
Time |
Place |
|---|---|---|---|
|
The First day of Class |
Jan 21 (W) |
3 – 4:15 pm |
Pathology 101 |
|
The Last day of Class |
May 7 (W) |
3 – 4:15 pm |
Pathology 101 |
TEXTBOOK
The following book is required for CS430. All other material will be made available on CANVAS (lecture slides, labs, Quizzes, Exams, assignments).
- Database System Concepts Authors: Avi Silberschatz, Henry F Korth, and S. Sudarshan Edition: 7th
Book Cover
Several books that complement the course material are also recommended but not required. These include:
- Database Management Systems by Ramakrishnan and Gehrke, Third Edition, published by McGraw-Hill, 2003.
- Database Systems: The Complete Book by Garcia-Molina, Ullman and Widom, Second Edition, published by McGraw-Hill, 2008.
SPRING 2026 SCHEDULE (TENTATIVE)
This schedule is subject to change as the semester proceeds. New topics may be added or substituted.
|
Week |
Topic |
|---|---|
|
1 |
Introduction to Database Systems |
|
2 |
Relational Model |
|
3 |
Introduction to Database Design |
|
5 |
Normalization |
|
5 |
SQL: Constraints and Triggers |
|
6 |
SQL Queries |
|
7 |
Tree-Based Indexing |
|
8 |
Hash-indexing |
|
9 |
Query Processing |
|
10 |
Query Optimization |
|
11 |
Transaction Processing |
|
12 |
Transaction Processing Protocols |
|
13 |
Crash Recovery |
|
14 |
Application Design and Development |
|
15 |
Data Security and Privacy |
|
16 |
Reviews |
SPRING 2026 LOGISTICS
This is a four-credit course with two prerecorded 75-minute lectures per week. There are NO recitation sections.
|
Section |
Time |
Location |
|---|---|---|
|
001 |
MW 3 – 4:15 pm |
Pathology 101 |
|
801 |
Online |
Online |
EXAM DATES
Examinations must be taken individually. Make-up examinations will not be given under normal circumstances.
|
Exam |
Due Date |
Time |
Place |
|---|---|---|---|
|
Exam 1 |
Feb 23 (Mon) |
3:00 pm to 4:15 pm |
Pathology 101 |
|
Exam 2 |
Mar 30 (Mon) |
3:00 pm to 4:15 |
Pathology 101 |
|
Exam 3 |
Apr 29 (Wed) |
3:00 pm to 4:15 pm |
Pathology 101 |
|
Final |
May 11 (Mon) |
4:10 pm to 6:10 pm |
Pathology 101 |
The table below lists Instructor and Teaching Assistants along with their office hours. The Instructor is also available by appointment.
|
Name |
Role |
Office Hours |
Location |
|
Instructor |
M 1-2:30 PM Tu 2-3 PM |
CSB370 |
|
|
GTA |
W 6-8 PM, Thu 7-8 PM (CSB120) Tue 12-2 PM, W 12-1 PM (CSB460 or MS Teams) |
CSB120, CSB460 |
|
|
GTA |
Sat 12-3 PM (CSB120) Fri 8-11 AM (CSB 120 or MS Teams) |
CSB120 |
|
|
GTA |
M 7-9 PM, Thu 3-4 PM (CSB120) |
CSB120, CSB460 |
LAB SYLLABUS
|
Lab |
Week |
|---|---|
|
Postgres Instructions |
1 |
|
Postgres Examples |
2 |
|
E-R Diagrams |
3 |
|
E-R Diagrams to Tables |
4 |
|
Approaches |
5 |
|
Postgres |
5 |
|
Postgres Cont’d |
6 |
|
LEAP |
7 |
|
Memory hierarchy |
7 |
|
Postgres B-tree |
7 |
|
Postgres hash-index |
8 |
|
Query plans |
9 |
|
EXPLAIN construct |
10 |
|
Locking |
11 |
|
Isolation levels |
12 |
|
ARIES |
13 |
|
JDBC, ODBC Interface |
14 |
|
Views, Roles, Privileges |
15 |
GRADING
The course grading requires the student to demonstrate a grasp of the concepts via homework & lab projects, Quizzes and Exams.
|
Assessment |
Weight |
|---|---|
|
Class Participation (Quizzes) |
10% |
|
Assignments |
25%(On-campus) |
|
Assignments |
35%(online) |
|
Midterm Examination |
45% |
|
Final Examination |
20% |
Tip: pass this course you must satisfy the following requirements:
- Your final grade must be at least 66%.
- You must score at least 50% on all the exams.
If you believe you have been graded unfairly in a lab or assignment, talk with your teaching assistant before meeting with the instructor.
THE FINAL LETTER GRADES
|
Grade |
Score |
|---|---|
|
A |
90 and above |
|
B |
80-89.99 |
|
C |
70-79.99 |
|
D |
60-69.99 |
|
F |
below 60 |
PREREQUISITES
Ability to program in Java is a requirement.
LATE AND MAKE-UP
We hope that students complete all work on time, but the general late policy is 10%/day of the total grade is deducted from the late assignment.
Excused absences may cause a student to miss a lecture or exam. Students must consult with the instructor as soon as possible to make other arrangements, preferably before the event.
- Make-up exams must be arranged with the instructor.
See Policies for more information about attendance.
