Chapt 4 (Intro to SQL) Flashcards
Considered one of the major reasons for the commercial success of relational databases
SQL language
The origin of SQL is relational predicate calculus called _____
tuple calculus
tuple calculus was proposed initially as the language ________
square
SQL comes from the word
Sequel
SQL is now popularly known as
Structured Query Language
is an informal or practical rendering of the relational data model with syntax
SQL
Main SQL command for data definition
create statement
Identified by a schema name
Includes an authorization identifier and descriptors for each element
SQL Schema
Schema elements
Tables, constraints, views, domains, and other constructs
Named collection of schemas in an SQL environment
Catalog
Relation and its tuples are actually created and stored as a _____ by the DBMS
file