How is the TRS implemented?

New project setup:

1. Add project information into table [dbo].[ Airport] (even if the project is not an airport project)
2. Add information into table [dbo].[ProjectAirport] if there are many sub-projects in the parent project (e.g. Avinor is a parent project that tracking 17 airports)

Update data:

Steps below could be done orderly by using any automation tool or by manual:

1. Insert interview tracking data to table [dbo].[RespData]
2. Execute stored-procedure [dbo].[sp_InsertInterview] with appropriate parameters.
3. Execute stored-procedure [dbo].[sp_MultiInsertInterview] with appropriate parameters.