Hi sir/Madam
My name is Raju Bootla. Please provide for TYBsc.CS 5th Sem Notes.
Posts: 810
Threads: 0
Joined: Jul 2016
Mumbai University Notes For TY B.Sc Computer Science
Subjects
Major Papers
Paper I: Data Communication, Networking and Security
Paper II: Advanced Java
Paper III: Operating Systems and Linux
Paper IV: DBMS - II and Software Engineering
Applied Component
Paper I: Principles of Web Design and Web Technologies
Paper II: Dot Net Technologies
Practicals
Group I : Linux and Databases
Group II: Advanced Java
Group III: Elements of Software Engineering and Project Management
Group IV: OOAD Project
Project
Learning by Experience
A major component of TYBSc is the project work which the student is expected to complete in consultation with a project guide from the college.
T.Y.BSC. Computer Science, Paper
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.
Posts: 14,118
Threads: 61
Joined: Oct 2014
to get more about it please search
https://scribddoc/51001902/Ty-Bsc-Computer-Science
http://archive.mu.acmyweb_test/T.Y.B.Sc....eering.pdf