Result of σΠbranch-name( branch-city = “Brooklyn”(branch)) Database System Concepts 3.101 ©Silberschatz, Korth and Sudarshan Result of Πcustomer-name, branch-name(depositor account) Database System Concepts 3.102 ©Silberschatz, Korth and Sudarshan 51
The credit-info Relation Database System Concepts 3.103 ©Silberschatz, Korth and Sudarshan Result of Πcustomer-name, (limit – credit-balance) as credit-available(credit-info). Database System Concepts 3.104 ©Silberschatz, Korth and Sudarshan 52
The pt-works Relation Database System Concepts 3.105 ©Silberschatz, Korth and Sudarshan The pt-works Relation After Grouping Database System Concepts 3.106 ©Silberschatz, Korth and Sudarshan 53
Result of branch-name ς sum(salary) (pt-works) Database System Concepts 3.107 ©Silberschatz, Korth and Sudarshan Result of branch-name ς sum salary, max(salary) as max-salary (pt-works) Database System Concepts 3.108 ©Silberschatz, Korth and Sudarshan 54
The employee and ft-works Relations Database System Concepts 3.109 ©Silberschatz, Korth and Sudarshan The Result of employee ft-works Database System Concepts 3.110 ©Silberschatz, Korth and Sudarshan 55
The Result of employee ft-works Database System Concepts 3.111 ©Silberschatz, Korth and Sudarshan Result of employee ft-works Database System Concepts 3.112 ©Silberschatz, Korth and Sudarshan 56
Result of employee ft-works Database System Concepts 3.113 ©Silberschatz, Korth and Sudarshan Tuples Inserted Into loan and borrower Database System Concepts 3.114 ©Silberschatz, Korth and Sudarshan 57
Names of All Customers Who Have a Loan at the Perryridge Branch Database System Concepts 3.115 ©Silberschatz, Korth and Sudarshan E-R Diagram Database System Concepts 3.116 ©Silberschatz, Korth and Sudarshan 58
The branch Relation Database System Concepts 3.117 ©Silberschatz, Korth and Sudarshan The loan Relation Database System Concepts 3.118 ©Silberschatz, Korth and Sudarshan 59
The borrower Relation Database System Concepts 3.119 ©Silberschatz, Korth and Sudarshan 60
Search
