DATABASE MANAGEMENT SYSTEMS

Paper Code: 
CSC 414
Credits: 
03
Periods/week: 
03
Max. Marks: 
100.00
Objective: 

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

 

 

9.00

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.

 

9.00

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

 

9.00

Relational Model: Definition & Structure of Relational Algebra, Modification of the Database, Introduction to Views.

 

9.00

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

 

9.00

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

 

ESSENTIAL READINGS: 

 

  1. Abraham Silberschatz, Henry Korth, S. Sudarshan, “Database Systems Concepts”, 4th Edition, McGraw Hill, 1997.
  2. R. Elmarsi and SB Navathe, “Fundamentals of Database Systems”, Addison Wesley, 5th Ed., 2004
REFERENCES: 

 

  1. Jim Melton, Alan Simon, “Understanding the new SQL: A complete Guide”, Morgan Kaufmann Publishers, 1993.
  2. A. K. Majumdar, P. Battacharya, “Data Base Management Systems’, TMH, 1996.
  3. Bipin Desai, “An Introduction to database Systems”, Galgotia Publications, 1991.
Academic Year: 
2016-17
  • Printer-friendly version