SE IT SEM 3 – DATABASE MANAGEMENT SYSTEM

Module 1 – Database System Concepts & Architecture
8 Topics
1.1 Introduction
1.2 Characteristics of database
1.3 File system V/S database system
1.4 Data abstraction and data independence
1.5 DBMS system architecture
1.6 Database administrator (DBA)
1.7 Role of DBA
1.8.a Self -learning topics
Module 2 – The Entity-Relationship Model
10 Topics
2.1 Conceptual modeling of database
2.2 The Entity-Relationship (ER) model
2.4 Entity type
2.5 Attribute and keys
2.6 Relationship types
2.7 Relationship sets
2.8 Weak-entity types
2.9 Generalization, specialization and aggregation
2.10 Extended Entity-Relationship (EER) model
2.11.a Self -learning topics – Design and ER model for any real time case study
Module 3 – Relational Model & Relational Algebra
11 Topics
3.1 Introduction to relational model
3.3.a Concept of keys – Primary key
3.3.b Concept of keys – Secondary key
3.3.c Concept of keys – Foreign key
3.4 Mapping the ER and EER model to relational model
3.5 Introduction to relational algebra
3.6.a Relational algebra expressions for unary relational operations – Set theory operations
3.6.b.1 Binary relational operations – Join operation
3.6.b.2 Binary relational operations – Difference operation
3.7 Relational algebra queries
3.8.a Self -learning topics – Map the ER model designed in module II to relational schema
Module 4 – Structured Query Language (SQL) & Indexing
16 Topics
4.1 Overview of SQL
4.2 Data Definition Commands
4.3 Set operations
4.4 Aggregate function
4.5 Null values
4.6 Data manipulation commands
4.7 Data control commands
4.8 Complex retrieval queries using Group By
4.9 Recursive queries
4.10 Nested queries
4.11 Integrity constraints in SQL
4.12 Database programming with JDBC
4.14 Grant and revoke in SQL functions
4.15 Procedures in SQL and cursors
4.16.a Indexing – Basic concepts and Ordered indices
4.17.a Self -learning topics – Physical design of database for the relational model designed in module III and fire various query
Module 5 – Relational Database Design
6 Topics
5.1 Design guidelines for relational schema
5.2 Functional dependencies
5.3 Database tables and normalization
5.4 The need for normalization
5.6 Improving the design
5.8.a Self -learning topics – Consider any real time application and normalization into 3NF/BCNF
Module 6 – Transactions Management & Concurrency & Recovery
12 Topics
6.1.a Transaction – Transaction concept
6.1.b Transaction – State diagram
6.1.c Transaction – ACID properties
6.1.d Transaction – Transaction control commands
6.1.e Transaction – Concurrent executions
6.2.a Serializability – Conflict and view
6.3.a Concurrency control – Lock-based protocols
6.3.b Concurrency control – Deadlock handling
6.3.c Lock-based protocols – Timestamp based protocols
6.4.a Recovery system – Recovery concepts
6.4.b Recovery system – Log-based recovery
6.5.a Self -learning topics – Study the various deadlock situation which may occur for a database designed in module V.
Previous Topic
Next Topic

4.15 Procedures in SQL and cursors

SE IT SEM 3 – DATABASE MANAGEMENT SYSTEM Module 4 – Structured Query Language (SQL) & Indexing 4.15 Procedures in SQL and cursors
Previous Topic
Back to Lesson
Next Topic