Topic outline

  • Welcome to the course

    CSE312: Database Management System Lab 

     

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

  • Text And Reference Book

  • Marks Distribution


    Attendance

    10

    Lab Performance

    25

    Project

    25

    Final Exam + Viva

    40




    • Week One

      WEEK ONE

      Introductory Discussion

    • Week Two

      WEEK TWO

      Learning Outcome:

      1.  Learn about the fundamental elements of relational database management systems.
      2. Learn How to create database,  table,
      3. Insert values,  show table data.
      4. Rename table name.
      5. Drop table and database.
      • Data Type in Sql URL
      • Section-G, Lab Recorded Class, Date::29.01.2022 URL
        Restricted Not available unless: You belong to Section-G


      • Section-A, Recorded Lab Class, Date::02.02.2022 URL
        Restricted Not available unless: You belong to Section-A


    • Week Three

      WEEK THREE

        Learning Objective:
      • Distinct
      • Limit
      • Order By
      • where clause
      • Arithmetic operator 
      • Between
      • Logical operators: And, Or, Not, In, Like

    • Week Four

      WEEK FOUR

      Learning Objective:

      • Update
      • As
      • Alter table (Add column, Drop column, Modify datatype, change column Name)
      • Truncate
      • Aggregate Function: Max, Min, Sum, Avg, Count
      • Group by
      • Having

    • Week Five

      WEEK FIVE

      Learning Objective:

      • Table Joining
      • Inner Join
      • Left Join
      • Right Join

    • MID TERM ASSESSMENT

      Exam Topic:  Week 1, Week 2, Week 3, Week 4, Week 5



      • Week Seven

        WEEK SEVEN

        Learning Objective:

        • Sub query
        • Nested Query on Joining
        • Union/ Union All
        • Intersect,Minus

        • Lab Task 4

          Question : (Click here)

        • Sub Query Forum
          Due: Thursday, 31 March 2022, 4:22 PM

      • Week EIGHT

        WEEK EIGHT

        Learning Objective:

        • Joining query practice
        • Domain Constraints in Relations
        • Primary Key, Foreign Key
        • Unique, Not Null
        • Check, Default

        • Week Nine

          WEEK NINE

          Learning Objective:

          • Trigger
          • SQL view
          • Stored Procedure

          • Topic 13

            WEEK TEN


            Lab Final

            • Week Eleven

              WEEK ELEVEN

              Project Demonstration