Enterprise Integration & Modeling: Metadatabase Research Home
 home || MDB Research | Virtual Lab | Case Tool | Downloads | Publications | Researchers | Links

List of FD's

A. Branch Manager Report (Exception)

The data elements representing the entities of this report are:

BRANCH-NO, BRANCH-NAME, BRANCH-ADDR, MGR-NAME, ACCT-NO, ACCT-TYPE, CID,          
CUST-NAME, X-DATE, X-TIME, X-TYPE, AMOUNT, REASON-CODE, ACTION-CODE, REMARKS

The FD relationships between the data elements are:

1. BRANCH-NO ---> BRANCH-NAME, BRANCH-ADDR, MGR-NAME

For a given BRANCH-NO there is only one BRANCH-NAME and BRANCH-ADDR (branch address), and also only one MGR-NAME (manager name).

2. ACCT-NO ---> ACCT-TYPE, BRANCH-NO, CID. 

For a given ACCT-NO (account number) there is only one ACCT-TYPE (account type). But there may be many accounts of the same type. This is a one-to-many mapping.

3. CID ---> CUST-NAME. 

A given CID (customer identification number) uniquely identifies the CUST-NAME (customer name).

But there may be many customers with the same name. This is also a one-to-many mapping.

4. ACCT-NO*X-DATE*X-TIME ---> X-TYPE, AMOUNT

The ACCT-NO (account number) with X-DATE (transaction date) and X-TIME (transaction time) uniquely identify the transaction. The X-TYPE (transaction type), and the AMOUNT are uniquely determined.

5. ACCT-NO*REASON-CODE ---> ACTION-CODE, REMARKS

The action to be taken (ACTION-CODE) and the REMARKS to be registered for an exception are dependent on the REASON-CODE and on the ACCT-NO (account number), that is, on the customer for whom an exceptional action has to be taken.

B. Branch Manager Report (Weekly Exception Summary)

The data elements representing the entities of this report are:

BRANCH-NO, BRANCH-NAME, BRANCH-ADDR, MGR-NAME, REASON-CODE, DSTRPT, DENDRPT,
NO-X-TOTAL, NO-ACCTS-TOTAL, AMT-TOTAL

The FD relationships between the data elements are represented below.

6. BRANCH-NO ---> BRANCH-NAME, BRANCH-ADDR, MGR-NAME
7. BRANCH-NO.*DSTRPT*DENDRPT*REASON-CODE ---> NO-X-TOTAL, NO-ACCTS-TOTAL,
AMT-TOTAL.

C. Branch Loan Status

The data elements representing the entities of this report are:

BRANCH-NO, BRANCH-NAME, BRANCH-ADDR, MGR-NAME, LOAN-NO, LOAN-TYPE, LOAN-ASSGND,          
TOTAL-LOAN-COLLECTED, TOTAL-LOAN-TO-BE-COLLECTED, INTEREST, BRANCH-NO, CID

The FD relationships between the data elements are represented below.

8. BRANCH-NO ---> BRANCH-NAME, BRANCH-ADDR, MGR-NAME
9. LOAN-NO ---> LOAN-TYPE, LOAN-ASSGND, TOTAL-LOAN-COLLECTED,
TOTAL-LOAN-TO-BE-COLLECTED, INTEREST, BRANCH-NO,CID

D. Teller Cash Drawer

The data elements representing the entities of this report are:

BRANCH-NO, BRANCH-NAME, BRANCH-ADDR, TELLER-NO, TELLER-NAME, B-DATE,
COH-SOD, COH-EOD, CASH-RECD, CASH-DISPENSED, CHECKS-RECD-US, CHECKS-RECD-OTHER,
CHECKS-RECD-TOTAL, AMT-RECD-US, AMT-RECD-OTHER, AMT-RECD-TOTAL,
CHECKS-DISPENSED-TOTAL, NET-FLOW, AMT--CHECKS-DISPENSED-TOTAL

The FD relationships between the data elements are represented below.

10. BRANCH-NO ---> BRANCH-NAME, BRANCH-ADDR
11. TELLER-NO ---> TELLER NAME
12. TELLER-NO*B-DATE ---> BRANCH-NO, COH-SOD, COH-EOD, CASH-RECD,
CASH-DISPENSED, CHECKS-RECD-US, CHECKS-RECD-OTHER, CHECKS-RECD-TOTAL,
AMT-RECD-US, AMT-RECD-OTHER, AMT-RECD-TOTAL, CHECKS-DISPENSED-TOTAL,
NET-FLOW, AMT-CHECKS-DISPENSED-TOTAL.

E. Teller Audit Report

The data elements representing the entities of this report are:

BRANCH-NO, BRANCH-NAME, BRANCH-ADDR, TELLER-NO, TELLER-NAME, B-DATE,
AUDIT-REASON, NO-X-TYPE1, NO-X-TYPE2, LARGEST-AMT-TYPE1, LARGEST-AMT-TYPE2

The FD relationships between the data elements are represented below.

13. BRANCH-NO ---> BRANCH-NAME, BRANCH-ADDR
14. TELLER-NO ---> TELLER-NAME
15. TELLER-NO*B-DATE ---> BRANCH-NO, AUDIT-REASON, NO-X-TYPE1, NO-X-TYPE2,
LARGEST-AMT-TYPE1, LARGEST-AMT-TYPE2

F. INQUIRY Transaction

The data elements representing the entities of this report are:

ACCT-NO, ACCT-TYPE, BALANCE, CID, CUST-NAME, CUST-ADDR, CUST-TEL-NO,
CUST-DOB.

The FD relationships between the data elements are represented below.

16. ACCT-NO ---> ACCT-TYPE, BALANCE, CID
17. CID ---> CUST-ADDR, CUST-TEL-NO, CUST-DOB
18. CUST-NAME*CUST-DOB <---> CID

G. DEPOSlT/WITHDRAWAL Transaction

The data elements representing the entities of this report are:

ACCT-NO, ACCT-TYPE, BALANCE, BRANCH-NO, BRANCH-NAME, BRANCH-ADDR, X-DATE,
X-TIME, X-TYPE, X-NO, AMOUNT, TELLER-NO, PASSBOOK-LINE-NO.

The FD relationships between the data elements are represented below.

19. ACCT-NO ---> ACCT-TYPE, BALANCE, BRANCH-NO
20. BRANCH-NO ---> BRANCH-NAME, BRANCH-ADDR
21. ACCT-NO*X-DATE*X-TIME ---> X-TYPE, X-NO, AMOUNT, TELLER-NO, PASSBOOK-LINE-NO
 

viu.eng.rpi.edu is hosted by Professor Cheng Hsu.
Rensselaer Polytechnic Institute
Department of Industrial and Systems Engineering (formally Decision Sciences & Engineering Systems)
110 8th St., Center for Industrial Innovation, Room 5219, Troy, NY 12180-3590

Copyright © 1997-2016. MetaWorld, Nothing on this site may be commercially used without written consent.

Valid XHTML 1.0! Valid CSS!