Introduction

SQL is an Relational Database Management System (RDBMS)

Terminology

Database : Set of named Relations

Relation(Table) : A table consist of a Schema (description or metadata) and Instance (set of data satisfying the schema)

* Schema is fixed
* Instance can contain duplicate entries of rows but unique entries of columns

Attribute(Column, Field) : \

Tuple(Record, Row) : \