Introduction to database systems: Data Independence, Data Models, Levels of abstraction, structure of DBMS

Data models and query languages: Relational Model, Relational Languages, Query Languages: Relational Algebra, Relational Calculus, SQL, QUEL, QBE, Integrity constraints, Aggregate operators, Embedded and Dynamic SQL.

Database design: E-R Model, Functional dependencies, Decomposition, Normalization, Multivalued dependencies.

Concurrency control and recovery: Transaction, Schedules, Lock-based concurrency, Lock management, Concurrency control without locking, Crash recovery- log, check-pointing, media recoveries.

File Organization: Storage, Buffer management, Disk Management, File organization techniques, Indexing.

Query Processing and Optimization: Query processing on various operations, Translating SQL queries, Estimating the cost.

Advanced topics: Database Security, Distributed databases design, Object Oriented database design & its implementation, Introduction to recent advances in database technology.

To provide students with basic concepts in databases both in terms of usage and implementation

To make the students understand all requirement and operations that the analyst needed to analyze, design, and implement the systems

Aware of various database systems and its design issues

Design and implement a database for any specified domain according to well-known design principles that balance data retrieval performance with data consistency guarantees

Formulate data retrieval queries in SQL and the abstract query languages

E. Ramez, N. Shamkant, Fundamentals of Database System, Pearson Education

A. Silberschatz, H. F. Korth & A. Sudarshan, Database System Concepts, McGraw Hill, 5th ed, 2006

Raghu Rama Krishnan and J. Gehrke, Database Management Systems, 3rd Edition, McGraw Hill

E. Foster, S. Godbole, Database Systems, Taylor & Francis Ltd

Computer [Electronic ISSN: 1558-0814]