Bank Database Management System

1. Fraud Detection

1.1. fraudId (primary key)

1.2. CustomerId (foreign key)

1.3. TransId (foreign key)

1.4. Suspisionflag

1.5. Actiontaken

2. Employee

2.1. EmpId (primary key)

2.2. EName

2.3. Role

2.4. BranchId (foreign key)

2.5. Contact_E

3. Transaction

3.1. TransID (primary Key)

3.2. accountNo (foreign key)

3.3. Amount

3.4. TransType

3.5. Date & Time

3.6. Status

4. Branch

4.1. BranchId (primary key)

4.2. BName

4.3. BAddress

4.4. Contact_B

5. Regulatory compliance

5.1. ComplianceId (primary key)

5.2. RType

5.3. Description

5.4. Last_audit_office

5.5. Stutus

6. Customer

6.1. CustomerId (primary Key)

6.2. CName

6.3. CAddress

6.4. Contact_C

6.5. DOB

6.6. Email

6.7. accountNo (foreign key)

7. Account

7.1. accountNo (primary key)

7.2. customereId (foreign key)

7.3. Type

7.4. Balance

7.5. BranchId (foreign key)

8. Loan

8.1. LoanId (primary key)

8.2. CustomerId (primary key)

8.3. LType

8.4. amount

8.5. Interest

8.6. repaymentterm

8.7. Status