CS 430/630 Database Management Systems

Spring 2018

  1. Syllabus
  2. Schedule
  3. Instructor & Contact
  4. Resources & Links

Course Objectives

The course will introduce fundamental concepts in relational databases, such as: the relational model and relational algebra; the Standard Query Language (SQL); database design theory; conceptual design; database application development; database security.


Students registering for CS430/630 must have previously completed courses in data structures and discrete mathematics. Also, they are required to have working knowledge of Java and C programming languages, as well as familiarity in using the UNIX operating system.

Topics Covered


R. Ramakrishnan, J. Gehrke, "Database Management Systems", 3rd edition.


Attendance Policy

Class attendance is mandatory, and students are expected to participate actively in class by asking and answering questions. In case of missed class, students are responsible to get up-to-date with course materials and announcements.

Student Conduct

Students are required to adhere to the University Policy on Academic Standards and Cheating, to the University Statement on Plagiarism and the Documentation of Written Work, and to the Code of Student Conduct as delineated in the University Catalog and Student Handbook. The Code is available online at http://cdn.umb.edu/images/life_on_campus/Code_of_Conduct_5-14-14.pdf


Section 504 of the Americans with Disabilities Act of 1990 offers guidelines for curriculum modifications and adaptations for students with documented disabilities. If applicable, students may obtain adaptation recommendations from the Ross Center for Disability Services, CC-UL Room 211, (617-287-7430). The student must present these recommendations and discuss them with each professor within a reasonable period, preferably by the end of Drop/Add period.


Tue/Thu 7:00-8:15pm, M01-0409


Date Lecture Reading
Tue Jan 23 Course Overview and Introduction to Relational Model (slides) (handouts) Textbook: Chapter 1 - all
Exercises: all except 1.5, 1.6, 1.9
Thu Jan 25 Relational Algebra (slides) (handouts) Textbook: Chapter 4 - 4.1, 4.2
Exercises: 4.1-4.5 (skip the parts on calculus)
Tue Jan 30 Relational Algebra Practice Queries (slides) (handouts)
Thu Feb 01 Introduction to SQL. (slides) (handouts)
create.sql, insert.sql, query.sql
Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
Homework 1 (pdf)
Tue Feb 06 Intro to SQL - Practice Queries (slides) (handouts)
Thu Feb 08 SQL Nested Queries (slides) (handouts) Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
Tue Feb 13 SQL Division (slides) (handouts) Textbook: Chapter 4 - 4.2.5, Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
Thu Feb 15 SQL Aggregate Queries (slides) (handouts) Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
Homework 2 (pdf)
Tue Feb 20 SQL Aggregates (contd) Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
Thu Feb 22 SQL Lab: Intro to SQLPlus, Practice SQL Queries.

Instructor: Dr. Gabriel Ghinita

TA: Mohammad Hadianpour