Unit–1:Introduction Overview of database Management System; Various views of data, data Models, Introduction to Database Languages. Advantages of DBMS over file processing systems, Responsibility of Database Administrator,
Unit-2: Introduction to Client/Server architecture, Three levels architecture of Database Systems, E-R Diagram (Entity Relationship), mapping Constraints, Keys, Reduction of E-R diagram into tables.
Unit-3: File Organisation: Sequential Files, index sequential files, direct files, Hashing, B-trees Index files.
Unit-4: Relational Model, Relational Algebra & various operations, Relational and Tuple calculus.
Unit-5: Introduction to Query Languages :QLB , QBE, Structured query language – with special reference of (SQL of ORACLE), integrity constraints, functional dependencies & NORMALISATION – (up to 4
th Normal forms), BCNF (Boyce – code normal forms)
Unit-6: Introduction to Distributed Data processing, parallel Databases, data mining & data warehousing, network model & hierarchical model, Introduction to Concurrency control and Recovery systems
You can download the syallbus pdf here.