Section outline

  • WEEK SIX

    Learning Objective:

    • Sub query
    • Nested Query on Joining
    • Union/ Union All
    • Intersect,Minus

    • url icon
      Data of Slide 6 URL
      Students must
      View

      Bank Database
      branch (branch_name, branch_city, assets)

      customer (customer_name, customer_street, customer_city)

      loan (loan_number, branch_name, amount)

      borrower (customer_name, loan_number)

      account (account_number, branch_name, balance)

      depositor (customer_name, account_number)