1.0 Introduction Database Concepts:
1.1 Introduction, Characteristics of databases, File system v/s Database system, Users of Database system
1.2 Data Independence, DBMS system architecture, Database Administrator
2.0 Entity–Relationship Data Model
2.1 The Entity-Relationship (ER) Model: Entity types: Weak and
strong entity sets, Entity sets, Types of Attributes, Keys,
2.2 Relationship constraints: Cardinality and Participation, Extended
2.3 Entity-Relationship (EER) Model: Generalization, Specialization
3.0 Relational Model and relational Algebra
3.1 Introduction to the Relational Model, relational schema and
concept of keys. Mapping the ER and EER Model to the Relational Model
3.2 Relational Algebra – Unary and set operations, Relational
4.0 Structured Query Language (SQL)
4.1 Overview of SQL, Data Definition Commands, Data Manipulation commands, Data Control commands, Transaction Control Commands.
4.2 Set and string operations, aggregate function - group by, having. Views in SQL, joins , Nested and complex queries, Integrity
constraints :- key constraints, Domain Constraints, Referential
integrity , check constraints
5.0 Relational–Database Design
5.1 Pitfalls in Relational-Database designs , Concept of normalization, Function Dependencies , First Normal Form, 2nd , 3rd , BCNF, multi valued dependencies , 4NF.
6.0 Transactions Management and Concurrency
6.1 Transaction concept, Transaction states, ACID properties, Concurrent Executions, Serializability – Conflict and View, Concurrency Control: Lock-based, Timestamp-based protocols.
6.2 Recovery System: Failure Classification, Log based recovery,
ARIES, Checkpoint, Shadow paging. Deadlock handling
Download our mobile app and study on-the-go. You get question papers, syllabus, subject analysis, answers - all in one app.