Discipline Specific Elective

COURSE OBJECTIVES & COURSE OUTCOMES:

Students will be able to

CO1: To explain principle of drug action on receptors.

CO2: Have knowledge on different types of diseases.

CO3: Discuss on different disorders of vitamins and micronutrients.

CO4: Have knowledge about the drugs that treat different metabolic disorders. 

CO5: Relate physicho chemical properties of chemicals to the impact that have on ADME.

CO6: Interpret and explain significant mechanism of regulation of enzymatic action.



CO1: The students will be able to understand what is a microcontroller, microcomputer, embedded system and different components of micro-controller and their interactions.

CO2: The students will be able to understand key concepts of embedded systems like IO, timers, interrupts, interaction with peripheral devices

CO3: The students will be able to learn debugging techniques for an embedded system and analyze the properties of Microprocessors & Microcontrollers.

CO4: The students will be able to gain comprehensive knowledge about architecture and addressing modes of 8051 and apply knowledge and demonstrate programming proficiency using the various addressing modes and data transfer instructions of the target microcontroller and will be able to compare accepted standards and guidelines to select appropriate Microcontroller to meet specified performance requirements.

CO5: The students will be able to write assembly language program in 8051 for various embedded system applications and analyze assembly language programs

CO6: The students will be able to evaluate assembly language programs and download the machine code that will provide solutions real‐world control problems.

Syllabus

UNIT I

 

BASIC CONCEPTS: Database Management System - File based system - Advantages of DBMS over file based system – Database Approach - Logical DBMS Architecture - Three level architecture of DBMS or logical DBMS architecture – Need for three level architecture - Physical DBMS Architecture - Database Administrator (DBA) Functions & Role -Data files indices and Data Dictionary - Types of Database. Relational and ER Models: Data Models - Relational Model – Domains - Tuple and Relation - Super keys -Candidate keys - Primary keys and foreign key for the Relations - Relational Constraints - Domain Constraint – Key-Constraint - Integrity Constraint - Update Operations and Dealing with Constraint Violations - Relational Operations- Entity Relationship (ER) Model – Entities – Attributes – Relationships - More about Entities and Relationships -Defining Relationship for College Database - E-R Diagram - Conversion of E-R Diagram to Relational Database.

 

UNIT II

 

DATABASE INTEGRITY AND NORMALISATION: Relational Database Integrity - The Keys - Referential Integrity - Entity Integrity - Redundancy and Associated  Problems – Single Valued Dependencies – Normalisation - Rules of Data Normalisation - The First Normal Form -The Second Normal Form - The Third Normal Form - Boyce Codd Normal Form - Attribute Preservation -Lossless-join Decomposition - Dependency Preservation.File Organisation : Physical Database Design Issues - Storage of Database on Hard Disks - File Organisation and Its Types - Heap files (Unordered files) - Sequential File Organisation - Indexed (Indexed Sequential) File.Organisation - Hashed File Organisation - Types of Indexes - Index and Tree Structure - Multi-key File Organisation - Need for Multiple Access Paths - Multi-list File Organisation - Inverted File Organisation.

 

UNIT III

 

STRUCTURES QUERY LANGUAGE (SQL):

Meaning – SQL commands - Data Definition Language - Data Manipulation Language - Data Control Language -

Transaction Control Language - Queries using Order by – Where - Group by - Nested Queries.

Joins – Views – Sequences - Indexes and Synonyms - Table Handling.

 

UNIT IV

 

TRANSACTIONS AND CONCURRENCY MANAGEMENT:

Transactions - Concurrent Transactions - Locking Protocol - Serialisable Schedules - Locks Two Phase Locking

(2PL) - Deadlock and its Prevention - Optimistic Concurrency Control.

Database Recovery and Security: Database Recovery meaning - Kinds of failures - Failure controlling methods -

Database errors - Backup & Recovery Techniques - Security & Integrity - Database Security - Authorization.

 

UNIT V

DISTRIBUTED AND CLIENT SERVER DATABASES:

Need for Distributed Database Systems - Structure of Distributed Database - Advantages and Disadvantages of

DDBMS - Advantages of Data Distribution - Disadvantages of Data Distribution - Data Replication - Data

Fragmentation. Client Server Databases: Emergence of Client Server Architecture - Need for Client Server Computing - Structure of Client Server Systems & its advantages.

 

Text References :-

1. Database Systems: R.Elmasri & S.B. Navathe, Pearson.

2. Relational Database Management Systems: Tulasi Ram Kandula, HPH

3. Introduction to Database Management System: ISRD Group, McGraw Hill.

4. Database Management System: R.Ramakrishnan & J.Gehrke, McGraw Hill.

5. Modern Database Management: J.A.Hoffer,V.Rames &H.Topi, Pearson.

6. Database System Concepts: Silberschatz, Korth & Sudarshan, McGraw Hill.

7. Simplified Approach to DBMS: Parteek Bhaia, Kalyani Publishers.

8. Database Management System: Nirupma Pathak, Himalaya.

Lecture Schedule:

 

 


Environmental Biotechnology deals with the basics about environment and different kinds of pollutions and pollutants affecting the environment. The remedy for pollution is being addressed using the implication of Biotechnology tools which would help the environment from these pollutants. It explains the bioenergy – renewable and non-renewable sourced of energy which acts as the alternative source of energy with their further classification as biofuels and their availability. With increasing pollutants in the environment, the concept of bioremediation using microbiology and restoration of environment using plant and microbial sources are increasing with the usage of biotechnology tools.

Course Outcomes

CO 1: Students will be able to understand about the basics of environmental pollutions, different pollutants and their sources.

CO 2: It will help them to understand about effect of pollutions with climate change and global warming.

CO 3: Students will be able to understand the implication of biotechnology tools to address the problems by pollution.

CO 4: They learn about the renewable and non-renewable sources of energy and understand various biofuel sources.

CO 5: They would understand about the application of biotechnology in bioremediation methods using microbes and plant sources

CO 6: Students will be able to describe the concepts and application of various phytoremediation, bioremediation and other methods for restoration of environment.



Objective of Course :

 The main objective of this course is that students will understand the scientific process, in the context of learning the fundamental biological and chemical facts of molecular biology.

 Learning Outcomes:

 On completion of the course the student will be able to do the following:

 CO1. Understand significant discoveries and theories through the historical                              progress of biological scientific discoveries, and their impacts on                                      the development of molecular biology.

CO2. Compare the structure of eukaryotic cells with the structure of simpler                             prokaryotic cells.

CO3. Explain the fundamental structure, properties and processes in which nucleic acids          play a part.

CO4. Explain the molecular mechanisms by which DNA controls development,                          growth or morphological characteristics of organisms.

CO5. Apply the fundamental rules for occupational safety in the laboratory, with                       the proper use and maintenance of equipment.

CO6. Exhibit clear and concise communication of scientific data.


Objective of Course:

This course is an introduction to microbiology that provides a strong grounding in fundamental aspects of the basic biology of bacteria and to familiarize the student with emerging field of biotechnology i.e. Recombinant DNA Technology as well as to create understanding and expertise in wet lab techniques in genetic engineering.

Course Outcomes:

On completion of the course the student will be able to:

CO1- Master aseptic techniques and be able to perform routine culture handling tasks safely and effectively.

CO2- Know the various Physical and Chemical growth requirements of bacteria and get equipped with various methods of bacterial growth measurement.

CO3- Learn the essential concepts of virology which include the structure of different viruses, properties, replication, types of infection, how viruses cause disease, immune response to infection

CO4- Explain briefly how the PCR mechanism works

CO5- Discuss the practical aspects of applying recombinant DNA technology.

CO6- Explain the significance of model organisms in recombinant DNA technology.