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

    Relational Databases
    Entity-Relationships (E-R)  
    Normal Forms (1NF, 2NF, 3NF, BCNF)                 
    Relational Algebra                 
    Relational calculus (optional)
    Structured Query Language (SQL)
	i) Data Definition Language (DDL) Statements: Create Table,
           Create Index, Create View.
        ii) Data Manipulation Language (DML) Statements: Select,
           Insert, Delete, Update, commit, rollback
    SQL Query: set operations, aggregate functions, group by clause,
	nested subqueries
    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.