PYTHON BY DURGA SOFT

 CLICK HERE TO DOWNLOAD

STRINGS - TUPLES - SETS - DICTIONARIES

Cheat Sheet for Regular Expression  ( Courtesy: www.dataquest.io )

R20 DBMS LAB

 Constraint Syntaxes in Mysql

working on sailors in SQL Video's

Cycle -II work

Cycle-III employee table need to complete the all the queries 

PL/SQL works

R20 DBMS course Content

 

click here to download  Database System Concepts 7th edition 

click here to download Database Systems - Design, Implementation, and Management (9th Edition)

SEM papers:

R17-DBMS SUPPLY - EXAM DATE 25-10-2021

R17 -DBMS REGULAR - 09-04-2021

R17-DBMS-REGULAR-13-11-2019

R17-DBMS-REGULAR-06-05-2019

R14-DBMS SUPPLY 10-05-2019

UNIT- I

Introduction: An overview of Database Management System

Data Modelling using the Entity Relationship Model

Database Systems - Design, Implementation, and Management (9th Edition)-34-58

Database-System-Concepts-7th-Edition-30-63

DESCRIPTIVE QUESTIONS -I

ASSIGNMENT  (LAST DATE FOR SUBMISSION IS (02-12-2021)

QUIZ QUESTIONS - I

UNIT - I PPT

University Database Case Study for ER diagram:

Movie Data Base Case Study  for ER diagram

Airport Data Base Case Study for ER diagram

UNIT- II

Relational Data Model and Language

Introduction to SQL

Types of Joins

SQL joins

Relational Algebra

DESCRIPTIVE QUESTIONS -II

QUIZ QUESTIONS - II

UNIT- III

Database Systems - Design, Implementation, and Management (9th Edition)[204-246]

Normalization Notes

Normalization PPT

Transaction Management and Concurrency Control

DESCRIPTIVE QUESTIONS -III

QUIZ QUESTIONS - III

UNIT- IV

TRANSACTION ppt

TRANSACTION CONFLICTS/ANOMALIES ppt

CONCURENCY CONTROL ppt 

Transaction Processing Concepts notes 

Database Systems - Design, Implementation, and Management (9th Edition)-444-474

DESCRIPTIVE QUESTIONS -IV

QUIZ QUESTIONS - IV

UNIT- V

Indexing

LEVELS OF RAID

RAID

 Hashing notes

Hashing ppt

Storage 

PROFESSIONAL NO SQL 

Physical Storage Systems 

DESCRIPTIVE QUESTIONS -V

QUIZ QUESTIONS - V