Wednesday, November 10, 2021

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

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 

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 


DESCRIPTIVE QUESTIONS -V

QUIZ QUESTIONS - V


 https://meet.google.com/tcg-zgzv-dye