Back to Subjects
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 and Aggregation
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 Algebra Queries.
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
|Chapter||May 16||Dec 16||May 17||Dec 17||May 18|
|Introduction to Database Concepts||15||20||15||25||20|
|Entity-Relationship Data Model||15||25||25||10||25|
|Relational Model and Relational Algebra||20||10||10||20||10|
|Structured Query Language||15||25||-||25||20|
|Transaction management and concurrency||25||20||35||25||20|