DBMS COMPLETE NOTES + SPPU PYQ's
About this PDF
It contains unit wise SPPU pyqs with all the DBMS Notes Unit Conatins- Unit I - Introduction to Database Management System Introduction to Database Management Systems, Purpose of Database Systems, Database-System Applications, View of Data, Database Languages, Database System Structure, Enterprise Constraints Data Models, Database Design and ER Model: Entity, Attributes, Relationships, Constraints, Keys, Design Process, Entity Relationship Model, ER Diagram, Design Issues, Extended E-R Features, Converting E-R & EER diagram into tables. Unit II - SQL and PL/SQL SQL: DDL, DML, Select Queries, String, Date and Numerical Functions, Aggregate Functions ,View, Indexes, Group by and Having Clause, Join Queries, Set, Set operation, Set membership, Nested queries, DCL, TCL PL/SQL: Control Statement, Cursor, Stored Procedure and Function, Trigger Unit III - Relational Database Design Relational Model: Basic concepts, Attributes and Domains, CODD’s Rules, Relational Integrity, Referential Integrities, Database Design: Features of Good Relational Designs, Normalization, Atomic Domains and First Normal Form, Decomposition using Functional Dependencies, 2NF, 3NF, BCNF. Unit IV - Database Transactions Basic concept of a Transaction, Transaction Management, Properties of Transactions, ACID, Concept of Schedule, Serial Schedule, Serializability: Conflict and View, Cascaded Aborts, Recoverable and Non-recoverable Schedules, Concurrency Control: Need, Locking Methods. Unit V - NoSQL Database Introduction to NoSQL Database, NoSQL data models, CAP theorem and BASE Properties, Comparative study of SQL and NoSQL, MongoDB: CRUD Operations, Indexing and Aggregation.
What you get
What’s in this bundle
6 PDFs, all unlocked together right after payment.
₹35₹35₹35₹35₹35₹15Worth ₹190 separately. Bundle price ₹135.
Details
- Format
- Bundle of 6 PDFs
- Language
- English
- Sold by
- Disha Singh
- Published
- 19 November 2026












