DATAbase management system

• Course homepage: https://sites.google.com/site/shouvikchakrabortycse/teaching/database-management-system

• Downloads:       

• Reference books:

                                           1. Database System Concepts (6th ed) Silberschatz, Korth, Sudarshan

                                           2. Fundamentals of Database Systems (6th ed) Elmasri, Navathe

                                           3. An Introduction to Database Systems (8th ed) C.J.Date

• Course Lectures (Theory):

  • • • 1. [pdf] Introduction to DBMS ~ Part-I    

        2. [pdf] Introduction to DBMS ~ Part-II        

        3. [pdf] Database Models      

        4. [pdf] Relational Model ~ Part-I   

        5. [pdf] Relational Model ~ Part-II     

        6. [pdf] Relational Model ~ Part-III  

        7. [pdf] E-R Model ~ Part-I  

        8. [pdf] E-R Model ~ Part-II  

        9. [pdf] E-R Model ~ Part-III  

        10. [pdf] E-R Model ~ Part-IV

        11. [pdf] E-R Model ~ Part-V

        12. [pdf] Database Architecture ~ Part-I

        13. [pdf] Database Architecture ~ Part-II

        14. [pdf] Normalization ~ Part-I

        15. [pdf] Normalization ~ Part-II

        16. [pdf] Normalization ~ Part-III

        17. [pdf] Normalization ~ Part-IV

        18. [pdf] Normalization ~ Part-V

        19. [pdf] Normalization ~ Part-VI

        20. [pdf] Normalization ~ Part-VII

        21. [pdf] Relational Algebra ~ Part-I

        22. [pdf] Relational Algebra ~ Part-II

        23. [pdf] Relational Algebra ~ Part-III

        24. [pdf] Relational Algebra ~ Part-IV

        25. [pdf] Relational Calculus ~ Part-I

        26. [pdf] Relational Calculus ~ Part-II

• Course Lectures (Practical)

  • • • 1. [pdf] Oracle 10g XE Installation Instructions - Summary    [pdf] Oracle 10g XE Installation Guide  (Courtesy - Oracle)

        2. [pdf] SQL ~ Part-I

        3. [pdf] SQL ~ Part-II

        4. [pdf] SQL ~ Part-III

        5. [pdf] SQL ~ Part-IV

        6. [pdf] SQL ~ Part-V

        7. [pdf] SQL ~ Part-VI

        8. [pdf] SQL ~ Part-VII

• Questions of internal Examinations:

  • • • 1. [pdf] 1st Internal June 2023 (2021-24 Batch)

        2. [pdf] 2nd Internal June 2023 (2021-24 Batch)

        3. [pdf] 1st Internal March 2024 (2022-25 Batch)

        4. [pdf] 2nd Internal April 2024 (2022-25 Batch)

• Assignments:

  • • • 1. [pdf] 2023 (2021-24 Batch)

        2. [pdf] 2024 (2022-25 Batch)

• Semester Questions

  • • • 1. [pdf] November 2022

        2. [pdf] July 2023 

• Model Questions

  • • • 1. [pdf] Model Question #1