DATABASE MANAGEMENT SYSTEMS

Paper Code: 
MCS 122
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

This module is designed for the students to know about the fundamental concepts of database management and handling.

 

12.00
Unit I: 
Introduction to DBMS

Concept and Architecture of DBMS, Data Base System v/s File System, Schemas, Instances and Data Independence, Introduction to Conventional Data Models (Network, Hierarchical and Relational), Database Administration- Role of DBA.

 

12.00
Unit II: 
Data Modeling Using ER Model:

Concept, Relational Algebra and Tuple, File Structure, Table Space, Segments, User Database, Data Dictionary Management, Memory Structure, Process Structure and Domain Calculus.

12.00
Unit III: 
Database Design and the E-R Model:

Overview of the design process, E-R Model, constraints, E-R diagrams, E-R design Issues, Concepts of Keys (Super Key, Candidate, and Primary), Generalization, Aggregation, Relational Model-Functional dependencies, Normal Forms, Loss Less Join and Dependencies Preserving Decomposition.

12.00
Unit IV: 
Transactions & Concurrency Control and SQL Basics

Transaction Concept, Transaction State, Concurrent Execution, Basic Structure of SQL Queries, Types of SQL Commands, INSERT, UPDATE and DELETE Operations.

12.00
Unit V: 
SQL

Queries and Sub-Queries, Set Operations, Aggregate Functions, Nested Sub Queries, Complex Queries, Views, Modification of the Database Structure, Integrity Constraints, Indexing. Introduction to PL/SQL.

ESSENTIAL READINGS: 
  1. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 5th Edition, McGraw Hill.
REFERENCES: 
  1. C.J.Date, “Introduction to Database systems”, 7th Edition, Narosa Publishing House.
  2. Bipin Desai, “An Introduction to Database Systems”, Galgotia Publications, 1991.
  3. Ullman J.D., “Principles of Database Systems”, Galgotia Publications
  4. Raghu Ramakrishnan & Johannes Gehrke, “Database Management Systems”, McGraw-Hill.

 

Academic Year: 
2017-18
  • Printer-friendly version