Add the following fields in the Table ‘Class’ Class_ID, Class_NAME Add at least 20 records in the table.

1) Create a database ‘LIBRARY USERS’ with the following tables: Students Class Add the following fields in the ‘Students’: Students _Enrollment ID, Students _NAME, Students_AGE, Students _ADDRESS, Class_NAME Add at least 20 records in the table ‘Students’.

Explain the concept of proximity operators.

Define SQL. Describe the need of Structured Query Formulation

Briefly explain the criteria for evaluation of information retrieval systems.

Describe briefly different techniques of Boolean search.

Describe the different types of information system.

Explain the concept of ‘file organisation’.

What is a digital library? Discuss the major and challenges involved in its development

Define Expert Systems. Describe in detail their structure and major components.

Explain the concepts ‘system’ and ‘system approach’

Generate the list of publishers, binders and suppliers separately.

Create a database of five records each for publishers, suppliers and binders with (15) the following fields of books requested by users for acquisition. Approve Name, Address email and contact number. Provide meaningful data on your own

Generate reports for: Books approved, Books rejected and Books requested

Select any four titles from these for approval

Create a database of six books received to be acquired in a library with (15) the following fields: Author, Title, Name of Publisher, Place of Publication, Year of Publication, Pages, Subject Heading and Accession Number. Provide meaningful data on your own

Explain the concept of ‘proximity searching’.

Briefly explain the meaning of UNIMARC and describe its structure

Explain the concept of a field and content designator in a MARC record.

Explain the criteria for evaluation of a document delivery system.