SCI 251 Database Management

Content

This is a course in database management systems. The students will be taken though a complete cycle of database design. The rst part of the course deals with studying the problems associated with analyzing data requirements. Entity-Relationship (ER) diagrams will be used to specify the requirements. The students will learn how to use SQL. The data specication as captured in the ER diagrams will then be expressed in SQL. The next part of the course deals with learning how to query databases. We rst use the formalism of relational algebra to create queries. After that the course teaches the students how these queries are implemented in SQL. The students will learn how to access a database from within a Java program. In the nal part of the course we discuss several additional topics. We will study le and data structures, as well as indexing techniques. As part of this students will learn about linked lists, queues, stacks, hashing and (binary) search trees. Finally if time permits we will spend some time on security of databases and
cryptographic techniques. The course will also teach the students how to use MySQL, a widely used software package that can be used to implement SQL programs.

Instructor

Prof. Dr. Henk Meijer

Track

Computer Science

Period

Spring / 2012

Course Material

• Elmasri and Navathe, Fundamentals of Database Systems, published by Addison Wesley.

Prerequisites

The following course is required in order to take this course:

• SCI 151 Programming in Java

Additional Prerequisites

Elmasri and Navathe, Fundamentals
of Database Systems"', published by Addison Wesley.

Required for

This course is required in order to take the following course:

• SCI 352 Algorithms for Scientists