Page 141 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE
P. 141
Database Management Systems/Managing Database
Notes Tables after Second Normal Form
Customer Table
CusMd 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
Accounts Table
Acc_id Accjype 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
Acc_type and Min_bal columns of Customer_Account table are not fully functionally dependent
on the primary key (dependent on acc_id), a new Accounts table is formed. Similarly, the
Balance is dependent on Cust_id and Acc_id, but not fully functionally dependent on the primary
key, resulting in a new Customer_Accounts table.
Task FNF vs. SNF (First Normal Form vs. Second Normal Form)
134 LOVELY PROFESSIONAL UNIVERSITY
