What is polymorphism? Explain different types of polymorphism in java programming, with the help of examples.

Explain accessibility rules for packages in java.

Explain uses of abstract class in java with the help of an example

Write a java program to create a Teacher class and define constructors. Inherit Professor class, Associate_Professor class and Assistant_Professor class from the Teacher class. Define appropriate methods to calculate salary of teachers. Show how to implement method overriding in this program. Make necessary assumptions.

Write a java program to find the factorial of a given number.

Explain use of super and final keywords in java.

What is a class ? Explain how you will define Book class in java. Also, explain use of getter and setter methods.

Explain use of different operators in java.

What is Object Oriented Programming? Explain concept of encapsulation with example in java.

Consider the Relation R={A, B, C, D, E, F, G } and the set of functional dependencies. 

  A→F     B→CD     C→G F →E    

What is the key for R? With the help of a suitable example discuss the Insertion, Deletion and Updation anomalies which can arise if the relation is not in 2NF and 3NF ? Decompose R into 2NF, 3NF and finally in BCNF relation.

Consider a “Library Management System” which keeps the following tables: Book (isbn-no, book-title, author, publisher, edition, year-of-copyright) BookAccession (accession-no, isbn-no, date-of-purchase) Members (m-id, m-name, m-address, m-phone). Issue-return (accession-no, m-id, expected-date-of-return, actual-date-of-return) 7 Please note that a member can be issued a book for a period of 15 days. The actual-date-of-return is kept blank for the books that have not been returned. Write and run the following SQL queries on the tables:

(i) Find the m-id and m-name of the members who have got maximum number of un-returned books

(ii) List the book details along with the number of copies for that book in the library (issued or notissued both)

(iii) Find the names of all those students who have got all the books issued to him of the author named “ABC” .

(iv) Find the books that are expected to be returned in this week.

(v) Find those members who have not got any book issued to him/her during last six months.

Suppose you are given the following requirements for a simple database for the National Football League (NFL):

• the NFL has many teams,

• each team has a name, a city, a coach, a captain, and a set of players,

• each player belongs to only one team,

• each player has a name, a player position (such as Centre Forward, left midfield, center midfield, right midfield, left fullback, centre back etc..), a skill level, and a set of injury records,

• a team captain is also a player,

• a game is played between two teams (referred to as host_team and guest_team) and has a date (such as May 11th, 2000) and a score (such as 4 to 2).

Construct an ER diagram for the NFL database using the Chen notation with all conventions. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram

a) Draw and explain the detailed system architecture of DBMS

b) With the help of a diagram, describe the concept of client/server model.

c) Explain in detail about various key constraints used in database system. Give examples for each.

d) Explain the importance of Null values in Relational Model.

e) Discuss the mechanism of attribute relationship inheritance. How is it useful?

f) By considering an example describe various data update operations in SQL. Give examples.

g) Explain insertion, deletion and modification anomalies with suitable examples.

h) State BCNF. How does it differ from 3NF?

i) How can a database recover from failure when many transactions are going on? Describe with the help of an example.

j) What is a distributed database management system? How is it different to that of client server database systems?

Define IPSec? What are its features? Discuss its implementation in Windows 2000

What are intrusion detection systems (IDS)? What IDS can do?

Discuss the protocols and tools for providing secure VPN services

Differentiate between dial-up connection and VPN connection for remote access. List the requirements to set up a VPN connection. Explain the steps for configuring Windows 2000 VPN

What are the three strategies that can be used to authenticate a user to a computer system? Describe how authentication can be done using hardware tokens.

Write a Shell Script program to find Greatest Common Divisor (GCD) for any two numbers. Ensure that your script carries out basic error checking

Explain functions of Primary Domain Controller. Also, explain the role of the 'primary domain controller' and 'backup domain controller' in enhancing security of window 2000 server.