Welcome to the Database Management System Laboratory repository! This repository contains a collection of programs and solutions for hands-on exercises in the field of database management. The programs are designed to help you practice and enhance your skills in working with databases using SQL queries.
The Database Management System Laboratory is a repository dedicated to providing practical exercises and solutions for various aspects of database management. It covers essential topics such as schema design, SQL queries, data manipulation, data retrieval, and more. By engaging with these programs, you will gain hands-on experience in working with databases and develop a strong foundation in database management principles.
This repository includes the following programs:
-
Program 1 - Library Database: This program focuses on a library database schema. It covers tasks such as retrieving book details, finding borrowers with specific criteria, deleting data from tables, partitioning the database, and creating views.
-
Program 2 - Order Database: The program revolves around an order database schema. It includes tasks such as counting customers based on grades, finding salesman with multiple customers, using UNION operation to list salesmen with and without customers in their cities, creating views, and performing DELETE operations.
-
Program 3 - Movie Database: This program centers around a movie database schema. It covers tasks such as retrieving movie titles directed by a specific director, finding actors who acted in multiple movies, joining tables to list actors meeting specific criteria, retrieving movie ratings, and updating movie ratings.
-
Program 4 - College Database: This program focuses on a college database schema. It includes tasks such as retrieving student details based on specific criteria, computing statistics on the number of students, creating views, and categorizing students based on given criteria.
-
Program 5 - Company Database: This program centers around a company database schema. It covers tasks such as retrieving project numbers involving specific employees, calculating salary changes, retrieving department-specific salary statistics, retrieving employee names based on specific criteria, and retrieving department and employee information.
To get started with the programs in this repository, follow these steps:
-
Clone the repository to your local machine using the following command:
git clone https://github.com/your-username/Database-Management-System-Laboratory.git -
Ensure you have a database management system installed (e.g., MySQL, PostgreSQL, SQLite) and the necessary client tools to interact with the database.
-
Execute the SQL queries provided in each program's solution file to create the required tables and populate them with sample data.
To use this repository and work with the programs, follow these steps:
-
Ensure you have completed the installation steps mentioned above.
-
Open your preferred database management tool and connect to the database.
-
Open the solution file for the desired program and execute the SQL queries to perform various tasks and retrieve results.
-
Modify the queries or experiment with different scenarios to further enhance your understanding and skills in database management.
Contributions to this repository are welcome! If you have any additional programs, improvements to existing programs, or bug fixes, please submit a pull request. Make sure to follow the contribution guidelines outlined in the repository.
This repository is licensed under the MIT License. Feel free to use the programs and solutions provided in this repository for educational or personal purposes.
If you have any questions or need further assistance, please don't hesitate to reach out. Happy learning and exploring the world of database management!