IT252
Course Name:
Database Systems (IT252)
Programme:
Semester:
Category:
Credits (L-T-P):
Content:
Basic Concepts, Data models: ER, EER; Languages: SQL as backend and PHP or equivalent as frontend; Logical Database Design: Normalization; Physical Database Design: Storage organization, Indexing; Query Languages – Procedural , Non-procedural; Logical and Physical Design, Query Processing, Transaction processing: Concurrency Control and Recovery. Current trends in database system, Design and Implementation of Database Systems for applications such as office automation, hotel management, hospital management; Normalization, Query Processing in the above said application projects; Implementation of few important functionalities of relational database management systems.