In This Unit of DMS covers Basic Concepts : Purpose of database systems, Components of DBMS, DBMS Architecture and Data Independence, Data Independence, Different Data Models, Various types of constraints.

Duration: 2 Hours

In This Unit of DMS covers Structure of Relational Databases : Relational Databases, Relational Algebra, Tuple Relational Calculus, Data definition with SQL, Insert statement in SQL, Delete statement in SQL, Update statement in SQL, Views, Data Manipulation with SQL, DDL statements in SQL, DML statements in SQL, JOINS.

Duration: 3 Hours

In this Unit of DMS covers Database Design : Design guidelines, Relational database design, Integrity Constraints, Boyce Codd Normal Form, Multivalued Dependencies and Forth Normal Form, Pitfalls in Relational Database Design, Second Normal Form, Third Normal Form, Join Dependencies, Forth Normal Form, Fifth Normal Form, First Normal Form, Types of dependencies.

Duration: 3 Hours