Welcome to my DBMS Lab repository! This repository contains a structured collection of practical lab assignments and SQL queries executed during my B.Tech curriculum. The primary focus is on understanding relational database design, data integrity constraints, and writing efficient queries using Oracle SQL / MySQL.
- Data Definition Language (DDL): Creating, altering, and dropping tables with strict integrity constraints (
PRIMARY KEY,FOREIGN KEY,UNIQUE,NOT NULL). - Data Manipulation Language (DML): Inserting data, updating records, and performing standard CRUD operations.
- Advanced SQL Queries: Filtering data using
LIKE,BETWEEN,IN, and performing data aggregation usingGROUP BYandHAVING. - Complex Data Retrieval: Implementing Subqueries, Nested Queries, and combining multiple tables using different types of Joins (Inner, Outer, Self Join).
- Database Design Principles: Conceptualizing ER models and applying Normalization techniques (1NF, 2NF, 3NF).
The repository contains 6 to 7 essential DBMS lab assignments, structured as follows:
| Lab No. | Topic / Experiment | Description |
|---|---|---|
| Lab 01 | E-R Modeling & Schema Design | Conceptual database design and mapping entities into relational schemas. |
| Lab 02 | Table Creation & DDL Commands | Defining database structures, managing data types, and setting constraints. |
| Lab 03 | Data Population & DML Operations | Populating tables with sample datasets and modifying existing records. |
| Lab 04 | Pattern Matching & Special Operators | Utilizing string functions, conditional operators (LIKE, IN), and aggregate functions. |
| Lab 05 | Complex Joins & Set Operations | Extracting data from multiple interconnected tables using relational operations. |
| Lab 06 | Subqueries & Nested Queries | Writing advanced, optimized queries nested inside other SQL statements. |
| Lab 07 | Normalization & Database Security | Eliminating redundancies, testing dependencies, and managing database access control. |
- Database Engine: Oracle Database / MySQL
- Query Language: Structured Query Language (SQL)
- Environment: Oracle Live SQL / Command Line Interface / VS Code
- Clone this repository to your local machine:
git clone [https://github.com/tridevku/sql-assignment.git](https://github.com/tridevku/sql-assignment.git)