Database Management System notes and articles as per MDU syllabus

Characteristics of database approach  

https://www.javatpoint.com/characteristics-of-database-approach-in-dbms

Data models, DBMS architecture and data independence

https://www.javatpoint.com/data-models

https://www.javatpoint.com/dbms-data-model-schema-and-instance https://www.javatpoint.com/dbms-language

E-R Modeling: Entity types, Entity set, attribute and key, Relationships, Relation types, Roles and Structural constraints, Weak entities, Enhanced ER Model

https://www.du.ac.in/du/uploads/departments/Operational%20Research/24042020_E-R%20Model.pdf

https://cs.uwaterloo.ca/~tozsu/courses/CS338/lectures/10%20ER%20Model.pdf

Database Languages: DDL, DML

https://www.javatpoint.com/dbms-language

https://www.idc-online.com/technical_references/pdfs/information_technology/DBMS_Languages.pdf

Database Access for applications Programs, Database Users and Administrator

https://mytechnicalarticles.files.wordpress.com/2010/07/databases-and-database-users1.pdf

Database system Structure, Storage Manager, Query Processor

https://www.geeksforgeeks.org/structure-of-database-management-system/

Logical data base Design

https://www.geeksforgeeks.org/logical-database/

Introduction to views, Destroying/altering Tables and Views.

https://www.javatpoint.com/dbms-sql-view

Relational Algebra and Calculus: Relational Algebra, Set operations, Select ion and project ion, renaming, Joins, Division, Examples of Algebra overviews, Relational calculus: Tuple relational Calculus, Domain relational calculus, Expressive Power of Algebra and Calculus.

https://www.khoury.northeastern.edu/home/kathleen/classes/cs3200/4-RAAndRC.pdf

Concurrency Control: Introduction to Lock Management, Lock Conversions, Dealing with DeadLocks, Concurrency without Locking, Recovery Techniques, Database Security.

https://www.geeksforgeeks.org/concurrency-control-in-dbms/

Introduction to Oracle : Getting started, Modules of Oracle, Invoking SQLPLUS, Data types, Data Constraints, Operators, Data manipulation - Create, Modify, Insert, Delete and Update; Searching, Matching and Oracle Functions.

https://docs.oracle.com/cd/B13789_01/server.101/b10743/intro.htm

Schema Refinement, Functional dependencies: Problems Caused by redundancy, Decompositions, Problem related to decomposition, Normalization : FIRST, SECOND, THIRD Normal forms, BCNF, Lossless join Decomposition, Dependency preserving Decomposition, Schema refinement in Database Design, Multi valued Dependencies, forth Normal Form.

https://wanivipin.files.wordpress.com/2019/02/dbms_notes_unit-2.pdf

Transaction Management: ACID Properties, Transact ions and Schedules, Concurrent Execution of transaction, Serializability and recoverability

https://www.du.ac.in/du/uploads/departments/Operational%20Research/24042020_Transaction%20Management%20in%20DBMS.pdf