Skip to content

Istanbul Tour Agency SQL database management system. Manage Guides, Tourists, Tours, Tour sales and Invoices

Notifications You must be signed in to change notification settings

cory-sydn/Tour_Agency_Istanbul_SQL

Repository files navigation

Tour_Agency_Istanbul_SQL

Make sure your SQL server version and database management studio version is compatible.

SELECT @@VERSION

Firstly create database and tables by running "CreateTables.sql".

Run "ProcViewFunctionTrigger.sql" creates stored procedures, functions views and triggers for production version functionalities.

Run "DummyDataTesting.sql" for testing tour sale and invoice functionalities.

[sp_Registered Tourist Detection] trigger prevents double data entry for the same tourist and returns the tourist's informations.

All functionalities can be found at "Functionalities.sql".

About

Istanbul Tour Agency SQL database management system. Manage Guides, Tourists, Tours, Tour sales and Invoices

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages