Pre-requisites: Data structures and Algorithms
To introduce various components, models and optimization techniques of data storage in a database.
ESSENTIAL TOPICS TO BE COVERED:
Basic database concepts; Entity Relationship modeling, Relational data model and algebra, Structured Query language; RDBMS; Database design, functional dependencies and normal forms; Transaction processing and optimization concepts; concurrency control and recovery techniques; Database recovery techniques; Database security and authorization. Introduction to data mining, object oriented, distributed and multi-dimensional databases. Small Group Project implementing a database
Database Systems by C.J.Date, 8th Edition, Addison Wesley Pub. Co