Unit 1: Introduction to DBMS (3 hrs)
Introduction of Database Management System, Objective of Database Management System, Importance of DBMS, Merit and Demerit of DBMS, Application of DBMS.
Unit 2: Database Design, Architecture and Model (6 hrs)
Overview of The Database Designing Process and View of Data, Structure of Database Management System, Level Database Architecture and Data Independence, Database Languages: DDL, DML, QBE; Data Models: Hierarchical, Network, Relational, E-R Model, Object Base Data Model; E-R Diagram: Concepts, Relationship, Entity Relationship Diagram, Weak Entity Sets, Strong Entity Set, Aggregation, Generalization, Converting ER Diagrams to Tables.
Unit 3: Relational Database Model (4 hrs)
Structure of RDBMS and Terminology, Database Schema and Schema Diagram. Keys: Super, Candidates, Primary, Foreign, Composite etc., and Relationship: Introduction to Relational Algebra, Relational Algebra Operations: Select, Project, Cartesian Product, Union, Set Difference, Natural Join, Outer Join.
Unit 4: Database Normalization (4 hrs)
Definition and Importance of Normalization, Functional dependencies. Normalization: 1NF, 2NF, 3NF, BCNF and 4NF.
Unit 5: Creating and Altering Database and Tables (SQL) (6 hrs)
Introduction to SQL, Creating Database with Different Type of Arguments and Alter Database, Creating Normal tables and Complex tables with different Type of Constraints (Key, Check, Default); Alter Tables: Adding and Dropping Attributes and Other Constraints; Drop Statement: Table, Database.
Unit 6: Manipulating and Querying Data (8 hrs)
Adding Data with INSERT Statement, Retrieving Data with SELECT Statement and FROM Clause and Filter Data with WHERE Clause; Order and Grouping Data with ORDER and GROUP by Clause and Summarizing the Select Statement; Retrieving Data from Different Tables using: INNER JOINS, OUTER JOIN and CROSS JOIN; Building Nested Queries, Manipulate Data Using UPDATE Statement and Removing Rows Using DELETE Statement; Creating and Altering View.
Unit 7: Developing Stored Procedures, DML Triggers and indexing (5 hrs)
Managing Stored Procedures, Create, Alter, Drop, Execute Stored Procedure, Encryption, Passing Data to Stored Procedures, Parameter Default. Returning Data from Stored Procedure Output Parameter Using the Return Statement; Transaction Flow, Creating Triggers, Triggers Limitation, Disabling Trigger. Developing Multi Row Enabled Triggers; Basic Concept of Indexing, Ordered Indices, Type of Indexing, Multiple Key Access, Creating, And Dropping Index.
Unit 8: Query Processing and Security (5 hrs)
Overview of Query Processing, Measuring of Query Cost, Selection Operation, Sorting, Joining Evaluation of Expression, Query Optimization; Database Administrator: DBA Roles and Responsibilities, Database Security Issues, Types of Security, Access Protection, User Accounts and Database Audits, Discretionary Access Control, Mandatory Access Control; Data Encryption and Decryptions.
Unit 9: Transaction and Concurrency Control (4 hrs)
Transaction Concept, Simple Transaction Model, Atomicity and Durability, Transaction Isolation, Serializability, Transaction Isolation and Atomicity and Transaction Isolation Levels; Introduction, Lock-Based Protocol, Dead-Lock Handling, Multiple Granularity, Time-Based Protocol.