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, M-02-0423
Schedule
| Date |
Lecture |
Reading |
| Mon Sep 14 |
Relational Algebra
(slides)
(handouts)
|
Textbook: Chapter 4 - 4.1, 4.2
Exercises: 4.1-4.5 (skip the parts on calculus)
|
| Wed Sep 16 |
Relational Algebra (contd.)
|
|
| Mon Sep 21 |
Relational Algebra Practice Queries
(slides)
(handouts)
|
|
| Wed Sep 23 |
Relational Algebra Practice Queries (contd.)
|
|
| Mon Sep 28 |
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 30 |
Introduction to SQL. (contd.)
|
|
| Mon Oct 05 |
Intro to SQL - Practice Queries
(slides)
(handouts)
|
|
| Wed Oct 07 |
SQL Nested Queries
(slides)
(handouts)
|
Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
|
| Mon Oct 12 |
No Class - Public Holiday
|
|
| Wed Oct 14 |
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
|
| Mon Oct 19 |
SQL Aggregate Queries
(slides)
(handouts)
|
Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
|
| Wed Oct 21 |
SQL Aggregates - Practice Queries
(slides)
(handouts)
|
Textbook: Chapter 5 - 5.1-5.7
Exercises: 5.1-5.5, 5.7-5.8
|
| Mon Oct 26 |
Oracle SQLPlus Lab
|
|