Course Content:

• Unit 1: Introduction
  • 1.1 Introduction to database
  • 1.2 Introduction to Database Management System (DBMS)
  • 1.3 Components of DBMS
  • 1.4 Characteristics of the database approach
  • 1.5 File Based System
  • 1.6 Database system vs. Traditional file processing system
  • 1.7 Advantages and Disadvantages of DBMS
• Unit 2: Database System Concepts, Architecture and ER-Model
  • 2.1 Database models
  • 2.2 DBMS architecture
  • 2.3 Data independence
  • 2.4 Database Design Process
  • 2.5 E-R Model: Entities, Attributes, Relationships, Keys, Cardinalities, Participation constraints, E-R Diagram
  • 2.6 Database users and Database administrators
  • 2.7 Data dictionary
• Unit 3: Relational Algebra
  • : 3.1 introduction, Selection, projectionand set operations.
  • 3.2 Properties of Relation
  • 3.3 Composition of Relational Operations
  • 3.4 Cartesian-Product, Join, Union, Intersection, Difference and Rename Operations
• Unit 4: SQL
  • 4.1 Introduction to SQL, DDL,DCL and DML
  • 4.2 Basic structure of SQL statements
  • 4.3 SQL Queries: DDL operations, DML operations, Null values, String operations, Aggregate functions
  • 4.4 Joined relations, Sub-queries
  • 4.5 Views and Stored Procedures
  • 4.6 Indexing and Query Optimization
• Unit 5: Integrity Constraints
  • 5.1 Domain constraints
  • 5.2 Entity integrity
  • 5.3 Referential integrity
  • 5.4 Data Security and Encryption
• Unit 6: Relational Database Design
  • 6.1 Pitfalls of Relational Model: Redundancy and Anomalies
  • 6.2 Functional dependency
  • 6.3 Normalization, its need and objectives
  • 6.4 1NF, 2NF, 3NF, BCNF and 4NF
• Unit 7: Database Security
  • 7.1 Access Control: Discretionary and Mandatory
  • 7.2 Authorization and Authentication
  • 7.3 Data encryption and decryption
• Unit 8: Transaction Management, Recovery, and Query Processing
  • 8.1 Introduction to transaction, ACID properties
  • 8.2 Introduction to concurrency control
  • 8.3 Reasons of transaction failure, System recovery and Media recovery
  • 8.4 Introduction to query processing, steps in query processing