Appendix 1 Example Database


Return to Table of Contents          Return to previous section

To illustrate the sort of problem that lends itself to solution using an RDBMS, consider the example of a bank that wishes to maintain details of its branches, staff, customers and accounts (including details of investment and withdrawal).

Four entities can readily be identified:

1. Branches of the bank

2. Persons

3. Accounts

4. Transactions

Relationships exist between these entities

· A Branch is managed by an employee of the bank (a person).

· An Account is owned or partly owned by a customer (a person).

· A Transaction is carried out on an account.

· A Transaction is overseen by an employee of the bank.

· A Transaction is carried out at a branch of the bank.

This is represented in the following Entity-Relationship Diagram

Figure 46 Entity Relationship Diagram for a Theoretical Bank

This translates into the following table design in Access:


Figure 47 Table Design For Bank



Return to Table of Contents

Oregon State University, College of Forestry, Forestry Community, Forestry Search, Network Support
OSU | CoF | Community | Search | Forestry Computing Helpdesk

You may direct comments to Websupport
Disclaimer
Last Updated Wednesday, 16-Jul-1997 09:30:56 PDT