|
This entity holds all the bank records needed to pay their employees electronically. |
|
Name |
Code |
Class Name |
|
Reference |
||
|
Reference |
|
Name |
Code |
|
Name |
|
|
Code |
|
|
Data Type |
char(20) |
|
Mandatory |
Yes |
|
Shows the identity of the bank. It is the key to this entity. Every bank has a specific identity. |
|
Name |
|
|
Code |
|
|
Data Type |
char(60) |
|
Mandatory |
No |
|
Stores the full long name of the bank. |
|
Name |
|
|
Code |
|
|
Data Type |
smallint |
|
Mandatory |
No |
|
Comes in a form of a checkbox. The customer can create a questionnaire and have the option to either check or uncheck the box. Ticking the box will show “1” in the database while not checking the box will show “0”. |
|
Name |
|
|
Code |
|
|
Data Type |
date |
|
Mandatory |
No |
|
The customer can be asked for the date of when they opened the account with the bank. This function will show a calendar for an easier selection. |
|
Name |
|
|
Code |
|
|
Data Type |
integer |
|
Mandatory |
No |
|
This only allows whole numbers to be inserted. |
|
Name |
|
|
Code |
|
|
Data Type |
double |
|
Mandatory |
No |
|
Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45 |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask if the customer uses other banks. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask if the customer uses other banks. |
|
Name |
|
|
Code |
|
|
Data Type |
char(100) |
|
Mandatory |
No |
|
String is a data type which includes letters, digits and special characters. It is a sequence of characters. It can ask if the customer uses other banks. |
|
|
|