IGNOU BCA MCA

Question 2 Solution             (a)    Select Supplier.su_id, supplier.Name.su (Supply of per quantity of supply) from supplier On supplier.su_id inner join supply of par su_id group by su_id (b)    Begin Transaction Trans Go Use Adventure work 2008 R GO SELECT + Money From Adventurework 2008 R Human Resource.Account Where Acount No. = 123456 Commit Transaction @ Account No Go = Begin Trasaction Tran 2 Go Use Adventure Work 2008 R2 Go Insert into Adventure work 2008 R2 VALUES (10000, ACCOUNT No. ) Commit Transaction @ Account No. (c)     Create view supplier As Select * FROM Supplier Where su_id = @ su_id = create view system manager As Select * from supplier su_id, supplier.su_name Supplier.su_address, supplier.su_status Supply of part.su_id, supply of part. Pa_id, supply of part. Date of supply, supply of part.quanitity of Supply, supply of part.su_price from Supplier on supplier.su_id inner join Supply of part.su_id (d)    Transaction processing is designed to maintain a co