INTRODUCTION
DATA MODELS
- Logical, Physical and Conceptual
- E-R Model
- Entities and Entities sets
- Relationship and Relationship sets
- Strong and Weak Entity Sets
- Attributes and Keys
- E-R Diagram
- Alternate Data Model (hierarchical, network, graph)
- ER Diagram-Solved Question
- Relational Model
- ER Diagram to Table Conversion Rule
- ER Diagram Practice Questions
- Generalization and Specializaiton in DBMS
RELATIONAL LANGUAGE AND RELATIONAL MODEL
DATABASE CONSTRAINTS AND NORMALIZATION
FILE STRUCTURE AND HASHING
QUERY PROCESSING AND OPTIMIZATION
TRANSACTION PROCESSING AND CONCURRENCY CONTROL-DBMS
CRASH RECOVERY
ADVANCED DATABASE CONCEPT
PRACTICAL-LAB WORK DBMS
PRACTICE QUESTION - ER DIAGRAM
Lab 2- SQL Queries for Schema
LAB 2: WRITE A SQL QUERY FOR GIVEN SCHEMA IN E COMMERCE SYSTEM AND ANALYSE IT