S.Q.L: Sequel
- Supported by all major commercial database systems
- Standardized( SQL2, SQL3…)
- Interaction, Embedded in programs
- Declarative language, based on relational algebra
DDL: Data Definition Language
create, drop…
DML: Data Manipulation Language
select,insert,delete,update…
Other Commands
indexs, constraints…
3. Select A1, A2, ..., An What to return
1. From R1, R2, ..., Rm Relations
2. Where condition Combination of Filter
Equivalent:
ΠA1,A2,...,An(σcondition(R1×R2,...,Rn))