I need notes of tybsc softwere engineearing

mumbai university sixth semester tybsc computer science software engineering notes


1. Write short notes on(any four) :- [20 Marks]
(a) Closure set of FD.
(b) Transaction management commands in SQL.
© Use case estimation
(d) Phases in Unified processes.
(e) Deadlock prevention
(f) CMM.

2. Attempt the following(any 4):- [20 Marks]
(a) What is the need of decomposition? Explain one property of decomposition.
(b) Discuss anamolies associated with interleaved transaction.
© What is schedule? Explain the concept of conflict serializability.
(d) What is the role of lock manager? Explain the concept of upgrading and
downgrading locks.
(e) Explain the working of 'Redo Phase' of ARIES.
(f) How checkpoint mechanism helps in recovery of database?

3. Attempt the following(any four):- [20 Marks]
(a) With syntax explain any loop construct in PL/SQL. Give example.
(b) Consider table product with columns prodno, name, quantity and rate.
Write a PL/SQL code to update rate of specified product. Give proper error message
if product does not exist.
© Define sequence to generate list of numbers as 10,20,30,.......,1000. Use this sequence
to insert data into product table given in Question No.3(b). i.e. product nos. as 10,10,....)
(d) What is cursor? Explain any three cursor attributes.
(e) Write a note on system catalog.
(f) Write in brief about evaluation of relational operators.

4. Attempt the following(any 4):- [20 Marks]
(a) What is the role of Project Manager?
(b) Write in brief about 'Requirement Change Management '
© Explain the concept of LOC with example.
(d) Explain the concept of WBS with example.
(e) Discuss the principles of agile development.
(f) List the various metrics from CK metric suit. Explain any two.

5. Attempt the following(any 4):- [20 Marks]
(a) What are the objectives of software testing? Explain any two.
(b) With respect to testing define following: -
Fault, Error, Test Case, Test bed , Test.
© What is static testing? Explain in brief.
(d) What is integration testing and Validation testing?
(e) Discuss advantages and disadvantages of black box testing.
(f) Explain boundary value analysis.