Engineering the budding technocrats

Government of Arunachal Pradesh

GOVERNMENT POLYTECHNIC COLLEGE ZIRO

सरकारी पॉलिटेक्निक कॉलेज जीरो, लोअर सुबनसिरी

Village: Jugo, Tajang, PO: Ziro-791120, Lower Subansiri District, Arunachal Pradesh, India.

Approved by AICTE
Affiliated to APSCTE

List of Experiments

DBMS Lab

Computer Science & Engineering

List of Experiments

S.No Experiment Details
1Database design using ER modeling and normalization.
2Creating tables with primary key, foreign key, and unique constraints.
3Writing basic SQL queries (SELECT, INSERT, UPDATE, DELETE).
4Writing complex queries using Joins, Subqueries, and Aggregate functions.
5Creating and managing Views and Indexes.
6Writing PL/SQL blocks with conditional statements and loops.
7Creating PL/SQL Procedures, Functions, and Database Triggers.