DATABASE MANAGEMENT (CS630/CS430)

SPRING 2011

Instructor: Prof. Dan Simovici

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:

• First handout (a pdf file)
• Second handout (a pdf file)
• Third handout (a pdf file)
• Fourth handout (a pdf file)
• Fifth handout (a pdf file)

Homeworks:

Homeworks will be posted here.

First homework (an html file)

Second and Third homework (a pdf file)

Fourth homework (a pdf file)