Page 143 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE
P. 143
Database Management Systems/Managing Database
Notes
Accounts Table
Acc_id Acc_type Min.bal
994 SB 1000
340 CA 500
699 SB 1000
Transaction Table
Tran_.id Acc_id Tran_type Tan_mode Amount
14300 994 B/F 1000
14301 994 Deposit Bycash 1000
14302 994 Withdrawal ATM 500
14303 340 B/F 3500
14304 340 Deposit Payroll 3500
14305 340 Withdrawal ATM 1000
14306 699 B/F 6000
14307 699 Credit Bycash 2000
14308 699 Withdrawal ATM 6500
Tables after Third Normal Form
Customer Table
Cust_id Name Address
001 Ravi Hyd
110 Tim Sec'bad
420 Kavi Vizag
Customer Accounts Table
Cust_id Acc_id Balance
001 994 1500
110 340 6000
420 699 1500
Acc_Detail Table
Acc_id Acc_type
994 SB
340 CA
699 SB
Product Table
Acc_type Min_bal
SB 1000
CA 500
136 LOVELY PROFESSIONAL UNIVERSITY
