Entity Bank

Description of Entity Bank

This entity holds all the bank records needed to pay their employees electronically.


List of all Dependencies of the Entity Bank

Name

Code

Class Name

Have Many

Have_Many

Reference

Relation_579402

Relation_579402

Reference


List of Attributes of the Entity Bank

Name

Code

Bank ID

BankId

Bank Name

BankName

BankBoolean1

BankBoolean1

BankDate1

BankDate1

BankInteger1

BankInteger1

BankNumeric1

BankNumeric1

BankString1

BankString1

BankString2

BankString2

BankString3

BankString3


Entity Attribute Bank ID of the Entity Bank

Card of Attribute Bank ID of the Entity Bank

Name

Bank ID

Code

BankId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Bank ID of the Entity Bank

Shows the identity of the bank. It is the key to this entity. Every bank has a specific identity.


Entity Attribute Bank Name of the Entity Bank

Card of Attribute Bank Name of the Entity Bank

Name

Bank Name

Code

BankName

Data Type

char(60)

Mandatory

No


Description of Attribute Bank Name of the Entity Bank

Stores the full long name of the bank.
Example: DBS Bank Ltd / Bank of Singapore Ltd etc


Entity Attribute BankBoolean1 of the Entity Bank

Card of Attribute BankBoolean1 of the Entity Bank

Name

BankBoolean1

Code

BankBoolean1

Data Type

smallint

Mandatory

No


Description of Attribute BankBoolean1 of the Entity Bank

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”.


Entity Attribute BankDate1 of the Entity Bank

Card of Attribute BankDate1 of the Entity Bank

Name

BankDate1

Code

BankDate1

Data Type

date

Mandatory

No


Description of Attribute BankDate1 of the Entity Bank

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.


Entity Attribute BankInteger1 of the Entity Bank

Card of Attribute BankInteger1 of the Entity Bank

Name

BankInteger1

Code

BankInteger1

Data Type

integer

Mandatory

No


Description of Attribute BankInteger1 of the Entity Bank

This only allows whole numbers to be inserted.
Example: It can ask for the bank account number.


Entity Attribute BankNumeric1 of the Entity Bank

Card of Attribute BankNumeric1 of the Entity Bank

Name

BankNumeric1

Code

BankNumeric1

Data Type

double

Mandatory

No


Description of Attribute BankNumeric1 of the Entity Bank

Numeric usually stands for numbers or digits. Numeric(5,2) means there are 5 digits with 2 decimal places, i.e. 123.45
Example: It can ask for the amount of pay earned in a day, i.e. 105.87


Entity Attribute BankString1 of the Entity Bank

Card of Attribute BankString1 of the Entity Bank

Name

BankString1

Code

BankString1

Data Type

char(100)

Mandatory

No


Description of Attribute BankString1 of the Entity Bank

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.


Entity Attribute BankString2 of the Entity Bank

Card of Attribute BankString2 of the Entity Bank

Name

BankString2

Code

BankString2

Data Type

char(100)

Mandatory

No


Description of Attribute BankString2 of the Entity Bank

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.


Entity Attribute BankString3 of the Entity Bank

Card of Attribute BankString3 of the Entity Bank

Name

BankString3

Code

BankString3

Data Type

char(100)

Mandatory

No


Description of Attribute BankString3 of the Entity Bank

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.