Insertions

1. To insert data into a relation, we either specify a tuple, or write a query whose result is the set of tuples to be inserted. Attribute values for inserted tuples must be members of the attribute's domain.
2. An insertion is expressed by

   

   where is a relation and is a relational algebra expression.

3. Some examples:

   1. To insert a tuple for Smith who has $1200 in account 9372 at the SFU branch.

   

   2. To provide all loan customers in the SFU branch with a $200 savings account.