DATABASE MANAGEMENT SYSTEMS

Paper Code: 
BCA 301
Credits: 
04
Periods/week: 
04
Max. Marks: 
100.00
Objective: 

This module is designed to help students to know about the fundamental concepts of database management. 

10.00
Unit I: 

Introduction: Database, Database System Applications, Database Systems versus File Systems, View of Data, Data abstraction, Levels of architecture, Data Independence, Data Models, Database Languages, Database Users and Administrators, History of Database Systems

12.00
Unit II: 

Entity-Relationship Model: Basic concepts, Constraints, Keys, Design Issues, E-R diagram, Weak Entity Sets, Extended E-R features, Design of an E-R Database Schema, Reduction of an E-R Schema to tables.

 

15.00
Unit III: 

Relational Model: Structure, The Relational Algebra, and Extended Relational-Algebra Operations, Modification of the Database, Introduction to Views, Introduction to the Tuple Relational Calculus and the Domain Relational Calculus.

SQL: Basic Structure, Set Operations, Aggregate Functions, Null Values, Nested Sub queries, Joined Relations.

 

10.00
Unit IV: 

Relational-Database Design: First Normal Form, Pitfalls in Relational-Database Design,  Functional Dependencies, Decompositions, Boyce-Codd Normal Form, Third Normal Forms.

 

13.00
Unit V: 

Distributed database concepts, Distributed database concepts, Parallel Vs Distributed technology, Advantages of Distributed databases, Additional functions of Distributed databases, Overview of Client-Server architecture and its relationship to Distributed databases.

Storage and File Structure: Overview of Physical Storage Media, Magnetic Disks, RAID, Tertiary Storage, Storage Access.

 

ESSENTIAL READINGS: 
  1. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 4th Edition, McGraw Hill, 1997.

 

REFERENCES: 
  1. Jim Melton, Alan Simon, “Understanding the new SQL: A complete Guide”, Morgan Kaufmann Publishers, 1993.
  2. R. Elmarsi and SB Navathe, “Fundamentals of Database Systems”, Addison Wesley, 4th Ed., 2004
  3. A. K. Majumdar, P. Battacharya, “Data Base Management Systems’, TMH, 1996.
  4. Bipin Desai, “An Introduction to database Systems”, Galgotia Publications, 1991
Academic Year: 
2015-16
  • Printer-friendly version