Develop SRS for Voter Registration System. SRS should be as per IEEE standard SRS template. Make necessary assumptions.

 CREATE INDEX

GROUP BY with HAVING Clause

 CHECK Constraint

 ALTER TABLE

. Differentiate between Centralized, Distributed, and Parallel Database Systems. Discuss one
application area for each.

 Discuss the objectives of Database Security. Explain any four database security mechanisms used
to protect organizational databases.

 Describe the Shadow Paging Recovery Technique. Compare it with Log-Based Recovery
highlighting their advantages and disadvantages.

Explain the process of Normalization. Illustrate the conversion of a relation from First Normal
Form (1NF) to Third Normal Form (3NF) using a suitable example.

What are Keys in a relational database? Differentiate among the following with suitable
examples. (4 Marks)
 Candidate Key
 Super Key
 Primary Key
 Alternate Key
d. Explain Conflict Serializability.
Construct a precedence graph for a suitable schedule involving two transactions and determine
whether the schedule is conflict serializable.

Explain the concepts of Data Independence and Data Abstraction in DBMS. How do these
concepts improve database application development?

Differentiate between the Hierarchical Database Model, Network Database Model, and Relational
Database Model. Discuss the advantages and limitations of each with suitable examples.

Explain multithreading in Java. Describe the life cycle of a thread with a neat diagram, and write a Java program to create a thread using both the Thread class and the Runnable interface

Explain the concept of Inheritance in Java. Describe the different types of inheritance supported by Java (single, multilevel, hierarchical) and explain why Java does not support multiple inheritance through classes. How is this limitation overcome using interfaces?

What is Object Oriented Programming (OOP)? Explain the four fundamental principles of OOP, namely, Encapsulation, Abstraction, Inheritance, and Polymorphism with suitable examples

There are Three questions in this assignment which carry 80 marks, in total. Rest 20 marks are for viva-voce. Answer all the questions. Give appropriate comments in programs to increase understandability. Wherever required, you may write java program, run it on machine and take its output as part of solution. Please go through the guidelines regarding assignments given in the Programme Guide for the format of presentation.

 Member_Registration page should contain a form with the following fields: o Student Name, o Course, o Contact Number, and

 Book_List page should display information about all the books using a tab

 Home page should display a welcome message for visitors to the library website

– The four web pages should differ only in this division. This division should display the pagespecific information described below: