next up previous
Next: Updating Up: Modifying the Database Previous: Deletion


  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.

Page created and maintained by Osmar R. Zaï ane
Last Update: Wed Sep 20 15:45:57 PDT 1995