NIT Srinagar Syllabus CSE 5th Sem Data Base Management systems
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.