Skip to content
CampusPrep
CS-504 (C) · Introduction to Database Management Systems/Official Syllabus

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

1
Unit 1

Database Management System Concepts

  • Introduction
  • Significance of Database
  • Database System Applications
  • Data Independence
  • Data Modeling for a Database
  • Entities and their Attributes
  • Relationships and Relationships Types
  • Advantages and Disadvantages of Database Management System
  • DBMS Vs RDBMS
2
Unit 2

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
  • Associative Database Model
3
Unit 3

SQL : Data Definition Language

  • Categories of SQL Commands
  • Data Definition Language
  • Create table
  • Drop table
  • Alter Table
  • Primary Key
  • Foreign Key
  • Truncate Table
  • Index
  • Cursor
4
Unit 4

SQL DML

  • Data Manipulation Language
  • Insert Statement
  • Multiple Inserts
  • Delete Statement
  • Delete with conditions
  • Update statement
  • Update with Conditions
  • Merge Statement
5
Unit 5

SELECT and Advanced SQL

  • 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

Reference Books

  • An Introduction To Database System — Date C J — Pearson Educations
  • Fundamental of Database System — Korth, Silbertz, Sudarshan — McGraw Hill
  • Data Base System:Design Implementation & Management — Rob — Cengage Learninig
  • Fundamentals Of Database Systems — Elmasri, Navathe — Pearson Educations
  • Introduction to Database Management System — Atul Kahate — Pearson Educations
  • Oracle 9i Database Administration Fundamental-I, Volume I — Oracle Press,TMH
  • DataBase Management System — Paneerselvam — PHI Learning
Go to where you left off?

Quick Add to Notes

Save questions, your own notes and screenshots into notes filed by unit. It takes a free account.

Create free account

Have an account? Log in