Topic outline

  • General

  • Course Introduction


    • Instructions/Guideline for the course:

          • All the students registered for this course have to enroll in Moodle
          • Students can find all the course materials from Moodle.
          • All the students have to submit the soft copy of their "Assignment" in Moodle under the assignment section created here and for this, they will be graded here.
          • One discussion or feedback forum is created under each of the lecture Students have to give their feedback on these forum and marks will be given for their feedback
          • Any announcement regarding the class will be posted on Moodle. So they have to keep themselves always active on Moodle.
          • All the quizzes and presentation will be held on face to face class and maybe a few of the class will be held on online (Moodle) and it will be announced before the class

        • Objectives: 

          • Introduce basic concepts and major techniques in DBMS implementations. These include concepts and techniques for data storage, query processing, concurrency control, and transaction management.

          • Introduce research development ability in databases through technical surveys and presentations.

        • Learning Outcomes:

          • Explain in detail DBMS architecture.
          • Explain in detail query processing and techniques involved in query optimization.
          • Explain the principles of concurrency control.
          • Explain the principles of recovery management.
          • Know recent developments and active research topics in the database.

        • Course Content: 

          • Transaction
          • Concurrency Control
          • Normalization 
          • Query Optimization
          • Database Security
          • Distributed database
          • Data Warehousing
          • Deductive database
          • Data mining
          • Big data

      • Lecture Module-01: Transaction

        Objectives of this lecture:

        • To teach the students about the multiple transactions can execute in parallel
        • To  teach the students about the Concurrent execution of multiple transactions

        Lecture Outcomes: 

        At the end of the session students will be able to :

        • Learn about the multiple transactions can execute in parallel

         Lecture Contents:

          • What is a Transaction?
          • ACID Properties
          • Concurrency Control

      • Lecture Module-02: Concurrency Control

        Objectives of this lecture:

        • To teach the students about the Concurrency Control
        • To teach the students about the  Wait for Graph

        Lecture Outcomes: 

        At the end of the session students will be able to :

            • Learn about the principles of wait for graph

        Lecture Contents:

          • Concurrency Control
          • Wait for Graph

      • 1st Quiz

        Announcement:

        • Your 1st quiz will be held on 2nd week of February -2020




        • Lecture Module-03: Normalization

          Objectives of this lecture:

            • To teach the students about the principles of Normalization

          Lecture Outcomes: 

          At the end of the session students will be able to :

            • Learn about the principles of Normalization

          Lecture Contents:

            • Normalization
              • 1NF
              • 2NF
              • 3NF
              • BCNF
              • 4NF
              • 5NF


        • Quiz-02

          Announcement:

          • Your 2nd quiz will be held on 4th week of March 2020

          • Lecture Module-04: Query Optimization

            Objectives of this lecture:

              • To teach the students about the principles of Query Optimization

            Lecture Outcomes: 

            At the end of the session students will be able to :

              • Learn about the principles of Query Optimization

            Lecture Contents:

              • Query Optimisation
              • Query Optimisation(Math Mathical Solve)


          • Lecture Module-05: Distributed database

            Objectives of this lecture:

              • To teach the students about the principles of Distributed database

            Lecture Outcomes: 

            At the end of the session students will be able to :

            • Learn about the principles of Distributed database

            Lecture Contents:

              • Distributed database


          • Assignment

            Create database, insert data and write the queries from the attached file.

          • Midterm-Week

            Midterm Exam includes: Lecture Module 1-4
            • Midterm Preparation Forum

              • Discuss with each other and find the problems regarding upcoming midterm examination
              • Try to solve the problems of each other
              • If you have any problems that you can not solve, then inform me and we will discuss it in the classroom.

          • Presentation

            Announcement:

            • Your presentation will be held soon.
            • The exact date of the presentation will be announced as soon as possible in the class or in the online class.
            • Select any topic from the course syllabus and prepare yourself for the presentation

            • Lecture Module-06: Data Mining

              Objectives of this lecture:

                • To teach the students about the principles of Decision Tree Algorithm

               Lecture Outcomes: 

              At the end of the session students will be able to :

              • Learn about the principles of Decision Tree Algorithm

              Lecture Contents:

                    • Decision Tree Algorithm

            • Lecture Module-07: Big Data

              Objectives of this lecture:

              • To teach the students about the principles of MapReduce Algorithm
              • To teach the student about the Hadoop

              Lecture Outcomes: 

              At the end of the session students will be able to :

              • Learn about the principles of MapReduce Algorithm

              Lecture Contents:

                • MapReduce Algorithm
                • Hadoop

            • Quiz-3

              • Quiz-03

                Topics: 

                • Big Data
                • Data Minning


            • Final Week

              Final Exam includes Lecture Module 5-6

              • Final Exam Preparation Forum

                • Discuss with each other and find the problems regarding upcoming midterm examination
                • Try to solve the problems of each other
                • If you have any problems that you can not solve, then inform me and we will discuss it in the classroom.

            • Topic 17