Pre-requisites: Data structures and Algorithms
COURSE OBJECTIVES:
To introduce various components, models and optimization techniques of data storage in a database.
ESSENTIAL TOPICS TO BE COVERED:
- Basic Database concepts
- Relational Database System: understanding, query and report
- Various problems in Database management and their solutions
COURSE DESCRIPTION:
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
Recommended Text(s):
- Database Systems: A Practical Approach to Design, Implementation and Management by R.Connolly and P.Begg, 4th Edition, Addison-Wesley Pub. Co (2003)
Database Systems by C.J.Date, 8th Edition, Addison Wesley Pub. Co
