Page 150 - CatalogNEP-PS

Application Development. Case Studies. Storage and File Structure, Indexing and Hashing. Query
Processing

UNIT V (4 Hours)
Query Optimization. Transactions (Serializability and Recoverability)

PRACTICAL (30Hours)

1. Creation of Simple Database using MS Access
2. Queries using SQL
3. Creation of Relations in Database
4. Simple Joins with SQL

SUGGUESTED READINGS:

1. Abraham Silberschatz, Henry F. Korth, and S. Sudarshan ―Database System Concepts‖
McGraw-Hill Education.
2. Raghu Ramakrishnan and Johannes Gehrke, ―Database Management Systems‖
McGraw Hill,

Micro.221 Techniques in Microbiology 1+2

LEARNING OBJECTIVES:

The primary objective of this course is to introduce:
 Various techniques used for the study of microorganisms.
 The instrumentation methods required for conducting microbiological experiments.

LEARNING OUTCOMES:

This course will enable the students to:
 Appreciate the scientific foundation of general microbiology and relate the key learning to
the job of a microbiologist professional.
 Utilise methods and tools for sustainable development of nation through microbiological
interventions.
 Increase the probability of use of different microbial cultures for the benefits society.

THEORY (15 Hours)

UNIT-I (4 Hours)
History and scope of microbiology. Microorganisms and their natural habitats. Emergence and
future of Special Fields of Microbiology.
UNIT-II (5 Hours)

Microscopy; Bright field, Dark field, Phase contrast, Confocal, Fluorescence, TEM,SEM –
Working Principles and applications; Properties of light; Simple staining, differential and special
staining.

UNIT-III (6 Hours)
Bacterial Growth, nutrition, and Culture media; Environmental factors affecting bacterial growth:
physical chemical, temperature, pH, osmotic pressure, light (UV) and bacteriostatic agents.

135