Database Management System

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

·         To familiarize the students with concepts of Database Management Systems.

·         To understand the fundamentals of data models and conceptualize and depict a database system using ER diagram.

To make a study of SQL and relational database design.

10.00
Unit I: 
Introduction

Overview of DBMS, Advantages of DBMS, Basic DBMS terminology, Database System v/s File System, Data Independence, Architecture of DBMS, Introduction to data models: Relational Model, Network Model, Hierarchical Model, Entity-Relationship Model, Comparison of network, hierarchical and relational models.

 

12.00
Unit II: 
Data modeling using the Entity Relationship Model

ER model concepts, Types of Relationships, notation for ER diagram, Reduction of ER-Diagrams to Relational Model, mapping constraints, Generalization, Aggregation, Specialization, Extended ER model, relationships of higher degree

 

10.00
Unit III: 
Relational model:

Storage Organizations for Relations, Relational Algebra, Set Operations, Relational Calculus, Concepts of Alternate key, candidate key, primary key, Foreign key, Integrity Rules, Data Dictionary.

 

12.00
Unit IV: 
Normalization:

 Functional dependencies, normal forms, first, second, third normal forms, BCNF, inclusion dependencies, loss less join decompositions, normalization using FD, MVD, and JDs, alternative approaches to database design.

 

16.00
Unit V: 
Introduction to SQL:

 Characteristics of SQL, Advantages of SQL, SQL data types and literals, Types of SQL commands: DDL, DML, TCL, DCL, SQL operators, Tables, views and indexes, Constraints Group By and Having Clause, Order By Clause, Queries and sub queries, Aggregate Functions, Numeric Functions, String Functions, Date & Time Functions, Insert, Update and Delete operations, Unions, Intersection, Minus, Joins: Equi-Join, Natural Join, Self Join, Inner Join, Outer Join

 

ESSENTIAL READINGS: 
  • Elmasri, Navathe, “Fundamentals of Database Systems”, Addison Wesley, 6th Edition, 2011.
  • Korth, Silberschatz, Sudarshan, “Database Concepts”, McGraw Hill, 6th Edition, 2010.

 

REFERENCES: 
  • Thomas Connolly and Carolyn Begg, “Database Systems: A Practical Approach to Design, Implementation, and Management, Addison Wesley , 5th Edition, 2010
  • Ramakrishnan, Gehrke, “Database Management System”, McGraw Hill, 3rd Edition, Jan 2007
  • Date C J, “An Introduction to Database System”, Addision Wesley, 8th Edition 2003
  • Bipin C. Desai, “An Introduction to Database Systems”, Galgotia Publication, Revised Edition, 2010
  • Majumdar & Bhattacharya, “Database Management System”, TMH, 2005
  • Paul Beynon Davies, “Database Systems”, Palgrave Macmillan, 3rd Edition, 2003

 

Academic Year: 
2016-17
  • Printer-friendly version