Section outline

  • General

    Collapse all Expand all

    • forum icon
      Welcome Note Forum
      Dear Students,
      Welcome to the Database Management System Lab course. I'm excited to have you in the class.  Good luck and I hope you will enjoy the course!

      dd

      Instructor 

      : Fahmida Afrin (FA)

      Designation

      : Lecturer

      Office address

      : Room no 414, Level 4, CSE Building, DIU(MC)

      Email

      :  fahmida.cse@diu.edu.bd
    • Students must
      Mark as done

      Navigation

        

      Week2Go:   WK1    WK2    WK3    WK4    WK5    WK6   WK7    WK8    WK9    WK10    WK11    


    • Students must
      Mark as done
    • Students must
      Mark as done

      Lab Course Grading System

      Class Attendance: 10%

      Lab Final: 40%

      Lab Performance & Assignment: 25%

      Project Submission: 25%


    • Students must
      Mark as done
      Telegram Group Link Section O3:  Click Here


      Telegram Group Link Section O5:  Click Here

  • 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 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.


  • Week 1

    Lab 1

    • resource icon
      Relational Model in DBMS File
    • resource icon
      Road way travels E-R Diagrams File
    • forum icon
      Discussion Forum Week -1
      Students must
      Mark as done
    • Students must
      Mark as done

      Topics of Discussion:

      How to install XAMPP, basic of XAMPP.

      Basic of the Relational model concept, Key Constraints.

      Expected Learning Outcomes:

      Learn to create a relational table using SQL and retrieve data from more than one table.

    • url icon
      Database Tool Installation (SQL or MySql) URL
    • Students must
      Mark as done


    • url icon
      Xampp Download URL
      Students must
      Mark as done
    • url icon
      Live SQL URL
      Students must
      Mark as done

  • Week 2

    Lab 2

    • Students must
      Mark as done

      Topics of Discussion:

      The basic of DDL:  Create DB, Drop DB, Create Table, Drop Table, Alter Table. 

      basic query operations on the table: Insert, Select, from, where.

      Expected Learning Outcomes:

      Learn to write Data Definition Language and basic SQL.

    • resource icon
      Lab-1 Slides File
      Students must
      Mark as done
    • forum icon
      Discussion Forum Week -2
      Students must
      Mark as done
    • url icon
      Live SQL URL
      Students must
      Mark as done

  • Week 3

    Lab 3

    • url icon
      DDL and DML commands URL
    • Students must
      Mark as done

      Topics of Discussion:

      The basics of DML:  Select, From, Where, And, Or, Not, Distinct, Order by, Between, Like, etc.

      Expected Learning Outcomes:

      Learn to write Data Manipulation Language and basic SQL.

    • Students must
      Mark as done
    • url icon
      w3schools URL
      Students must
      Mark as done
    • assign icon
      Lab Task Submission Assignment
      Students must
      Mark as done
    • forum icon
      Discussion Forum Week -3
      Students must
      Mark as done
    • url icon
      Live SQL URL
      Students must
      Mark as done
    • assign icon
      Lab Task Assignment

  • Week 4

    Lab 4

    • Students must
      Mark as done

      Topics of Discussion:

      The basic SQL: Update, Delete, Aggregate Function, Group By, Having.

      Expected Learning Outcomes:

      Learn to write SQL operations.

    • Students must
      Mark as done


    • url icon
      Aggregate functions URL
    • forum icon
      Discussion Forum Week-4
      Students must
      Mark as done

  • Week 5

    Lab 5

    • Students must
      Mark as done

      Topics of Discussion:

      The basic structure of an SQL expression: Foreign Key and Referential Integrity.

      How to retrieve data from two tables. 

      basic query operations on the table.

      Expected Learning Outcomes:

      Learn to create a relational table using SQL and retrieve data from more than one table.

    • forum icon
      Forum
      Students must
      Mark as done

  • Week 6

    Lab 6

    • Students must
      Mark as done

      Topics of Discussion:

      The basic of Sub-Query and Join.

      Expected Learning Outcomes:

      Learn to write SQL using Sub-Query and Join.

    • url icon
      Join Operation in DBMS URL
    • forum icon
      Forum
      Students must
      Mark as done

  • Week 7 MID Exam

    Lab 7



  • Week 8

    Lab 8

    • Students must
      Mark as done

      Topics of Discussion:

      SQL Sub-Query: Any, All, In, etc.

      Expected Learning Outcomes:

      Learn to write SQL using Sub-Query.

    • resource icon
      SQL Nested Sub-Queries File
      Students must
      Mark as done
    • assign icon
      Lab Task Assignment
      Students must
      Mark as done
    • forum icon
      Forum
      Students must
      Mark as done
    • resource icon
      Bank Database SQL File
      Students must
      Mark as done
    • resource icon
      Korth Book SQL File
      Students must
      Mark as done

  • Week 9

    Lab 9

    • Students must
      Mark as done

      Topics of Discussion:

      SQL Join: Natural Join, Inner Join, Left Join, Right Join, etc.

      Expected Learning Outcomes:

      Learn to write SQL using Join.

    • assign icon
      Lab Task Assignment
      Students must
      Mark as done
    • forum icon
      Forum
      Students must
      Mark as done

  • Week 10

    Lab 10

    • resource icon
      Trigger Slide File
      Students must
      Mark as done
    • Students must
      Mark as done


  • LAB 11

  • Week 12

    Lab Final



  • Additional Topics