Sr. No.

Content

Total 
Weightage 

Database system architecture:

Data Abstraction, Data Independence, Data
Definition Language (DDL), Data Manipulation Language (DML).

Data models:

Entity-relationship model, network model, relational and
object oriented data models, integrity constraints, data manipulation
operations.

Relational query languages:

Relational algebra, Tuple and domain
relational calculus, SQL3, DDL and DML constructs, Open source and
Commercial DBMS – MYSQL, ORACLE, DB2, SQL server.

Relational database design:

Domain and data dependency, Armstrong’s
axioms, Normal forms, Dependency preservation, Lossless design.

Query processing and optimization:

Evaluation of relational algebra
expressions, Query equivalence, Join strategies, Query optimization algorithms.

Storage strategies:

Indices, B-trees, hashing.

Transaction processing:

Concurrency control, ACID property,
Serializability of scheduling, Locking and timestamp based schedulers,
Multi-version and optimistic Concurrency Control schemes, Database
recovery.

Database Security:

Authentication, Authorization and access control, DAC,
MAC and RBAC models, Intrusion detection, SQL injection.

SQL Concepts :

Basics of SQL, DDL,DML,DCL, structure – creation,
alteration, defining constraints – Primary key, foreign key, unique, not null,
check, IN operator, aggregate functions, Built-in functions –numeric, date,
string functions, set operations, sub-queries, correlated sub-queries, join,
Exist, Any, All , view and its types., transaction control commands.

PL/SQL Concepts :

Cursors, Stored Procedures, Stored Function,
Database Triggers