Question 1

Write down the steps involved in (a) checking duplicate (b) preparing supply orders (c) merging acquisition record with OPAC with the help of a library software package.

Accepted Answer

Answer available — download the full PDF for complete details.

Question 2

Add 05 publishers in the Master Database and generate a list thereof.

Accepted Answer

The MLIL-002 course on Library Automation emphasizes the practical application of Integrated Library Systems (ILS) for efficient library management. A crucial aspect of this is the creation and maintenance of master databases, including authority files for publishers. These files ensure consistency, accuracy, and standardization of data, which is vital for effective cataloging, searching, and resource discovery within the library's collection.

Adding publishers to a master database, often refer

Question 3

Generate Barcode Labels after entering the data for books and theses (minimum 05 entries each).

Accepted Answer

Library automation significantly enhances operational efficiency, and the generation of barcode labels is a fundamental aspect of this process. Barcodes facilitate rapid and accurate identification of library materials, streamlining tasks such as circulation, inventory management, and shelving. This process involves two primary steps: meticulous data entry for each item and subsequent generation of unique barcode labels based on this data, as elaborated in practical modules like MLIL-002.

The

Question 4

Create a database for 8 departmental budget heads and allocate Rs 2 lakh each for every head. Generate reports for the list of budget heads and the amount allocated.

Accepted Answer

Library automation, as explored in MLIL-002, significantly streamlines administrative tasks, including financial management. Creating a database for departmental budget heads is a fundamental application, enabling efficient allocation, tracking, and reporting of funds. This process typically involves defining a database structure, populating it with relevant data, and then executing queries to generate required reports.

To begin, we would establish a relational database management system (RDBMS

Question 5

Create a database of 10 national and international periodicals. Generate reports for the list of national and international journals by subject.

Accepted Answer

Library automation systems are pivotal in efficiently managing diverse library resources, including periodicals. As per MLIL-002, creating and managing a database for periodicals involves defining appropriate data fields, populating them with accurate information, and utilizing the system's querying capabilities to generate insightful reports. This practical approach enhances access, streamlines collection management, and supports informed decision-making within the library.

Database management

MLIL-002 Solved Assignment — January 2026 / July 2026

Library Automation (Practical) | IGNOU Post Graduate Diploma in Library Automation and Networking (PGDLAN)

MLIL-002—January 2026 / July 2026

Library Automation (Practical)

Questions & Answers

Download Study Materials

Related Courses

MLIL-002 Assignment Questions — January 2026

Q1. Write down the steps involved in (a) checking duplicate (b) preparing supply orders (c) merging acquisition record with OPAC with the help of a library software package.

Q2. Add 05 publishers in the Master Database and generate a list thereof.

Q3. Generate Barcode Labels after entering the data for books and theses (minimum 05 entries each).

Q4. Create a database for 8 departmental budget heads and allocate Rs 2 lakh each for every head. Generate reports for the list of budget heads and the amount allocated.

Q5. Create a database of 10 national and international periodicals. Generate reports for the list of national and international journals by subject.