UNIT 1: Introduction:

Why Database, characteristics of Data in Database, DBMS, Significance of Database, Database System Applications ,Data Independence, advantages and disadvantages of DBMS, DBMS/RDBMS.

UNIT 2: Database Architecture and Modeling:

Three level architecture of database, Conceptual, Physical and logical database models. Role of DBA, Database Design Entity Relationship Model, Components of ER Model, ER Modeling symbols. Super class and sub class types, Attribute inheritance, Specialization, Generalization, and Categorization.

UNIT 3: Relational DBMS and Relational Algebra and Calculus:

Introduction to Relational DBMS. RDMBS Terminology. Database normalization, Keys, Relationships, First Normal Form, Functional dependencies, Second Normal form, third Normal form, Boyce-Codd Normal form, fourth Normal form, Fifth Normal form, case study, Relational Algebraic operations, tuple Relational calculus(TRC), Domain Relational Calculus(DRC).

UNIT 4: Introduction to SQL :

History of SQL. Characteristics cf SQL. Advantages of SQL. SQL in Action. SQL data types and Literals. Types of SQL commands. SQL Operators and their precedence. Tables. Views and indexes. Queries and Sub queries. Aggregate functions. Insert. Update and Delete operations. Joins. Unions. Inter section. Minus. Cursors in SQL. Embedded SQL.

UNIT 5: Backup, Recovery AND Database Security:

Database backups. Why plan backups? Hardware protection and redundancy, Transaction logs, Importance of backups, Database recovery, Types of Integrity constraints, Restrictions on integrity constraints, Data security risks, Authenticating users to the database.