Topic outline

  • Welcome to the course

    CSE312: Database Management System Lab  

    • Welcome Note Forum

      Dear Students,
      Welcome to the 2021 Fall Semester, Students. Let's starts our journey with a nice Quote from DBMS....



      Instructor's Information:
      Instructor Name:       Afjal Hossan Sarower
      Designation:               Lecturer

      Email:                        afjal.cse@diu.edu.bd

  • Course Summary and Objectives

    • 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 a 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
      1. Foundation knowledge in database concepts, technology, and practice to groom students into well-informed database application developers.
      2. Strong practice in SQL programming through a variety of database problems.
      3. 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.

  • This topic

    Marks Distribution


    Attendance

    10

    Lab Performance

    25

    Project

    25

    Final Exam + Viva

    40

    • Topic 16

      • Topic 17

        • Topic 18

          • Topic 19

            • Topic 20

              • Topic 21