IT252
Course Name:
Database Systems (IT252)
Programme:
B.Tech (IT)
Semester:
Fourth
Category:
Programme Core (PC)
Credits (L-T-P):
(3-0-2) 4
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.
References:
Raghu Ramakrishnan, Johannes Gehrke, Database Management Systems, McGraw-Hill, 2014
R. Elmasri and S.B Navathe , Fundamentals of Database Systems,7th Ed., Pearson, 2017
Silberschatz, Korth A.F., Sudarshan S., Database System Concepts, 6th Ed., McGraw-Hill,2010.
Department:
Information Technology