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 specication 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.
Prof. Dr. Henk Meijer
Computer Science
Spring / 2012
The following course is required in order to take this course:
Elmasri and Navathe, Fundamentals
of Database Systems"', published by Addison Wesley.
This course is required in order to take the following course: