DBMS PYQS UNIT WISE
DBMS PYQS UNIT WISE 2

DBMS PYQS UNIT WISE

Instant access Secure payment PDF · 12 pages

About this PDF

It contains unit wise SPPU pyqs 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.

Topics covered

Headings from inside this PDF (12 pages in total).

  1. UNIT 1
  2. UNIT 2
  3. 1. Consider the following schemas [6]
  4. 3. Explain cursor in SQL with example. [4]
  5. 6. What is sequence? How to create and use sequence in SQL?
  6. 7. Consider following schema [4]
  7. 9. Consider following schema [5]
  8. 10. Consider the following relation schema [6]
  9. 12. What is synonym? How to create and use synonym in SQL?
  10. 19. Consider following schema. [5]

What you get

Instant access right after payment
Read the PDF online, anytime
Secure UPI / card / netbanking checkout

Details

Format
PDF · 12 pages
Pages
12 pages
Language
English
Size
936 KB
Delivery
Read PDFs online — not downloadable, instantly after payment
Access
365 days from purchase
Sold by
Disha Singh
Published
19 November 2026
One-time price · instant access
₹15 Read-only

Secure UPI / card / netbanking · Instant access

Already bought this? Open My purchases