The National Bank of Erehwon handles money and maintains bank accounts on behalf of clients. A client is a person who does business with the bank. A client may have any number of accounts, and an account may belong to multiple clients (e.g., spouses, business partners). The client record is used for identification and contact data. For each account, the bank maintains the current balance on hand. Clients are identified by a five digit number starting with 10001. Accounts are identified by a seven digit number starting with 1000001. When an account is first opened, its balance is set to zero. During the course of day-to-day business, Erehwon Bank applies transactions to accounts, including deposits, withdrawals, bill payments, and debit purchases or returns. For each transaction, the date and time, amount, and account are recorded, along with reference data applicable to that type of transaction: Deposits and withdrawals require the branch number to be recorded. Bill payments, and debit purchases or returns require the merchant number. Building and Populating the Schema  Develop a database in Oracle to implement the Erehwon Bank scenario.  Populate your database with the test data. Views: To facilitate queries, three views are required. generate your SQL script(s) as well as a SELECT * FROM … listing of each view. Join of Client to Account via the Owns table, containing the client’s number, name, the account number, and balance. (Hint: Use an outer join as one client has no accounts.)

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

The National Bank of Erehwon handles money and maintains bank accounts on behalf of clients.

  • A client is a person who does business with the bank.

  • A client may have any number of accounts, and an account may belong to multiple clients (e.g., spouses, business partners).

  • The client record is used for identification and contact data.

  • For each account, the bank maintains the current balance on hand.

  • Clients are identified by a five digit number starting with 10001.

  • Accounts are identified by a seven digit number starting with 1000001.

When an account is first opened, its balance is set to zero. During the course of day-to-day business, Erehwon Bank applies transactions to accounts, including deposits, withdrawals, bill payments, and debit purchases or returns. For each transaction, the date and time, amount, and account are recorded, along with reference data applicable to that type of transaction:

  • Deposits and withdrawals require the branch number to be recorded.

  • Bill payments, and debit purchases or returns require the merchant number.

Building and Populating the Schema 

Develop a database in Oracle to implement the Erehwon Bank scenario. 

Populate your database with the test data.

Views:

To facilitate queries, three views are required. generate your SQL script(s) as well as a SELECT * FROM … listing of each view.

Join of Client to Account via the Owns table, containing the client’s number, name, the account number, and balance. (Hint: Use an outer join as one client has no accounts.)

Expert Solution
steps

Step by step

Solved in 9 steps with 5 images

Blurred answer
Knowledge Booster
Distributed Database Concepts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-engineering and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY