CS 317a : Database and Information Systems I
Course Code CS 317a
Course Name Database and Information Systems I
Offered to UG/PG
Pre-requisites NIL
Lecture 3
Tutorial 0
Practical 0
Credit 3*
Reference Abraham Silberschatz, Henry F. Korth, and S. Sudarshan, Database System Concepts 6th Ed, McGraw Hill, 2010.
Description The course introduces the concepts of database design. Overview of data management systems. Relational model and query languages (relational algebra and calculus, SQL). Database design using the ER Model, ER Diagrams, UML Class Diagrams. Relational database design and normalization. Integrity and Security. Design and development of Web-based information systems. Overview of storage structures and indexing, query processing and optimization, and transaction processing.