LECTURE PLAN 5th Semester

							                   Guru Tegh Bahadur Institute of Technology, New Delhi


                      Lesson Plan for (Database Management Systems)


     Course Name: B.Tech.                Semester: 5th        SUB CODE: ETCS 309

Week         No of            Topic Details             No of    Metho    Reference/text book
No &         days                                       Hours    dology
Dates       Availab                                    Planned
              le
1.             6       Unit-I:                            1        L
                       Basic Concepts and                                 T1, T2,T3
                       Conceptual Database
                       Design: Introduction to
                       Database Systems,
                       Characteristics of DBMS,
                                                                  L,A
                       File System versus a
                       DBMS, People who deal              1               T2,T3
                       with Database system,
                       Role of DBA
                                                                   L
                       Advantages of a DBMS,              2
                       Disadvantages of DBMS,                             T2,T1,T3
                       Data Models, Schemes &
                       Instances,
                       DBMS Architecture & Data                   L,A
                       Independence, Database
                       Languages & Interfaces.                            T2,T3
                       DBMS Structure

2.             6       Overview of Hierarchical,          1        L      T2,T3
                       Network & Relational Data
                       Base Management Systems.

                       Entity Relationship Model:         1               T2,T3
                       Overview of Database
                       Design, Entities, attributes,
                       and Entity sets,
                       Relationships and                  2
                       Relationship sets
                       Cardinality of
                       Relationships, Types of
                       Attributes,
         Strong and Weak Entity
         Sets




3.   5   Participation Constraints,    2   L, T    T2
         Speacialization,                          T2,T3
         Generalization and
         Aggregation
         Translating your ER Model     2    L      T2
         into Relational Model

4.   5   Relational Model,             1    L      T2
         Languages & Systems:
         Relational Data Model
         Relational Model Concepts,
         Relational Model
         Constraints,
         Relational Algebra.           1    L,T
                                                   T2,T1
5.   4   Queries related to            1   L,T,A   T1, T2
         Relational Algebra

         SQL – A Relational            1
         Database Language,                        T2, T3
         Data Definition in SQL:
         SQL Queries: The form of a
         basic SQL query, Union,
         intersect, and except,


6.   5   Aggregate operators           1    L        T2
         Specifying Constraints,

         View and Joins in SQL,        1
         Specifying Constraints             T
         Introduction to nested
         queries
7.   0   First Sessional Examination   0


8    6   Indexes in SQL,               1   L,A     T1,T2
         Practicing SQL commands
         using ORACLE
          Relational Data Base
          Design and Oracle             1    L,T    T4
          Architecture: Functional
          Dependencies, Armstrong’s
          inference rules with proof
          Normalization for
          .Relational Databases
9.    4   Normal Forms Based on         2   L,T,A   T4,T5
          Primary Keys, (1NF, 2NF,
          3NF & BCNF),

          Lossless Join and             1    L      T1,T4
          Dependency Preserving
          Decomposition
10.   2   Oracle 8 Architecture,        1    L      T2
          Database Storage, Oracle
          Software Structures,

          Shared Database Access        1    L      T2
          Mechanism, Database
          Protection.
11.   6   Transaction Management:       1    L      T1,T4
          Transaction Concept and
          State Implementation of
          Atomicity and Durability,

          Concurrent Executions,        2    L,T    T1,T4
          Serializability,
          Recoverability,
          Implementation of Isolation

12.   6   Concurrency Control           1   L,A     T1
          Techniques, Lock-Based
          Protocols, Timestamp-
          based Protocols,

          Deadlock Handling             1     L     T1,T4
          Recovery System, Failure      1    L,T
          Classification, Storage
          Structure,
13.   4   Recovery and Atomicity,       2    L,T    T1,T4
          Log-based Recovery,

          Shadow Paging, Recovery       2    L      T1
          with Concurrent
          Transactions
14.           0       Second Sessional                  0
                      Examination
15.           6       Buffer Management,                1          L      T!,T4

                      Indexing, Hashing                 1          L


16.           6       Query Processing: Query           1         L,A     T1
                      Processing, Overview,
                      Measures of Query Cost,

                      Selection Operation,              1         L,T     T1,T4
                      Sorting, Join Operation,

                      Other Operations,                 1          T      T1
                      Evaluation of Expressions
17.           6       Concepts      of     Object       1          L      T1,T4
                      Oriented          Database
                      Management Systems,

                      Distributed Data Base             1          L      T1,T4
                      Management     Systems.




  *Methodology used:
  Lecture (L)
  Tutorial (T)
  Assignment (A)

  Text Books/ Reference Books:

  T1: Korth, Silberschatz, “Database System Concepts”, 4th Ed., TMH, 2003.
  T2: Steve Bobrowski, “Oracle 8 Architecture”, TMH, 2000
  T3: C. J. Date, “An Introduction to Database Systems”, 7th Ed., Narosa Publishing, 2004
  T4: Elmsari and Navathe, “Fundamentals of Database Systems”, 4th Ed., A. Wesley, 2004
  T5: J. D. Ullman, “Principles of Database Systems”, 2nd Ed., Galgotia Publications, 1999.


  Websites:
      1. http://www.w3schools.com/sql/default.asp
      2. www.cs.iit.edu/~cs561/cs425/algebra/home.html
      3. http://en.wikipedia.org/wiki/Database_normalization
      4. http://www.sql-tutorial.net/
5. info.cba.ksu.edu/skovar/greatplains/normalization.doc
6. en.wikipedia.org/wiki/Entity-relationship_model
7. http://nptel.iitm.ac.in/video.php?courseId=1071