.png)
NOTE:
Database Management systems is an important course and some attention has to be given here. While some of the modules like module 1 are completely theory-based, modules like functional dependency and relational algebra depend on practice and require certain attention.
Gate Smashers and Knowledge Gate have excellent resources for this subject
MODULE 1:Fundamental Concepts and Architecture
Introduction to the database system, Characteristics of the Database Approach, Actors on the Scene, Workers behind the Scene, Advantages of using the DBMS Approach, Data Models, Schemas, and Instances, Three-Schema Architecture and Data Independence, The Database System Environment, Centralized and Client/Server Architectures for DBMSs, Classification of Database Management Systems
Mostly Theory, refer to faculty notes
MODULE 2:
The important topics to be covered are ER and EER diagrams
ER Diagram has been explained properly in these video series by Knowledge Gate
EER diagram has been explained in the following videos: 1 and 2
MODULE 3:
Refer to the notes uploaded by Bimal Kumar Ray to understand the relational model and its constraints Refer for relational algebra: 7.1 to 7.9
MODULE 4:
Entire module has been explained in this video series: 3.1 to 4.17
MODULE 5:
Entire module has been explained in this video series: 6.1 to 6.35
MODULE 6:
Recover and Security
For brief understanding of the topic watch Log Based Recovery and Gate Smashers video
For detailed database Security and Recovery Techniques refer to the notes of Bimal Kumar Ray
MODULE 7:
This video series has indexing, B+ trees, and Hash-based indexing: 5.1 to 5.10 For Query optimization refer to the notes uploaded by Bimal Kumar Ray.
MODULE 8:
Lab (SQL) Refer to this video series to learn SQL language 8.1 to 8.13
OR Refer to Gate Smashers playlist for a detailed understanding of query language
Course Code - ITE1003
Credits - 4
Modules - 8