Views Queries

1. A view consisting of branches and their customers

2. Create a view of HQEmployee who work in downtown branch.

3. Do one insert, delete, update, and select queries on HQEmployee view.

depoitor: customer_name 1 Hayes 2 Johnson 3 Johnson 4 Jones 5 Lindsay 6 Smith 7 Turner account number A-102 A-102 A-201 A-217 A-222 A-215 A-305 employee: branch name Perryridge Perryridge Perryridge Downtown Downtown Downtown Austin Austin E employee_name salary 1 Adams 2 Brown 3 Gopal 4 Johnson 5 Loreena 6 Peterson 7 Rao 8 Sato 1500 1300 5300 1500 1300 2500 1500 1600 el loan branch_name Round Hill Downtown Perryridge Perryridge Downtown Redwood Mianus loan_number amount 1 L-11 2 L-14 3 L-15 4 L-16 5 L-17 6 L-23 7 1-93 900 1500 1500 1300 1000 2000 500 account: Filter criteria branch name balance borrower: @localhost [console 1]bank.borrower [@localhost] X Tx: Auto customer-name : loan-number 8 Williams branch city Brooklyn branchname assets - Horseneck own 5 Perryridge Horseneck Bennington Palo Alto Horseneck 8 Round Hill customer-name # 1 customer-street customer_city Sand Hill ts 0 0 0 0 0 0 0 0 5497773 1047731 S79 2 1 SA si nnc yye -In akke kk00k cttc egle nnAn 5 9 47137 11121 rtst snos rer oyo 1BBHRH BMB ^_^ 0 ssshh htuh 0 c1215725 a000-120 1122223 arycnii! 12345678 da 1234567 12345678 1 123456789 10 11 12 depoitor: customer_name 1 Hayes 2 Johnson 3 Johnson 4 Jones 5 Lindsay 6 Smith 7 Turner account number A-102 A-102 A-201 A-217 A-222 A-215 A-305 employee: branch name Perryridge Perryridge Perryridge Downtown Downtown Downtown Austin Austin E employee_name salary 1 Adams 2 Brown 3 Gopal 4 Johnson 5 Loreena 6 Peterson 7 Rao 8 Sato 1500 1300 5300 1500 1300 2500 1500 1600 el loan branch_name Round Hill Downtown Perryridge Perryridge Downtown Redwood Mianus loan_number amount 1 L-11 2 L-14 3 L-15 4 L-16 5 L-17 6 L-23 7 1-93 900 1500 1500 1300 1000 2000 500 account: Filter criteria branch name balance borrower: @localhost [console 1]bank.borrower [@localhost] X Tx: Auto customer-name : loan-number 8 Williams branch city Brooklyn branchname assets - Horseneck own 5 Perryridge Horseneck Bennington Palo Alto Horseneck 8 Round Hill customer-name # 1 customer-street customer_city Sand Hill ts 0 0 0 0 0 0 0 0 5497773 1047731 S79 2 1 SA si nnc yye -In akke kk00k cttc egle nnAn 5 9 47137 11121 rtst snos rer oyo 1BBHRH BMB ^_^ 0 ssshh htuh 0 c1215725 a000-120 1122223 arycnii! 12345678 da 1234567 12345678 1 123456789 10 11 12