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

Dear Friends here we post the available solution to the assignments if you have any doubt about any question please comment it. Question 1: (a) Assume you have the following jobs to execute with one processor             Process                                     Burst Time                    Arrival Time    P1                                     75                                   0     P2                                   40                                   10    P3                                   25                                      10    P4                                     20                                      80    P5                                   45                                      85             Support a system uses RR scheduling with a quantum of 15. a)   Create a Gantt chart illustrating the execution of these processes. b)       What is turn around time for process P3. c)   What is the average wait time for the processes?