DATABASE MANAGEMENT SYSTEMS

DATABASE MANAGEMENT SYSTEMS

Important link for learning DBMS

INTRODUCTION : PPS

THE ENTITY RELATIONSHIP MODEL : PPS

THE RELATIONAL  MODEL: PPS

THE RELATIONAL  MODEL : PPS

• Sample SQL Creates and Views:  Schema (Word), LicView (Word), CA View (Word)

ER TO RELATIONAL TRANSFORMATION : PPS

FUNCTIONAL DEPENDENCIES AND NORMALIZATION IN DATABASES : PPS

DESIGN, STORAGE, INDEXING : PPTp1  and  PPTp2

SYSTEM CATALOG AND QUERY OPTIMIZATION : PPS 

TRANSACTION PROCESSING AND CONCURRENCY CONTROL : PPS

RECOVERY : PPS

SECURITY : PPS

• Dynamic Coalition Problem  - Overheads: PPT

DISTRIBUTED DBMS, DATA WAREHOUSES AND DATA MINING, WEB-BASED DB ARCHITECTURES

• PPS1
  
• PPS2
  

SOFTWARE  DESIGN, JAVA, REQUIREMENTS 

• Readings: Software Design (PS) 
• Overheads: PPT
  
• Readings: Overview on Java/Risks & BenefitsPostscript or PDF 
• Java Slides: PPT
  
• Java Risks and Benefits: PPT
  
• Software Requirements Specification: PPT
  

UML: UNIFIED MODELING LANGUAGE 

• WebSites: OMG/UML & TOGETHER PRESENTATIONS
• Readings: UML Introduction & UML Specification - Different Formats 
• Overheads: UML Overview (PPT) & UML Example (PPT)
• Rational Overheads: Booch PPT, Rumbaugh PS, Jacobsen PPT

All the best