SQL Lab

SQL Lab

Lab Objectives:

The Lab experiments aims:

  1. To identify and define problem statements for real life applications
  2. To construct conceptual data model for real life applications
  3. To Build Relational Model from ER/EER and demonstrate usage of relational algebra.
  4. To Apply SQL to store and retrieve data efficiently
  5. To implement database connectivity using JDBC
  6. To understand the concepts of transaction processing- concurrency control & recovery procedures.
Lab Outcomes:
On successful completion, of course, learner/student will be able to:
  1. Define problem statement and Construct the conceptual model for real life application. L1, L3, L4, L6
  2. Create and populate a RDBMS using SQL. L3, L4
  3. Formulate and write SQL queries for efficient information retrieval L3, L4
  4. Apply view, triggers and procedures to demonstrate specific event handling. L1, L3, L4
  5. Demonstrate database connectivity using JDBC. L3
  6. Demonstrate the concept of concurrent transactions. L3, L4