DATABASE MANAGEMENT (CS630/CS430)
SPRING 2011
Office Tel.: 287-6472, Home Tel:
731-3297 (between 9:00 a.m and 9:00 p.m.)
dsim@cs.umb.edu
www.cs.umb.edu/cs630
Office hours: Tuesday and
Thursday, from 5:00 to 6:00 p.m. or by appointment.
Prerequisites: a data structures course,
knowledge of Java, C, and UNIX.
This course is an introduction to database
management systems. It is important that you approach this course after taking
courses in data structures and in discrete mathematics. We assume that you have a working knowledge
of C, Java, and UNIX.
Course objectives:
- Learning to use the entity/relationship model to organize data
- Understanding the capabilities and limitations of the relational
- Applying relational algebra to define the sematics of SQL
- Understanding the capabilities and limitations of SQL
- Learning application development principles through
embedding SQL in higher-level languages (Java and C)
- Understanding normalization techniques for the
relational model
Grading: your grade is
determied by four equal components: homework, a mid-term, a final (both
with open books), and your class participation.
The main reference consists of
the handouts that will be posted on this web site. Other references will
be indicated as the course develops.
We shall cover the following topics:
- General facts about databases and DBMSs.
- The entity-relationship model.
- The relational model.
- Relational algebra.
- The SQL query language.
- SQL embedded in C.
- Procedural extensions of SQL.
- Java and SQL.
- Object-relational databases.
- Relational database design.
All work in this course will be done on
dbs2. Please be sure that you get a cs630
course account.
Please note:
- You must apply for a CS630 account, as you usually do for any
computer science course. Do this as soon as possible, since we
will have to authorize you to use the Oracle database.
- No late homeworks will be accepted. Your homework must be
entirely yours.
- Presentation of homeworks and exams is very important. You should write in a neat and legible
way.
To access Oracle documentation visit the
ORACLE TECHNOLOGY NETWORK
Handouts:
Homeworks:
Homeworks will be posted here.
First homework
(an html file)
Second and Third homework
(a pdf file)
Fourth homework
(a pdf file)