COURSE COURSE C S E 3 0 1 0 P DATABASE MANAGEMENT SYSTEMS CODE TITLE CREDITS L T P (or Max. Marks) Weightages 0 0 3 2 CA MTE ETE Att At P P Th P Th d 05 0 40 0 0 55 0 COURSE OBJECTIVES: The objective of this subject is to get broad understanding of the basic concepts of database system in general and relational database system in particular. The students will have theoretical foundation required for working with different types of relational database products, such as SQL. The students develop the skills To Understand Database design, normalization techniques and SQL. To Understand Importance of backup and recovery techniques. Develop Database system to handle the real world problem. PRE-REQUISITES: NIL LABORATORY WORK: S. No. Description 1. To implement different types of DDL, DML and DCL statements in SQL. 2. To use constraints 3. To explore ‘select’ clause using where, order by, between, like, group by, having etc. 4. To implement different in-built functions and user defined functions. 5. To run the various queries, nested and correlated queries & Joins using commands of SQL. 6. To write programs using control structures of PL/SQL like If-else statements, For, Do-while, while etc. 7. Implementation of Cursors, Procedures, Triggers, Packages. TEXT BOOKS: 1. Author: H. F. Korth ,& S. SudarshanA. Silverschatz,Title: Database System Concepts Publishers: Tata McGraw Hill, New Delhi,Year of Publication:2006 OTHER READINGS: 1. Elmasri & Navathe, Fundamentals of Database systems, Addison & Weisely, New Delhi. 2. Peter Rob, Carlos Coronel,Database systems: Design implementation and management 3. C. J. Date, Database Systems, Prentice Hall of India, New Delhi. 4. Martin Gruber, Understanding SQL, BPB Publication, New Delhi. 5. Val Occardi, Relational Database: Theory & Practice, BPB Publication, New Delhi. 6. Ivan Bayross ,Introduction to SQL Tata McGraw. 7. Ivan Bayross, SQL, PL/SQL The Programming Language of Oracle, BPB Publication. SALIENT PEDAGOGICAL FEATURES: 1. Closing Quiz/Review Quiz. 2. Drill Problems based on real life scenarios. 3. Recent Trends Topics. 4. Use of Animations and Openware.