Difference between T-SQL and the Relational Model

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 basi...

Full description

Saved in:

Bibliographic Details
Published in:	TEM Journal Vol. 4; no. 3; pp. 297 - 300
Main Authors:	Lozic, Davor, Simec, Alen
Format:	Journal Article
Language:	English
Published:	Novi Pazar UIKTEN - Association for Information Communication Technology Education and Science 01.08.2015
Subjects:	Data base management systems Query languages Relational data bases
ISSN:	2217-8309, 2217-8333
Online Access:	Get full text
Tags:	Add Tag No Tags, Be the first to tag this record!

Description
Summary:	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.
Bibliography:	ObjectType-Article-1 SourceType-Scholarly Journals-1 ObjectType-Feature-2 content type line 14
ISSN:	2217-8309 2217-8333
DOI:	10.18421/TEM43-11