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

Contact us

Head of the Department,
Department of Information Technology,
National Institute of Technology Karnataka,
SurathkalP. O. Srinivasnagar, Mangalore - 575 025
Ph.:    +91-824-2474056
Email:  hodit [at] nitk [dot] edu [dot] in
 

Web Admin: Sowmya Kamath S

Connect with us

We're on Social Networks. Follow us & stay in touch.