Contents

1. Introduction to DBMS   

1. Introduction

2. File System Versus Databases

3. Levels of Abstraction  

4. Structure of a DBMS    

5. Users of a DBMS  

6. Advantages of DBMS

2. Conceptual Design(ER – Model)    

1. Overview of DB Design  

2. Introduction to Data Models 

3. Conceptual Design using E-R Model

4. Constraints 

5. Extended E–R Features  

6. Pictorial representation of E–R model  

7. Structure of Relational Databases

8. DBMS Vs RDBMS    

9. Case Studies on E-R Model  

3. SQL    

1. Introduction to Query Languages  

2. Basic Structure of SQL 

3. Data Definition Language (DDL)   

4. DML Commands 12

5. Forms of a Basic SQL Query  

6. Set Operations   

7. Aggregate Function

8. Null Values 

9. Nested Queries   

10.SQL Mechanism for Joining Relations

11.Views

4. Relational Database Design  

1. Introduction to Relational Database Design  

2. Functional Dependency  

3. Concept of Decomposition

4. Concept of Normalization    

5. Key Concepts with Examples