• 1. Course Summary and Objectives

    • DBMS Lab, PC-A, New Lab, (17-06-2020) Lesson
      Restricted Not available unless: You belong to PC-A

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

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


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

  • General

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