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.
Prerequisites
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
-
The Relational Data Model and Relational Algebra
-
Standard Query Language (SQL)
-
The Entity-Relationship Data Model
-
Database Design Theory
-
Database Application Development
-
Database Security
Textbook
R. Ramakrishnan, J. Gehrke,
"Database Management Systems", 3rd edition.
Grading
-
Midterm Exam 1: 30%
-
Midterm Exam 2: 30%
-
Homework Assignments: 4 x 10%
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
Accommodations
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.
Time/Venue
Mon/Wed 7:00-8:15pm, W-01-0004
Schedule
| Date |
Lecture |
Reading |
| Wed Sep 03 |
Course Overview and Introduction to Relational Model
(slides)
(handouts)
|
Textbook: Chapter 1 - all
Exercises: all except 1.5, 1.6, 1.9
|
| Mon Sep 08 |
Relational Algebra
(slides)
(handouts)
|
Textbook: Chapter 4 - 4.1, 4.2
Exercises: 4.1-4.5 (skip the parts on calculus)
|
| Wed Sep 10 |
Relational Algebra Practice Queries
(slides)
(handouts)
|
|
| Mon Sep 15 |
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
|
| Wed Sep 17 |
Introduction to SQL. (contd.)
|
Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
|
| Mon Sep 22 |
Intro to SQL - Practice Queries
(slides)
(handouts)
|
|