Chapter2RelationalModel.pptVIP

Insertion To insert data into a relation, we either: specify a tuple to be inserted write a query whose result is a set of tuples to be inserted in relational algebra, an insertion is expressed by: r ? r ? E where r is a relation and E is a relational algebra expression. The insertion of a single tuple is expressed by letting E be a constant relation containing one tuple. Insertion Examples Insert information in the database specifying that Smith has $1200 in account A-973 at the Perryridge branch. Provide as a gift for all loan customers in the Perryridge branch, a $200 savings account. Let the loan number serve as the account number for the new savings account. account ? account ? {(“A-973”, “Perryridge”, 1200)} depositor ? depositor ? {(“Smith”, “A-973”)} r1 ? (?branch_name = “Perryridge” (borrower loan)) account ? account ? ?loan_number, branch_name, 200 (r1) depositor ? depositor ? ?customer_name, loan_number (r1) Updating A mechanism to change a value in a tuple without charging all values in the tuple Use the generalized projection operator to do this task  Each Fi is either the I th attribute of r, if the I th attribute is not updated, or, if the attribute is to be updated Fi is an expression, involving only constants and the attributes of r, which gives the new value for the attribute Update Examples Make interest payments by increasing all balances by 5 percent. Pay all accounts with balances over $10,000 6 percent interest  and pay all others 5 percent account ? ? account_number, branch_name, balance * 1.06 (? BAL ? 10000 (account )) ? ? account_number, branch_name, balance * 1.05 (?BAL ? 10000 (account)) account ? ? account_number, branch_name, balance * 1.05 (account) End of Chapter 2 * * Example Queries Find the names of all customers who have a loan at the Perryridge branch. Find the names of all customers who have a loan at the  Perryridge branch but do not have an account at an