Aggregate functions cannot be used in WHERE class

If there is no attribute in common, natural join returns only cartesian product.

The join of a relation R with a relation S .If R has m tuples and S has n tuples. Then maximum and minimum sizes of the join are mn and 0

Project command will create a new table that has less fields than the original table.(because we will select only particular columns to show)

Procedural DMLs require a user to specify what data are needed and how to get those data. Declarative DMLs require a user to specify what data are needed without specifying how to get those data

DML is the language used to retrieve, insert, update, and delete data in a database. It includes commands like SELECT, INSERT, UPDATE, and DELETE.

DDL (Data Definition Language) is used to define and modify the structure of database objects such as tables and indexes. Examples include CREATE, ALTER, and DROP.

Query language refers to the overall set of commands and syntax used to interact with a database, which includes both DML and DDL.