CSE Summer 20

Database Management System Lab (Summer 20)

Mohammad Jahangir Alam photo Mohammad Jahangir Alam
SP Saif Mahmud Parvez
0% complete
0% complete
Resume

  • Course Summary and Objectives

    Week 1
    • lesson icon
      DBMS Lab, PC-A, New Lab, (17-06-2020) Lesson

      DBMS Lab, PC-A, New Lab, (17-06-2020) (Part - 1)

      DBMS Lab, PC-A, New Lab, (17-06-2020) (Part - 2)


      Not available unless: You belong to PC-A

    • Course Goals:

      A database management system (DBMS) is computer application software that provides a way to manage data. The requirement of modern days is to have an automated system that manages, modifies and updates data accurately. This is achieved by a DBMS in robust, correct and non redundant way. DBMS lab aims at practicing and achieving this aim by using various software’s such as SQL, ORACLE, and MS – Access etc. All these require a thorough practice of various DDl, DCL and DML queries.

    • Course objectives:

      This course will enable students to
      • Foundation knowledge in database concepts, technology and practice to groom students into well-informed database application developers.
      • Strong practice in SQL programming through a variety of database problems.
      • Develop database applications using front-end tools and back-end DBMS.

    • Course Outcome

      CO1
      To be able to build database concepts and structures and query language
      To be able to Understand the E R model and relational model

      CO2
      To be able to draw the model of Relational Database using Entity Relationship (ER) model and explain the fundamental elements of Database management System.

      CO3
      To be able to design and build a simple database system and demonstrate competence with the fundamental tasks involved with modeling, designing, and implementing a DBMS.

      CO4
      To be able to evaluate MSSQL/MySQL/Oracle features and MSSQL /MySQL/Oracle related products for maintaining the integrity and performance of enterprise databases.

    • Text Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney




      Database System Concept, Silbertz, Korth and Sudarshan


    • Reference Book

      Oracle Database 10g: The Complete Reference, Author: KavinLoney


      Fundamentals of Relational Database Management Systems, Author: S. Sumathi and S. Esakkirajan.


  • Introduction

  • Week 1

  • Week 2

  • Week 3

  • Week 5

  • Week 6

  • Week 7 (Lab Test)

  • Week 8 (Project Follow Up)

  • Week 9

  • Week 10

  • Week 11 (Final Lab Test)

  • Week 12

  • Week 13 (Final Project Demonstration)

Week 1