Unit No | Topics |
---|---|
1 | Introduction Introduction and applications of DBMS, Purpose of data base, View of Data, Database Languages, Database architecture, Database users and DBA |
2 | Relational Model Structure of Relational Databases, Database Schema, Keys, Relational Operations and Relational Algebra |
3 | Entity Relationship Model Basic Concepts and definitions, Constraints, Entity Relationship Diagram, Weak Entity Sets, Extended E-R Features, Conversion of ER diagram into relations |
4 | SQL Introduction to SQL, Data Definition of SQL, Basic structure of SQL queries, Basic SQL operations (rename, string operations, order by, where clause), Set operations, Null values, Aggregate functions, Nested Subqueries, Modification of Database, JOIN expressions, Views, Transactions, Integrity constraints, SQL Data types and Schemas, Authorization |
5 | Relational Database Design First Normal Form, Decomposition, Desirable Properties of Decomposition, Functional Dependencies, Second and Third Normal Form and Boyce-Cod Normal Form |
6 | Advanced PL/SQL Concepts Introduction, Cursors, Stored Procedures, Stored Functions, databaseTriggers |
7 | Indexing and Hashing Basic concepts, Ordered Indices, Hash Based Indexing, Tree base Indexing |
8 | Transaction Management and concurrency Transaction concepts, properties of transactions, serializability, testing for serializability, Transaction Isolation and Atomicity, Transaction isolation levels, Implementation of isolation levels, Lock based protocols, Deadlock handling, Timestamp based protocols, two- phase locking protocol |
9 | Query Processing and Query Optimization Overview, Measures of Query Cost, Transformation of Relational Expressions |
Attachment | Size |
---|---|
![]() | 223.93 KB |