This repository contains the solutions to the DB Lab questions from my lectures at the Spring 2024 semester at FAST NUCES Lhr. These solutions are intended to help students who are struggling with understanding the concepts and solving the assignments.
Note: that these solutions are provided for the Lab (subject), not the theory subject. Therefore, they may not be useful for the theory subject. Moreover, Microsoft SQL Server (Express) is being used as main Database Server for Executing SQL Queries. In addition to that, we need a server manager. You can use Microsoft SQL Server Manager as Server Manager for Executing Queries, but i am using mssql extension is VSCode. Moreover, in the Labs that have a Practise Folder: The Files in that Folder are there to help the Students Understand how the Concept being Solved in the Lab works (be it the Syntax or How to setup the System before Solving Exercises), not to Solve them (although you can for Practise), ie: Helping Material. The actual Exercise Questions that are to be solved, are in the Exercise (Lab Instructions) Manual. The Solutions to the Exercise Questions are in the SQL Source Code Files. While the SQL Schema Files are used to load the Database using which, you have to solve the Exercise and other Questions.
If you notice any errors in the solutions or would like to suggest improvements, please feel free to open an issue or submit a pull request. Contributions are always welcome!
This repository is licensed under the MIT License. See the LICENSE file for more information.