'Loanwhere borrower loan number' presentation slideshows

Chapter 3: SQL

Chapter 3: SQL. Data Definition Language Basic Structure of SQL Set Operations Aggregate Functions Null Values Nested Subqueries. Schema Used in Examples. DDL and DML. DDL: Data Definition Language Changes data base schema Example: create table, drop table, alter table, create index

676 views • 49 slides

Structured Query Language 2

Structured Query Language 2. Presented by: Annisa , M.Kom . Source: Database System Concepts 5 th edition. ACCOUNT. DEPOSITOR. BRANCH. CUSTOMER. BORROWER. LOAN. Figure 3.3: Tuples inserted into loan and borrower. Figure 3.4: The loan and borrower relations. Tuple Variables.

540 views • 42 slides

Structured Query Language 2

Structured Query Language 2. Presented by: Annisa , M.Kom . Source: Database System Concepts 5 th edition. ACCOUNT. DEPOSITOR. BRANCH. CUSTOMER. BORROWER. LOAN. Tuple Variables. Find the names of all branches that have greater assets than some branch located in Brooklyn.

589 views • 40 slides

349 views • 27 slides

E-R Diagram for a Banking Enterprise

E-R Diagram for a Banking Enterprise. Rel. Schema for a Banking Enterprise. branch (branch-name, branch-city, assets) customer (customer-name, customer-street, customer-only) account (account-number, branch-name, balance) loan (loan-number, branch-name, amount)

5.22k views • 22 slides