Syllabus - Introduction to Database Management Systems (CS-504 (C))

Database Management System Concepts

Introduction, Significance of Database, Database System Applications; Data Independence; Data Modeling for a Database; Entities and their Attributes, Entities, Attributes, Relationships and Relationships Types, Advantages and Disadvantages of Database Management System, DBMS Vs RDBMS.

Database Models and Implementation

Data Model and Types of Data Model, Relational Data Model, Hierarchical Model, Network Data Model, Object/Relational Model, Object-Oriented Model; Entity-Relationship Model, Modeling using E-R Diagrams, Notation used in E-R Model, Relationships and Relationship Types; Associative Database Model

SQL

Data Definition Language: Categories of SQL Commands; Data Definition Language; Create table, Drop table and Alter Table. Primary Key, Foreign Key, Truncate Table, Index, Cursor.

SQL DML

Data Manipulation Language, Insert Statement, Multiple Inserts, Delete Statement, Delete with conditions, Update statement, Update with Conditions, Merge Statement.

SELECT

SQL queries, Data extraction from single, multiple tables equi-join, non equi-join, self-join, outer join. Usage of like, any, all, exists, in Special operators. Hierarchical queries, inline queries, flashback queries. Introduction of ANSI SQL, anonymous block, nested anonymous block, branching and looping constructs in ANSI SQL.