Basic database concepts; Entity Relationship modeling, Relational data model and Relational algebra, Structured Query language; RDBMS; Database design, functional dependencies and normal forms; Transaction processing and optimization concepts; concurrency control and recovery techniques; Database security and authorization. Small Group Project implementing a database; Physical database design: Storage and file structure; indexed files; hashed files; Database efficiency and tuning; Data Warehousing and Data Mining, Emerging Database Technologies and Applications.

Course Syllabus