WITH EFFECT FROM THE ACADEMIC YEAR 2016 – 2017

CS - 331

DATABASE MANAGEMENT SYSTEMS LAB

Instruction                                                  3              Periods per week

Duration of University Examination     3              Hours

University Examination                           50            Marks

Sessional                                                    25            Marks

1. SQL

1. a.Creating Database (Exercising commands like DDL,DML,DCL and TCL)
2. b.Exercising all types of Joins
3. c.Creating tables in I Normal, II Normal, III Normal and BCNF Form.
4. d.Creating table using combination of constraints.
5. e.Exercising Simple to Complex Queries
6. f.Usage of Stored Functions.
7. g.Creating Password and Security features for an Application.
8. h.Usage of File locking, Table locking facilities in an Applications

2. PL/SQL

1. a)Demonstration of Blocks, Cursors, Procedures, Functions and Packages.
2. b)Demonstrate Exception Handling .
3. c)Usage of Triggers to perform operation on Single and Multiple Tables.
4. d)PL/SQL Procedures for data validation

3. Report Generation Using SQL Reports

4. Creation of Small Full pledged Database Application

Note : The creation of sample database for the purpose of the experiments is Expected to be pre-decided by the instructor.

Suggested Reading :

1. 1.Nilesh Shah,
2. 2.Rick F Van der Lans,
3. 3.Benjamin Rosenzweig, Elena Silvestrova,
4. 4.Albert Lulushi,