BIT 332                                          WITH EFFECTFROM THEACADEMIC YEAR 2012-2013

 DBMS  LAB

Instruction                                                                           3 Periods per week

Duration                                                                                              3 Hours

University Examination                                                                      50 Marks

Sessional                                                                                             25 Marks

1. Creation of database  (exercising the commands for creation)
2. Simple  condition query creation using SQL Plus
3. Complex condition query creation using SQL Plus
4. Usage of Triggers and Stored Procedures.
5. Creation of Forms for student Information, library information, Pay roll etc.
6. Writing PL/SQL procedures for data validation
7. Generation using SQL reports
8. Creating Password and Security features for applications.
9. Usage of File locking table locking, facilities in applications.
10. Creation of small full-fledged database application spreading over to 3 sessions.

Note:-  The creation of sample database for the purpose of the experiments is

  expected to be pre-decided by the instructor.

Suggested Reading: 

     1. Nilesh Shah , Database System Using Oracle, PHI, 2007.

    2. Rick F Vander Lans,  Introduction to SQL, Fourth edition, Pearson Education,2007.

    3. Benjamin Rosenzweig, Elena Silvestrova, Oracle PL/SQL by Example, Third edition,     

        Pearson Education, 2004.

    4. Albert Lulushi, Oracle Forms Developer’s Handbook, Pearson Education, 2006.