Contents

1. File Structure and Organization 

 1.Introduction     

 2.Logical and Physical Files   

 3.Basic File Operations  

 4.File Organization

 5.Types of File Organization   

 6. Overview of Indexes    

 Summary 

2. Database Management System

1.   Introduction     
2.   Basic Concept and Definitions

3. Definition of DBMS     

4. File Processing System Vs DBMS     

5. Advantages and Disadvantages of DBMS     

6. Users of DBMS    

7. View of Data     

8. The Three Level Architecture of DBMS     

9. Overall System Structure     

10. Features and Capabilities of DBMS  

11. Data Model 

12. Object Based Logical Model   

13. Record Based Logical Model   

14. Entity Relationship Model    

15. Entity Relationship Diagram (ERD)  

16. Extended Features of ERD     

17. The Object-Oriented Model    

18. Case Study for E-R Diagrams  

Solved Case Study

Summary    

3. Relational Model    

1. Introduction     

2.  Terms

3. Keys 

4. Relational Algebra     

Solved Examples  

Summary    

4. SQL(Structured Query Language)  

1. A Brief History of Databases 

2.  Structured Query Language (SQL)    

3. SQL is a Standard

4.  View 

5. Relational Database Design

1. Introduction     

2. Integrity Constraints  

3. Normal Form

4. Functional Dependency  

5.  First Normal form

6. Second Normal Form     

7.  Third Normal Form

8.  Boyce-Codd Normal Form (BCNF)

9. Examples   

Solved Examples  

Summary