DBMS_QLNhaKhoa

DBMS - QLNhaKhoa and Concurrency

• Group project from HCMUS's 2023 Database Management System course.

Table of Contents

• Content
  • QLNhaKhoa, QLNK_Release and assets
  • SQL
• Getting Started
  • Prerequisites
  • Installation
• Usage
  • To set up the database
  • To run QLNhaKhoa application
  • To observe or fix concurrency conflicts
  • In DBMS
  • In QLNhaKhoa app
• Built With
• Meet The Team

Content

• Project.pdf contains all the tasks and requirements of the project (in Vietnamese).
• Report.pdf includes our documentation for all the designs and required tasks (in Vietnamese).

QLNhaKhoa, QLNK_Release and assets

Source code, release build, and resources pertaining to the C# WinForms app.

CAUTION: The application will continue running in the background, even after closing the interface, in both of these circumstances,

• By executing the QLNhaKhoa.exe in QLNK_Release,
• By Start Without Debugging (Ctrl + F5) in Visual Studio.

It should be manually killed with Task Manager, by searching for QLNhaKhoa.

SQL

All folders and files are pretty self-explanatory, but here are some notable things,

• setupDB.bat constructs the database and populating all data.
• concurrency holds implementations and solutions to Concurrency Conflict scenarios.

Getting Started

Prerequisites

• Windows 10 or 11.
• For WinForms development:
  • Visual Studio 2022 and its .NET desktop development workload.
• SQL Server 2022 Developer and SQL Server Management Studio (SSMS) 19.2.
• (Optional) Any decent code editor, preferably VSCode.
  • It just makes editing the database's source code easier.

Installation

• Clone the repo.

(back to top)

Usage

To set up the database

1. Start the SQL Server and connect to it.
   • Make sure you have sufficient privileges.
2. Navigate into SQL folder.
3. Run setupDB.bat.
   • All data are inserted using stored procedures. With the strict constraints on some tables' insertion, it is expected that many data won't pass the checks.

To run QLNhaKhoa application

1. Finish setting up the database.
2. Navigate into QLNK_Release.
3. Run QLNhaKhoa.exe.

CAUTION: The application will continue running in the background even after closing the interface. It should be manually killed with Task Manager, by searching for QLNhaKhoa.

To observe or fix concurrency conflicts

In DMBS

1. Start the SQL Server and connect to it.
   • Make sure you have sufficient privileges.
2. Navigate into SQLconcurrencyco folder, with co being the conflict of choice.
3. Run co.sql to replace all base procedures with the defective or fixed ones.
4. Run tran1.sql then tran2.sql right after.
   • For the best experience, each file should be opened in an instance of SSMS, both of which should be placed side by side.
     • Refer to MSSQL Isolation Level Demos by CodeCowboyOrg.

In QLNhaKhoa app

1. Start the SQL Server and connect to it.
   • Make sure you have sufficient privileges.
2. Navigate into SQLconcurrencyco folder, with co being the conflict of choice.
3. Run co.sql to replace all base procedures with the defective or fixed ones.
4. Run 2 instances of QLNhaKhoa side by side, following the above steps.
5. Perform actions that are relevant to the conflicts' scenarios.
   • Now, this step is very difficult to explain because the possiblities are endless. Basically, just experiment.
   • For pointers, you may look into all the tran1.sqls and tran2.sqls, then try to translate those queries onto the app.

Built With

2022 v17.8.3	8.0	Developer 2022	19.2.56.2	1.85.0	11

Meet The Team

               

(back to top)