Bank Database Management System
저자: Sudhindra Prakash
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
