AI-Powered Learning Platform

Subject Syllabus

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

CSE · Semester 5

Course Modules

Learn topic-wise with Hyper AI and revise using mapped PYQs.

Introduction Significance of database Database system applications Data independence Data modeling for a database Entities and their attributes Relationships and relationship types Advantages and disadvantages of a database management system DBMS versus RDBMS

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 the E-R model Relationships and relationship types Associative database model

Categories of SQL commands Data definition language CREATE TABLE, DROP TABLE, and ALTER TABLE Primary key and foreign key TRUNCATE TABLE Index Cursor

Data manipulation language INSERT statement and multiple inserts DELETE statement and delete with conditions UPDATE statement and update with conditions MERGE statement

SELECT and SQL queries Data extraction from single and multiple tables Equi-join, non-equi-join, self-join, and outer join Special operators: like, any, all, exists, and in Hierarchical queries, inline queries, and flashback queries Introduction to ANSI SQL Anonymous blocks and nested anonymous blocks Branching and looping constructs in ANSI SQL