Difference between T-SQL and the Relational Model
Journal Title: TEM JOURNAL - Year 2015, Vol 4, Issue 3
Abstract
T-SQL, dialect of SQL, is a language used for a relational database management system (primarily Microsoft’s SQL Server), which in turn is based on the relational model. Understanding some of the key foundation principals can help in a better understanding of the language. This paper introduces basics of the relational model and the difference between the relational model and the actual T-SQL implementation.Several tightly related topics like predicates, relations, and common misconceptions about databases are also discussed.
Authors and Affiliations
Davor Lozić, Alen Šimec
Keywords
Related Articles
- EP ID EP100771
- DOI -
- Views 171
- Downloads 0
Experimental Measurements of Belt Gears in Newly Developed Device
The paper deals with the alternative of determination of state of the belt gear. To realize themeasurements a newly developed device was designed for measurement and diagnostics of the belt gears. The main task is...
Analysis and assessment of injury risk in female gymnastics: Bayesian Network approach
This paper presents a Bayesian network (BN) model for estimating injury risk in female artistic gymnastics. The model illustrates the connections betweenunderlying injury risk factorsthrough a series ofcausal d...
One implementation of API interface for RouterOS
The purpose of this publication is to present the implementation of API interface for RouterOS of the company MikroTik, which allows using PHP scripts for obtaining data for configuration and management of the routing de...
Programs for Offenders Depending on Substance
Substance abuse is a significant factor in the maintenance of criminal behaviour and substance abuse treatment plays an important role in preventing recurrence. The last decade of the 20th century in the world are marked...
Educational Computer Software "Inheritance Mechanisms" in Biology Lectures
The author's interests are connected with the introduction of the new Infocommunication Technologies in biology educatione. Computer application in educational system should include thoroughly designed complex procedure...