(a) What is normalization? Discuss BCNF with an example. (b) Define functional dependency. Write Armstrong's axioms property of it. (c) Describe the…

(a) What is normalization? Discuss BCNF with an example.

(b) Define functional dependency. Write Armstrong's axioms property of it.

(c) Describe the inconsistency state from the following transaction (if any).

T1	T2
read (A)
A := A - 5	read (A)
Write (A)	temp := A * 0.12
read (B)	A := A - temp
B := B + 50	Write (A)
Write (B)	Write (B)
commit	B := B + temp
	Write (B)
	commit

(d) Write the responsibilities of a software engineer to design a software.

(e) What is software testing? Write the differences between following terms?

(i) Blackbox testing and whitebox testing

(ii) Verification and Validation.