|
This entity would hold the record for the entire branch belonging to a particular bank. In this table there are two primary keys. The reason for having two primary keys is that there can never be banks that can have the same branch number. But the branch number can be the same for different banks. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
This attribute would hold the branch identity of the bank. It also acts as the primary key for the BankBranch table. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
This attribute would record the long name of the branch. |
|
Name |
|
|
Code |
|
|
Data Type |
char(150) |
|
Mandatory |
No |
|
This attribute would record the address of the bank branch. |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
No |
|
This attribute would record the postal code of the bank branch. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
This attribute would record the city where the bank branch is situated at. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
This attribute would record the state where the bank branch is situated at. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
Shows the country of where the bank is. |
|
|
|