|
Catalog Data |
The course stresses design of databases and
implementation using a relational database management
system. Topics include data modeling, relational
algebra, normalization, design, a query language, such
as SQL, optimizing performance, client server databases
and distributed databases.
Prerequisites: Math 141 and CS 234
One semester three credits.
|
| Textbook |
Database System Concepts, 4th edition,
Silberschatz, Korth, Sudarshan, McGraw-Hill, 2002
|
| Prerequisites |
You must have fundamental skills in problem solving,
the design of algorithms, object oriented programming
and a working knowledge of C++ or Java.
|
| Goals |
You will learn basic concepts of design and
implementation of database systems. You will learn
how to query a database and how to design its structure.
You will implement designs using Oracle.
|
Syllabus |
| Topic |
Chapter |
|---|
|
Introduction to database systems
| 1
|
The entity relational model
ER diagrams
| 2
|
The relational model
relations, tables, keys, constraints
| 3
|
SQL - Structured Query Language
queries, views, embedded SQL
| 4
|
Integrity and security
| 6
|
Relational database design
normalization, Boyce Codd normal form
| 7
|
Object oriented databases
| 8
|
Object relational databases
| 9
|
|
Query procssing
| 13
|
|
Topics
|
|
|
Tests
|
|
|
| Final Exam |
The final exam is comprehensive.
|
| Attendance |
You must attend class regularly.
|
|