(The following tasks can be implemented on Oracle or any other suitable RDBMS with support for Objectfeatures)

1.

Develop a database application to demonstrate storing and retrieving ofBLOB and CLOB objects.

2.

Develop a database application to demonstrate the representation of multivalued attributes, and the useof nested tables to represent complex objects. Write suitable queries to demonstrate their use.

3.

Design and develop a suitable Student Database application. One of the attributes to me maintained isthe attendance of a student in each subject for which he/she has enrolled. Using TRIGGERS, writeactive rules to do the following:

a.

Whenever the attendance is updated, check if the attendance is less than 85%; if so, notify theHead of the Department concerned.

b.

Whenever, the marks in an Internal Assessment Test are entered, check if the marks are lessthan 40%; if so, notify the Head of the Department concerned.

4. Design, develop, and execute a program in a language of your choice to implementthe

algorithm fordeterminingrelevance of a document using TF-IDF approach and demonstrate its working againstsuitable data.

6.Lighting and Shading:Light and matter; Light sources; The Phong lighting model; Computation of vectors;Polygonal shading; Approximation of a sphere by recursive subdivisions; Light sources in OpenGL;Specification of materials in OpenGL; Shading of the sphere model; Global illumination.

Design, develop and execute a program in a language of your choice to determine phase-wiseeffectiveness metrics from the matrix of defect data organized as Defect Origin by Where Found.Experiment with different sets of simulated data or data available from public domains and discuss theimpact early defect removal efforts on software quality.

2.

Design, developand execute a program in a language of your choice to implement the Rayleigh model,plot the graph,and to estimate the latent error rate using the model. Experiment with different sets ofsimulated data or data available from public domains and discuss theresults.

3.

Design, develop and execute a program in a language of your choice to implement the Jelinski-Moranda model, plot the graph, and to estimate the software reliability using the model. Experimentwith different sets of simulated data or data available from public domains and discuss the results.

4.

Design, develop and execute a program in a language of your choice to implement the Musa-Okumotomodel, plot the graph, and to estimate the software reliability using the model. Experiment withdifferent sets of simulated data or data available from public domains and discuss the results.

5.

Design, develop and execute a program in a language of your choice to implement the Delayed Smodel, plot the graph, and to estimate the software reliability using the model. Experiment withdifferent sets of simulated data or data available from public domains and discuss the results.

15. A Closer Look at All Pairs Testing:The all-pairs technique, A closer look at NIST study, Appropriateapplications for all pairs testing, Recommendations for all pairs testing.

16. Software Testing Excellence:Craftsmanship, Best practice of software testing, Top 10 best practices forsoftware testing excellence, Mapping best practices to

diverse projects.

Laboratory Work:

1.

Design, develop, code and run the program in any suitable language to solve the commission problem.Analyze it from the perspective of dataflow testing, derive at least 10 different test cases, excute thsestest cases and discuss the test results.

2.

Design, develop, code and run the program in any suitable language to solve the NextDate problem.Analyze it from the perspective of decision table-based testing, derive at least 10 different test cases,execute thess test cases and discuss the test results.

3.

Design, develop, code and run the program in any suitable object-oriented language to solve thecalendar problem. Analyze it from the perspective of OO testing, derive test cases to test the methodthat increment the date and the method that increments the month., execute these test cases and discussthe test results.

4.

Design, develop, code and run the program in any suitable object-oriented language to solve thecurrency converter problem. Analyze it from the perspective of use case-based system testing, deriveappropriate system test cases., execute these test cases and discuss the test results.

12. Performance of Web Applications:Introduction, What is performance? What characterizes performanceof web applications, System definition and indicators, Characterizing the work load, Analytical techniques,Representing