NIT Srinagar Syllabus CSE 5th Sem
Data Base Management systems
Purpose, data abstraction, data models, object based models, record based logical models, physical data model
Relational Database Design:
Normalization – 1NF, 2NF, 3NF, BCNF, higher Normal forms, De-normalization
Overview, General Strategies, Query Representation, Query Transformation, Catalog information, Estimated size of relations, Measures of query cost, selection, sorting, Join & other operations, query evaluation & choice of evaluation plans.
Object Oriented & Object Relational Databases:
New Applications, limitations due to 1NF, the object oriented Data model, nested relational model, querying with complex types, comparison of object-oriented & object relational databases.
- R. El. Masri and S. B. Navathe. Fundamentals of Data Base Systems, Benjamin Cummings, 1989.
- H. F. Korth and A. Silberschatz. Database Concepts, 2nd Edition, Mcgraw Hill, 1991.
- J. D. Ullman. Principles of Database and Knowledge Base Systems, Vol. I & II, Computer Science Press, 1988.