CS 4660 Database Architecture (4) 2005

Catalog Description

Relational, network, and hierarchical data models. Data description and data manipulation languages. Schemas, query processing, database system architecture. Integrity, concurrency, and security techniques. Distributed databases. Prerequisite: CS 3240.

Topics

  1. Relational Databases
  2. Entity-Relationships (E-R)
  3. Normal Forms (1NF, 2NF, 3NF, BCNF)
  4. Relational Algebra
  5. Relational calculus (optional)
  6. Structured Query Language (SQL)
    1. Data Definition Language (DDL) Statements: Create Table, Create Index, Create View.
    2. Data Manipulation Language (DML) Statements: Select, Insert, Delete, Update, commit, rollback
  7. SQL Query: set operations, aggregate functions, group by clause, nested subqueries
  8. Stored Procedures (optional)

Text:

  • A First Course in Datavase Systems, Ullman and Widom, Prentice Hall, 1997.
  • An Introduction to Database Systems, C. J. Date, Addison-Wesley, 1995.
  • Database System Concepts, Silberschatz, Korth, Sudarshan, McGraw-Hill, 1996.
  • O'Neil & O'Neil Database: Principles, Programming and Performance, Morgan Kauffman, 2000.
  • Ramakrishan & Gehrke, Database Management Systems.