Naslov (eng)

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

Autor

Šimović, Vladimir
Varga, Matija

Opis (eng)

ABSTRACT: 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.

Jezik

engleski

Datum

2019

Licenca

Ovo delo je licencirano pod uslovima licence
Creative Commons CC BY 4.0 - Creative Commons Autorstvo 4.0 International License.

http://creativecommons.org/licenses/by/4.0/legalcode

Predmet

Key words: RDBMS, relational data model, relational schema, SQL, data manipulation language, dana management, relational algebra operators, database protection

Deo kolekcije (1)

o:1600

Radovi profesora i saradnika Fakulteta za ekonomiju i inženjerski menadžment