Database Management Systems

BI 1553


According to New Revised Syllabus w.e.f. 2013-14 PUNE, Maharashtra (INDIA)

Text Book of

Database Management Systems


BCA (Pune) Sem-II

Author : Chitra S. Desai (Atole)

Book ID : 1553

More details





1. File Structure and Organization 


 2.Logical and Physical Files   

 3.Basic File Operations  

 4.File Organization

 5.Types of File Organization   

 6. Overview of Indexes    


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


3. Relational Model    

1. Introduction     

2.  Terms

3. Keys 

4. Relational Algebra     

Solved Examples  


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  



No customer comments for the moment.

Write a review

Write a review

4 other products in the same category: