Docstoc

SCSE3010P _1_

Document Sample
SCSE3010P _1_ Powered By Docstoc
					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.

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:28
posted:5/20/2012
language:
pages:1
Description: redeye technology