Complete Syllabus

UNIT I: Basic Concepts

Data Vs Information and Database Fundamentals
Data Vs Information, Definition of Database, Advantages of Database Systems
CLO01
CO01
Components of DBMS and Architecture
DBMS Components, DBMS Architecture, Data Independence
CLO02
CO02
Data Modelling and Entity Relationship Model
Data Modelling, Entity Relationship Model, ER Diagrams
CLO03
CO03
Database Models: Relational, Network, Hierarchical, Object-Oriented
Relational Model, Network Model, Hierarchical Model, Object-Oriented Model
CLO01CLO03
CO01CO03

Relational Algebra and Operations
Selection, Projection, Cartesian Product, Union, Set Difference, Rename, Join Operations
CLO04
CO03
Tuple and Domain Relational Calculus
Tuple Relational Calculus, Domain Relational Calculus, Quantifiers, Safety of Expressions
CLO04
CO03
SQL DDL, DML, and PL/SQL
Data Definition Language, Data Manipulation Language, PL/SQL Basics, Procedures, Functions, Triggers, Cursors, Exception Handling
CLO04CLO05
CO03

Keys, Constraints, Functional Dependencies, and Normalization
Primary Key, Candidate Key, Super Key, Foreign Key, Composite Key, Domain Constraints, Entity Integrity, Referential Integrity, Functional Dependencies, Armstrong's Axioms, Normal Forms (1NF-BCNF), 4NF and 5NF, Decomposition
CLO03CLO04
CO04

Transactions, ACID Properties, Concurrency Control, and Recovery
Transaction Concept, ACID Properties, Transaction States, Serializability, Conflict and View Serializability, Two-Phase Locking, Timestamp Ordering, Optimistic Concurrency Control, Deadlock Handling, Recovery Techniques
CLO05
CO05

Query Processing, Indexing (B-tree, Hashing), and Advanced Database Systems
Query Processing Steps, Query Optimization, Join Algorithms, Indexing Structures, B-trees and B+-trees, Hashing Techniques, Distributed Databases, Data Warehousing, Data Mining, Mobile and Web Databases
CLO02CLO05
CO05