APPLYING SQL DATABASE QUERY TO ACCESS SQL SERVER 2019 – VISUAL STUDIO 2019

The paper presents: relational data model, which is the basis for the development of relational database management system (RDBMS) and the development of query languages for working with databases, relational schema, complex SQL queries and subqueries and the results obtained based on queries in relations. MS SQL Server 2019 accesses data in the database and can extend MS SQL Server 2019 application modules (eg. MS Visual Studio) that are created as a graphical interface for end users, with the addition of new capabilities that will enhance the execution of processes for participants within the company and other application modules of the organization. Each organization's database contains information of great importance, so queries and backups will be made using relational algebra operators and warned of potential threats and dangers of database corruption.