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

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.

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

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

Perform a cost-benefit analysis for the proposed software and report its findings

What may be the financial benefits of installing such a system?

What would be major costs of the system development?

Justify you selection by evaluating suitability of at least two SDLCs.

Which Systems Development Life Cycle (SDLC) will you propose for the specification given above? Explain the proposed SDLC.

What is clustering technique for data mining? Explain.

. How are implementations of triggers in Oracle different from the standard implementations?

What are Semantic databases? Give the features of semantic databases. Discuss the process of searching the knowledge in these databases

What is Hash-Join? How is hash-join between two relations computed? Explain cost calculation for simple hash join.

Define deadlock. How it can be presented? Write an algorithm that checks whether the concurrently executing transactions are in deadlock.

What is time stamp ordering? Explain timestamp based protocol for serializable schedule.

What is concurrent transaction? What is the condition for occurrence of conflicting operations in transactions? Give an example illustrating conflicting operations of concurrent transaction.

Define the terms: Serializable and Conflict Serializable. Determine whether the following schedule A is serializable and conflict serializable or not?

                       Schedule A:

Define the third NF. Justify whether the following student relationship is in the third NF or not?

Student (Rollno, S_name, Department, Year, Hostel_name)

Year → Hostel_name

IF it is not in the third NF, convert it into the third NF

What is XML? How does XML differ from HTML? List advantages of XML

Explain the following with the help of an example.

 (a) Dynamic SQL

 (b) Query Optimization