I MLIL-0021

No. of Printed Pages : 2

POST GRADUATE DIPLOMA IN LIBRARY AUTOMATION AND NETWORKING (PGDLAN) C

Term-End Practical Examination

C

June, 2016 MLIL-002 : LIBRARY AUTOMATION Time Allowed : 2 hours

Maximum Marks : 50 (Practical Work : 40 Viva Voce : 10) (Weightage : 40%)

Note : Use soul package (Demo version) to answer the following questions. 1.

(a) Create a database of the following journals 12 subscribed for the year 2012-13_

(i)

Journal of Library and Information Science, published by DLLS, university of Delhi, Delhi. Amount for annual subscription is Z 600/-, ISSN : 0970-714x. Journal of knowledge and communication management, published by Indianjournals.com , Delhi. Amount for annual subscription is Z 3,000/-, ISSN : 2277-7938.

MLIL-002

1

P.T.O.

Journal of Hospitality Application and Research, published by BIT, Mesra. Amount for annual subscription is 2,100/ -, ISSN : 0973-4538. (iv) Journal of organization and Human Behaviour, published by publishing India Group, New Delhi. Amount for annual subscription is 2,900/ -, ISSN : 2277-3274. (v) Resonance - Journal of science education, published by Indian Academy of Sciences, Bangalore - 80. Amount for annual subscription is 500/-, ISSN : 0971-8044. (b) Generate reports for : List of publishers (i) (ii) List of titles, by subject (iii) Alphabetical list of titles (iii)

2. (a) Create a database of new members of a university library for the following categories of users : Professors - 5 nos (i) (ii) PG students - 5 nos UG students - 5 nos (iv) Research scholars - 5 nos (v) Institutional members - 5 nos Allow the users to have access to all the collections available in the library for one year. Provide meaningful data on your own. (b) Generate list of members by category of Users.

MLIL-002

2

3 2 3 15

5