:doodle { @grid: 30x30; @size: 100vmax; grid-gap: 1px; } background-color: hsla(@r(360), 85%, @r(70%, 90%), @r(.2)); transform: scale(@rand(.1,.9));

Database management Systems (ITE1003)

Credits : 4

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

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

VinnovateIT
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

2.1 to 2.7

EER diagram has been explained in the following videos: 1 and 2

VinnovateIT
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

VinnovateIT
MODULE 4

Entire module has been explained in this video series: 3.1 to 4.17

VinnovateIT
MODULE 5

Entire module has been explained in this video series: 6.1 to 6.35

VinnovateIT
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

VinnovateIT
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.

VinnovateIT
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

49 to 67

VinnovateIT
MATERIALS

Fundamentals of Database Systems