Create a simple JSP page for your study centre, which includes declaration, scriptlets, expressions and comments tag in it.

What is Java Bean ? Briefly explain the four categories of bean property.

Write appropriate triggers, exceptions and functions for the above study centre management system database schema and describe them briefly.

Perform following queries using SQL:

(i) Find the name of the programmes those are been activated in the given study centre = “111”.
(ii) Find the no. of fresh admission students in MCA and BCA programmes for Jan-2023 session allotted to study centre = “456”.
(iii) Display the corresponding Regional Centre Code if the study centre code is given.
(iv) Display the list of all the academic counsellors who are counselling for MCSL-045 course.
(v) Display the total no. of assignments received in the current session for the MCSL-045 course.

Create an appropriate database for a study centre management system. (Perform Normalization till the required levels) with meaningful data of 10 records each per table

Write a shell script to convert all the lower case letters to uppercase in a given text file.

Write a shell script to find whether the given year is a leap year or not.

Write a shell program to count number of characters, number of lines and no. of other symbols in a given file.

Write the UNIX commands for the following:
(a) To print the calendar for the current month.
(b) To append the contents of file1 after the contents of the file2 and redirect them to a new file3.
(c) To print the first difference between any two given files.
(d) To change the command prompt from $ to !.
(e) To grant the permissions of r w x to the user and read, execute permissions to the group and others for all the files in a current directory.
(f) To direct a standard output to any of the line printer.
(g) To list all the files in the current directory whose file names starts with f.
(h) To execute some command even after logout.
(i) To split a file splittest, which is containing 20 lines into 5 lines each which are directed to four various files.
(j) To display the last 2 lines in a given text file.

Background and Project Specifications:

A warehouse maintains the information about its inventory using a “Materials Management System”. This system is used to maintain information about the receipt and issue of material to different persons/departments of the company. Every person/department in the company is given a username and password for using the Materials Management System. A person can request various items from the warehouse from their account by specifying the item code/name, quantity required and the purpose of using that item. The warehouse staff issues those items to the person and takes a receipt of the issue. The Materials management system is also used to maintain a minimum level of inventory based on its use in the warehouse. In case an item falls below the minimum level, a purchase order for those goods is generated. The system also maintains an approved list of suppliers to whom these orders are issued.

You may study the requirements for the Materials Management System in more detail. Perform the following tasks for the proposed system:

Q1: 

(a) Which Systems Development Life Cycle (SDLC) will you propose for the specification given above Explain the proposed SDLC.
(b) Justify you selection by evaluating suitability of at least two SDLCs.

Q2:

(a) What would be major costs of the system development?
(b) What may be the financial benefits of installing such a system?
(c) Perform a cost-benefit analysis for the proposed software and report its findings.
(d) List the major tasks and milestones of the Project and make a project schedule. The schedule must
include both GANTT and PERT charts. Explain the two charts drawn by you.

Q3: 

(a) Study the system and create a software requirement specification. You must identify either the processes or objects while analyzing. During the analysis identify and explain possible input and output of the processes.
(b) After identifying the requirements, create Analysis Models. You may either use the classical approach and draw Entity relationship diagram and data flow diagrams (DFD’s) up to level 2-3; or you may take object-oriented analysis approach and create class diagram, use case diagram, use cases etc.

Q4: 

(a) Design the system architecture and the database as per the system’s needs. You must perform normalization on tables up to 3rd normal form. The table design must include Primary and Foreign keys and constraints.

(b) Create the system flow chart or detailed process design and state transition diagrams. Also design the
user input screens and output report formats.

Q5:

Design various unit test cases for different testing techniques/strategies. 

Explain the transaction management and indexing in PostgreSQL.

Briefly explain the architecture of the Oracle Database Management System

What are Multimedia databases? What are the challenges in designing multi-media databases? Also, explain the requirements of a Geographical Information System and features of Genome databases.

Explain the characteristics of a data warehouse. What are the components of a data warehouse? Explain. Also, explain the multi-dimensional data, star schema and snowflake schema in the context of a data warehouse with the help of an example. How is a data warehouse related to data mining?

How is the SELECT and JOIN operation can be performed in a DBMS? Explain the Index Scan in the context of the SELECT operation. What is the cost of performing the SELECT operation using Index Scan? Also, write and explain the algorithms for performing a join using Nested-loop join and Block-nested loop join methods. Also, illustrate the computation of the cost of the join operations for Nested loop join with the help of an example.

What is access control in the context of DBMS? What are the different access permissions that can be granted using SQL? Explain with the help of an example of each. Explain the concept of Statistical database security with the help of an example.

Explain the concept of log-based recovery with the help of an example for the deferred database modification scheme. What is a checkpoint? How can it be used in recovery? Explain with the help of an example.

Explain the term Serializability with the help of an example. Explain the two-phase locking protocol in the context of concurrent transactions. Also, explain the timestamp-based protocols for concurrent transactions.

Explain the multi-valued dependency and Join-Dependency with the help of an example of each. Explain the 4th Normal Form and 5th Normal Form with the help of an example of each.

Create an XML document for Books using Book ID as an attribute. It should include information about the title of the Book, Author list of the Book, ISBN number of the book, Publisher of the Book, price of the book, year of publication and a brief description of the book. Create the necessary DTD to verify the document. You should show data of at least 3 books