Subject Code & Name: DBMS
Academic Year: 2012 -2013 Branch / Year/ Semester: IV B.Tech(II sem) A/S Faculty Name: L.Narendra
COURSE DESCRIPTION:
Database, DBMS, Data Abstraction, Instances and Schemas, Data Models,
data definition, Manipulation languages, and conversion among these models;
relational database design theory, Introduction to SQL, Normalization,
Transaction Management and Recovery, Storage Managers
COURSE OBJECTIVES
The following are the major objectives of this course:
1. define a Database Management System
2. give a description of the Database Management structure
3. learn about database design concepts
4. define basic foundational terms of Database
5. understand the applications of Databases
6. know the advantages and disadvantages of the different models
7. compare relational model with the Structured Query Language (SQL)
8. Know the constraints and controversies associated with relational
database .
9. know the rules guiding transaction ACID
10. identify the major types of relational management systems
11. compare and contrast the types of RDBMS based on several criteria
12. understand the concept of data planning and Database design
13. know the steps in the development of Databases
14. trace the history and development process of SQL
15. know the scope and extension of SQL
16. identify the various functions of Database Administrator
17. Identify various Storage Structures of Database.
18. Understand the concept of Normalization and Normal Forms
COURSE OUTCOMES
1. Master the basic concepts and appreciate the applications of database systems.
2. Master the basics of SQL and construct queries using SQL.
3. Be familiar with a commercial relational database system (Oracle) by writing
SQL using the system.
4. Be familiar with the relational database theory, and be able to write relational
algebra expressions for queries.
5. Mater sound design principles for logical design of databases, including the E‐
R method and normalization approach.
6. Be familiar with the basic issues of transaction processing and Recovery.
7.Be familiar with basic database storage structures and access techniques: file
and page organizations, indexing methods including B‐tree, and hashing.
Objective Type Questions
1. What is database?
2. What is DBMS?
3. What is a Database system?
4. What are the advantages of DBMS?
5. What are the disadvantages in File Processing System?
6. Describe the three levels of data abstraction?
7. What is Data Independence?
8. What is Data Model?
9. What is E-R model?
10. What is Object Oriented model?
11. What is Relational Model?
12. What is an Entity? What is an Entity type? What is an Entity set?
13. What is an attribute?
14. What is DDL and DML?
15. What is DML Compiler?
16. What is Query evaluation engine?
17. What is DDL Interpreter?
18. Define Database users and Database Administrator
19. Define Storage Manager? components of storage manager
20. Define Transaction Management?
21. Define Query Processor?
LESSON PLAN
Subject Code & Name: DBMS
Academic Year: 2012 -2013 Branch / Year/ Semester: IV B.Tech(II sem) A/S Faculty Name: L.Narendra
Course Objectives
: The objective of this course is to expose the student to the basic concepts involved in designing and building a database management system
This course introduces students to concepts in database design and analysis
This course will focus on the relational model and will cover logical design of databases (schema design), physical implementation and file structures, and will provide an introduction to transaction processing systems.
S.No.
Dates Topics to be covered Unit No.
Teaching Method/
Aid
R Remarks
1 20/11/12 Introduction about syllabus BB
2 21/11/12 Data base System Applications 1 BB
3 22/11/12 DBS vs File system 1 BB
4 22/11/12 View of Data Data Abstraction, Instances and Schemas
1 BB
5 23/11/12 Data Models-ER Model,
Relational Model, Other Models
1 BB
6 27/11/12 Database Languages-DDL-DML 1 BB 7 28/11/12 Data base Access From
Application Programs, Data base users and Administration
1 BB
8 29/11/12 Transaction Management, DBS Structure
1 BB
9 29/11/12 Storage Manager, Query Processor 1 BB 10 30/11/12 History of Database Systems,
Database Design & ER Diagrams
1 BB
11 04/12/12 Beyond ER Diagrams, Entities, Attributes, Entity Sets
1 BB
12 05/12/12 Relationships and relationship sets 1 BB 13 06/12/12 Additional features of ER Models 1 BB 14 06/12/12 Conceptual Design with the ER
Models and Large enterprises
1 BB
15 07/12/12 Tutorial 1 BB
16 11/12/12 Introduction to Relational Model 2 BB
17 12/12/12 Integrity Constraints over Relations
2 BB
18 13/12/12 Enforcing Integrity Constraints, Querying relational data
2 BB
19 13/12/12 Logical database design 2 BB
20 14/12/12 Logical database design 2 BB
21 18/12/12 Introduction to views/Destroying /altering tables and views
2 BB
22 19/12/12 Relational algebra-selection and projection operators
2 BB
22 20/12/12 Joins-renaming-divisions 2 BB
23 20/12/12 Relational Calculus-Tuple relational Calculus
2 BB
24 21/12/12 Domain relational Calculus- Expressive Power of Algebra and Calculus
2 BB
25 26/12/12 Tutorial 2 BB
26 27/12/12 Form of basic SQL Query 3 BB
27 27/12/12 Examples of SQL Queries 3 BB 28 28/12/12 Nested Queries-Correlated Nested
Queries
3 BB
29 01/01/13 Aggregative Operators, set comparative operators
3 BB
30 02/01/13 Null Values Logical
Connectivity’s -AND-OR-NOT
3 BB
31 03/01/13 Impact on SQL Constructs-outer joins-disallowing NULL Values
3 BB
32 03/01/13 Complex integrity constraints in SQL ,Triggers and Active Databases
3 BB
33 04/01/13 Tutorial 3 BB
34 08/01/13 Introduction To Schema Refinement
4 BB
35 09/01/13 Decomposition, problems related to Decomposition
4 BB
36 10/01/13 Reasoning About FDS 4 BB
37 10/01/13 Normalization, Normal Forms, First-Second Normal Forms
4 BB
38 11/01/13 Third Normal Form-BCNF 4 BB
39 15/01/13 Lossless join Decomposition 4 BB 40 16/01/13 Dependency Preserving
Decompositions
4 BB
41 17/01/13 Schema refinement in database design
4 BB
42 17/01/13 Multi valued Dependencies,4th
&5th normal form
4 BB
43 18/01/13 Tutorial 4 BB
44 29/01/13 ACID properties 5 BB
45 30/01/13 Transactions and schedules 5 BB
46 31/01/13 Concurrent execution of transaction
5 BB
47 31/01/13 Lock based concurrency control 5 BB
48 01/02/13 Performance locking 5 BB
49 05/02/13 Transaction support in SQL 5 BB 50 06/02/13 Introduction to crash recovery 5 BB
51 07/02/13 Tutorial 5 BB
52 07/02/13 Serializability and recoverability 6 BB 53 08/02/13 Introduction to lock management 6 BB 54 12/02/13 Lock conversions,dead locks 6 BB 55 13/02/13 Specialized locking techniques 6 BB 56 14/02/13 Concurrency without locking 6 BB 57 14/02/13 Introduction to ARIES-log 6 BB 58 15/02/13 Other recovery related structures 6 BB 59 19/02/13 The write-Ahead log protocols,
Check pointing
6 BB
60 20/02/13 Recovering from a system crash 6 BB 61 21/02/13 Media recovery,other approaches
and interaction with concurrency control
6 BB
62 21/02/13 Tutorial 6 BB
63 22/02/13 Data on external storage, file organization and indexing
7 BB
64 26/02/13 Index data structures 7 BB
65 27/02/13 Index data structures 7 BB
66 28/02/13 Comparison of file organizations 7 BB 67 28/02/13 Comparison of file organizations 7 BB 68 01/03/13 Indexes and performance tuning 7 BB
69 05/03/13 Tutorial 7 BB
70 06/03/13 The memory hierarchy 8 BB
71 07/03/13 Redundant Arrays of independent 8 BB
72 07/03/13 Disk space management 8 BB
73 08/03/13 Buffer management 8 BB
74 12/03/13 File of records 8 BB
75 13/03/13 Page formats,Record formats 8 BB 76 14/03/13 Intuitions for tree indexes 8 BB
77 14/03/13 ISAM 8 BB
78 15/03/13 B+ Trees 8 BB
79 19/03/13 Static hashing 8 BB
80 20/03/13 Extendable hashing 8 BB
81 21/03/13 Linear hashing 8 BB
82 21/03/13 Extendable vs linear hashing 8 BB
83 22/03/13 Tutorial 8 BB
Signature Prepared Date:
Signature of HOD Date:
LESSON PLAN
Subject Code & Name: DBMS
Academic Year: 2012 -2013 Branch / Year/ Semester: IV B.Tech(II sem) B/S Faculty Name: L.Narendra
Course Objectives
: The objective of this course is to expose the student to the basic concepts involved in designing and building a database management system
This course introduces students to concepts in database design and analysis
This course will focus on the relational model and will cover logical design of databases (schema design), physical implementation and file structures, and will provide an introduction to transaction processing systems.
S.No.
Dates Topics to be covered Unit No.
Teaching Method/
Aid
R Remarks
1 19/11/12 Introduction about syllabus BB
2 19/11/12 Data base System Applications 1 BB
3 20/11/12 DBS vs File system 1 BB
4 21/11/12 View of Data Data Abstraction, Instances and Schemas
1 BB
5 23/11/12 Data Models-ER Model,
Relational Model, Other Models
1 BB
6 26/11/12 Database Languages-DDL-DML 1 BB 7 26/11/12 Data base Access From
Application Programs, Data base users and Administration
1 BB
8 27/11/12 Transaction Management, DBS Structure
1 BB
9 28/11/12 Storage Manager, Query Processor 1 BB 10 30/11/12 History of Database Systems,
Database Design & ER Diagrams
1 BB
11 03/12/12 Beyond ER Diagrams, Entities, Attributes, Entity Sets
1 BB
12 03/12/12 Relationships and relationship sets 1 BB 13 04/12/12 Additional features of ER Models 1 BB 14 05/12/12 Conceptual Design with the ER
Models and Large enterprises
1 BB
15 07/12/12 Tutorial 1 BB
16 10/12/12 Introduction to Relational Model 2 BB
17 10/12/12 Integrity Constraints over Relations
2 BB
18 11/12/12 Enforcing Integrity Constraints, Querying relational data
2 BB
19 12/12/12 Logical database design 2 BB
20 14/12/12 Logical database design 2 BB
21 17/12/12 Introduction to views/Destroying /altering tables and views
2 BB
22 17/12/12 Relational algebra-selection and projection operators
2 BB
22 18/12/12 Joins-renaming-divisions 2 BB
23 19/12/12 Relational Calculus-Tuple relational Calculus
2 BB
24 21/12/12 Domain relational Calculus- Expressive Power of Algebra and Calculus
2 BB
25 24/12/12 Tutorial 2 BB
26 24/12/12 Form of basic SQL Query 3 BB
27 26/12/12 Examples of SQL Queries 3 BB 28 28/12/12 Nested Queries-Correlated Nested
Queries
3 BB
29 31/12/12 Aggregative Operators, set comparative operators
3 BB
30 31/12/12 Null Values Logical
Connectivity’s -AND-OR-NOT
3 BB
31 01/01/13 Impact on SQL Constructs-outer joins-disallowing NULL Values
3 BB
32 02/01/13 Complex integrity constraints in SQL ,Triggers and Active Databases
3 BB
33 04/01/13 Tutorial 3 BB
34 07/01/13 Introduction To Schema Refinement
4 BB
35 07/01/13 Decomposition, problems related to Decomposition
4 BB
36 08/01/13 Reasoning About FDS 4 BB
37 09/01/13 Normalization, Normal Forms, First-Second Normal Forms
4 BB
38 11/01/13 Third Normal Form-BCNF 4 BB
39 14/01/13 Lossless join Decomposition 4 BB 40 14/01/13 Dependency Preserving
Decompositions
4 BB
41 15/01/13 Schema refinement in database design
4 BB
42 16/01/13 Multi valued Dependencies,4th
&5th normal form
4 BB
43 18/01/13 Tutorial 4 BB
44 28/01/13 ACID properties 5 BB
45 28/01/13 Transactions and schedules 5 BB
46 29/01/13 Concurrent execution of transaction
5 BB
47 30/01/13 Lock based concurrency control 5 BB
48 01/02/13 Performance locking 5 BB
49 04/02/13 Transaction support in SQL 5 BB 50 04/02/13 Introduction to crash recovery 5 BB
51 05/02/13 Tutorial 5 BB
52 06/02/13 Serializability and recoverability 6 BB 53 08/02/13 Introduction to lock management 6 BB 54 11/02/13 Lock conversions,dead locks 6 BB 55 11/02/13 Specialized locking techniques 6 BB 56 12/02/13 Concurrency without locking 6 BB 57 13/02/13 Introduction to ARIES-log 6 BB 58 15/02/13 Other recovery related structures 6 BB 59 18/02/13 The write-Ahead log protocols,
Check pointing
6 BB
60 18/02/13 Recovering from a system crash 6 BB 61 19/02/13 Media recovery,other approaches
and interaction with concurrency control
6 BB
62 20/02/13 Tutorial 6 BB
63 22/02/13 Data on external storage, file organization and indexing
7 BB
64 25/02/13 Index data structures 7 BB
65 25/02/13 Index data structures 7 BB
66 26/02/13 Comparison of file organizations 7 BB 67 27/02/13 Comparison of file organizations 7 BB 68 01/03/13 Indexes and performance tuning 7 BB
69 04/03/13 Tutorial 7 BB
70 04/03/13 The memory hierarchy 8 BB
71 05/03/13 Redundant Arrays of independent 8 BB
72 06/03/13 Disk space management 8 BB
73 08/03/13 Buffer management 8 BB
74 11/03/13 File of records 8 BB
75 11/03/13 Page formats,Record formats 8 BB 76 12/03/13 Intuitions for tree indexes 8 BB
77 13/03/13 ISAM 8 BB
78 15/03/13 B+ Trees 8 BB
79 18/03/13 Static hashing 8 BB
80 18/03/13 Extendable hashing 8 BB
81 19/03/13 Linear hashing 8 BB
82 20/03/13 Extendable vs linear hashing 8 BB
83 22/03/13 Tutorial 8 BB
Signature Prepared Date:
Signature of HOD Date:
Course Objective(CO) Department: Electrical Engineering
Course : IV B.Tech II Sem (A.Y:2012-13) Course Name: Digital Control Systems
Objective 1) Knowledge about principles and techniques of A/D and D/A conversions and basics of Ztransform
Objective 2) Knowledge in stability analysis of digital control systems
Objective 3) Knowledge about the design of digital control systems for different engineering model
Objective 4) Knowledge about the State space Modelling and analysis of Digital Control Systems
Objective 5) Knowledge about the designing of state feedback controller
Objective 6) Knowledge about the designing of state estimator and Observer
Objective 7) Knowledge about the stability analysis of DCS
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING
(AUTONOMOUS)Approved by AICTE, NBA Accredited, ISO 9001:2008 Certified, Affiliated to JNTUK L.B.REDDY NAGAR, MYLAVARAM-521 230,KRISHNA Dist. A.P
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
Phone: 08659-222933/extn:203 [email protected]
Subject:Digital Control Systems Faculty Name:Mr.K.R.L.Prasad Branch:EEEA
A.Y:2012-13
S.No Date Day Topic
1 30-Nov-2012 Friday Introduction(I-Unit)
2 3-Dec-2012 Monday Examples of Data control systems 3 3-Dec-2012 Monday Examples of Data control systems 4 5-Dec-2012 Wednesday Digital to Analog conversion 5 6-Dec-2012 Thursday Digital to Analog conversion 6 7-Dec-2012 Friday Tutorial-1
7 10-Dec-2012 Monday Analog to Digital conversion 8 10-Dec-2012 Monday Analog to Digital conversion 9 12-Dec-2012 Wednesday Analog to Digital conversion 10 13-Dec-2012 Thursday sample and hold operations 11 14-Dec-2012 Friday Tutorial -2
12 17-Dec-2012 Monday UNIT-II THE Z – TRANSFORMS 13 17-Dec-2012 Monday Z – transforms
14 19-Dec-2012 Wednesday Theorems of Z – Transforms 15 20-Dec-2012 Thursday Theorems of Z – Transforms 16 21-Dec-2012 Friday Tutorial-3
17 24-Dec-2012 Monday The inverse Z – transforms 18 24-Dec-2012 Monday The inverse Z – transforms 19 26-Dec-2012 Wednesday Numarical Problems 20 27-Dec-2012 Thursday Modofied Z-Transforms 21 28-Dec-2012 Friday Tutorial-4
22 31-Dec-2012 Monday UNIT-III Z-Plane Analysis 23 31-Dec-2012 Monday solving difference equations 24 2-Jan-2013 Wednesday block diagram analysis
25 3-Jan-2013 Thursday mapping between s-plane and z-plane 26 4-Jan-2013 Friday Tutorial-5
27 7-Jan-2013 Monday UNIT-IV
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING
Approved by AICTE, NBA Accredited, ISO 9001:2008 Certified, Affiliated to JNTUK L.B.REDDY NAGAR, MYLAVARAM-521 230,KRISHNA Dist. A.P
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
Phone: 08659-222933/extn:203 [email protected]
28 7-Jan-2013 Monday State Space Representation 29 9-Jan-2013 Wednesday State transition matrix
30 10-Jan-2013 Thursday Discretization of continuous SS equations 31 11-Jan-2013 Friday Tutorial-6
32 28-Jan-2013 Monday UNIT – V
33 28-Jan-2013 Monday Concepts of Controllability and Observability 34 30-Jan-2013 Wednesday Tests for controllability and Observability 35 31-Jan-2013 Thursday Duality between Controllability and Observability 36 1-Feb-2013 Friday Tutorial-7
37 4-Feb-2013 Monday Controllability 38 4-Feb-2013 Monday Controllability 39 6-Feb-2013 Wednesday Observability 40 7-Feb-2013 Thursday Observability 41 8-Feb-2013 Friday Tutorial-8
42 11-Feb-2013 Monday Mapping between the S-Plane and the Z-Plane 43 11-Feb-2013 Monday Primary strips and Complementary Strips 44 13-Feb-2013 Wednesday Constant frequency loci
45 14-Feb-2013 Thursday Constant damping ratio loci, 46 15-Feb-2013 Friday Tutorial-9
47 18-Feb-2013 Monday Stability Analysis of closed loop systems 48 18-Feb-2013 Monday Jury stablility test
49 20-Feb-2013 Wednesday Stability Analysis by use of the Bilinear Transformation 50 21-Feb-2013 Thursday Routh Stability criterion
51 22-Feb-2013 Friday Tutorial-10
52 25-Feb-2013 Monday UNIT – VII Transient and steady – State response Analysis 53 25-Feb-2013 Monday Design procedure in the w-plane, Lead, Lag
54 27-Feb-2013 Wednesday Lead-Lag compensators 55 28-Feb-2013 Thursday PID controllers
56 1-Mar-2013 Friday Tutorial-11
57 4-Mar-2013 Monday digital PID controllers 58 4-Mar-2013 Monday digital PID controllers
59 6-Mar-2013 Wednesday UNIT – VIII Design of state feedback controller 60 7-Mar-2013 Thursday Necessary and sufficient conditions,
61 8-Mar-2013 Friday Tutorial-12
62 11-Mar-2013 Monday Necessary and sufficient conditions, 63 11-Mar-2013 Monday Ackerman’s formula.State Observers 64 13-Mar-2013 Wednesday Ackerman’s formula.State Observers 65 14-Mar-2013 Thursday Full order and Reduced order observers 66 15-Mar-2013 Friday Tutorial-13
67 18-Mar-2013 Monday Full order and Reduced order observers 68 18-Mar-2013 Monday Revision
69 20-Mar-2013 Wednesday Revision 70 21-Mar-2013 Thursday Revision 71 22-Mar-2013 Friday Revision
Signature of the Faculty
Subject:Digital Control Systems Faculty Name:Mr.K.R.L.Prasad Branch:EEEB
A.Y:2012-13
S.No Date Day Topic
1 30-Nov-2012 Friday Introduction(I-Unit)
2 30-Nov-2012 Friday Examples of Data control systems 3 3-Dec-2012 Monday Examples of Data control systems 4 4-Dec-2012 Tuesday Digital to Analog conversion 5 6-Dec-2012 Thursday Digital to Analog conversion 6 7-Dec-2012 Friday Tutorial-1
7 7-Dec-2012 Friday Analog to Digital conversion 8 10-Dec-2012 Monday Analog to Digital conversion 9 11-Dec-2012 Tuesday Analog to Digital conversion 10 13-Dec-2012 Thursday Tutorial -2
11 14-Dec-2012 Friday sample and hold operations 12 14-Dec-2012 Friday UNIT-II THE Z – TRANSFORMS 13 17-Dec-2012 Monday Z – transforms
14 18-Dec-2012 Tuesday Theorems of Z – Transforms 15 20-Dec-2012 Thursday Theorems of Z – Transforms 16 21-Dec-2012 Friday Tutorial-3
17 21-Dec-2012 Friday The inverse Z – transforms 18 24-Dec-2012 Monday The inverse Z – transforms 19 27-Dec-2012 Thursday Numarical Problems 20 28-Dec-2012 Friday Modofied Z-Transforms 21 28-Dec-2012 Friday Tutorial-4
22 31-Dec-2012 Monday UNIT-III Z-Plane Analysis 23 3-Jan-2013 Thursday solving difference equations 24 4-Jan-2013 Friday block diagram analysis
25 4-Jan-2013 Friday mapping between s-plane and z-plane 26 7-Jan-2013 Monday Tutorial-5
27 8-Jan-2013 Tuesday UNIT-IV
28 10-Jan-2013 Thursday State Space Representation 29 11-Jan-2013 Friday State transition matrix
30 11-Jan-2013 Friday Discretization of continuous SS equations 31 28-Jan-2013 Monday Tutorial-6
32 29-Jan-2013 Tuesday UNIT – V
33 31-Jan-2013 Thursday Concepts of Controllability and Observability 34 1-Feb-2013 Friday Tests for controllability and Observability 35 1-Feb-2013 Friday Duality between Controllability and Observability 36 4-Feb-2013 Monday Tutorial-7
37 5-Feb-2013 Tuesday Controllability 38 7-Feb-2013 Thursday Controllability 39 8-Feb-2013 Friday Observability 40 8-Feb-2013 Friday Observability 41 11-Feb-2013 Monday Tutorial-8
42 12-Feb-2013 Tuesday Mapping between the S-Plane and the Z-Plane 43 14-Feb-2013 Thursday Primary strips and Complementary Strips 44 15-Feb-2013 Friday Constant frequency loci
45 15-Feb-2013 Friday Constant damping ratio loci, 46 18-Feb-2013 Monday Tutorial-9
47 19-Feb-2013 Tuesday Stability Analysis of closed loop systems
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING
Approved by AICTE, NBA Accredited, ISO 9001:2008 Certified, Affiliated to JNTUK L.B.REDDY NAGAR, MYLAVARAM-521 230,KRISHNA Dist. A.P
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
Phone: 08659-222933/extn:203 [email protected]
48 21-Feb-2013 Thursday Jury stablility test
49 22-Feb-2013 Friday Stability Analysis by use of the Bilinear Transformation 50 22-Feb-2013 Friday Routh Stability criterion
51 25-Feb-2013 Monday Tutorial-10
52 26-Feb-2013 Tuesday UNIT – VII Transient and steady – State response Analysis 53 28-Feb-2013 Thursday Design procedure in the w-plane, Lead, Lag
54 1-Mar-2013 Friday Lead-Lag compensators 55 1-Mar-2013 Friday PID controllers
56 4-Mar-2013 Monday Tutorial-11
57 5-Mar-2013 Tuesday digital PID controllers 58 7-Mar-2013 Thursday digital PID controllers
59 8-Mar-2013 Friday UNIT – VIII Design of state feedback controller 60 8-Mar-2013 Friday Necessary and sufficient conditions,
61 11-Mar-2013 Monday Tutorial-12
62 12-Mar-2013 Tuesday Necessary and sufficient conditions, 63 14-Mar-2013 Thursday Ackerman’s formula.State Observers 64 15-Mar-2013 Friday Ackerman’s formula.State Observers 65 15-Mar-2013 Friday Full order and Reduced order observers 66 18-Mar-2013 Monday Full order and Reduced order observers 67 19-Mar-2013 Tuesday Tutorial-13
68 21-Mar-2013 Thursday Revision 69 22-Mar-2013 Friday Revision 70 22-Mar-2013 Friday Revision
Signature of the Faculty
Course: IV B.TECH. (II Semester) Subject: Utilization of Electrical Energy, A.Y:
2012-13
COURSE EDUCATIONAL OBJECTIVE(S)
This subject assumes importance in view of the fact that a technician has to work in a wide spectrum of activities wherein he has to make collections from alternative schemes from technical and economical considerations; i.e. to plan and design using basic principles and handbooks, to select equipment, processes and components in different situations.
The curriculum has been designed keeping the above objectives in view.
Besides giving him basic knowledge in the topics concerned, attempts have been made to ensure that the knowledge acquired is applied in various fields as per his job requirements. To orient the subject matter in the proper direction, visits to industrial establishments are recommended in order to familiarize the students with the new developments in different areas.
HOD/EEE Sig nature of the faculty
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING
(AUTONOMOUS)Approved by AICTE, NBA Accredited, ISO 9001:2008 Certified, Affiliated to JNTUK L.B.REDDY NAGAR, MYLAVARAM-521 230,KRISHNA Dist. A.P
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
Phone: 08659-222933/extn:203 [email protected]
Course: IV B.TECH. (II Semester) Subject: Utilization of Electrical Energy, A.Y: 2012-13 Section : A
Faculty Name: J V Pavan Chand
S.No Date Week Topic Remarks
1 30-Nov-12 Fri UNIT – I: Drives introduction 2 3-Dec-12 Mon Factors affecting the choice of motor
3 04-Dec- 12 Tues DC separately motor characteristics and speed control 4 5-Dec-12 Wed DC series motor characteristics and speed control 5 6-Dec-12 Thurs DC motor braking characteristics
6 07-Dec-12 Fri Tutorial- I 7 10-Dec-12 Mon
AC motor, Induction motor characteristics and speed control
8 11-Dec-12 Tues
Induction motor speed control Problems on induction motor 9 12-Dec-12 Wed
Temperature rise in a machine, Problems on temperature rise
10 13-Dec-12 Thurs
Particular application of drives, types of industrial loads
12 14-Dec-12 Fri Tutorial- II 13 17-Dec-12 Mon
Continues, intermittent and variable loads, Load equivalization
13 18-Dec-12 Tues
Continues, intermittent and variable loads, Load equivalization
14 19-Dec-12 Wed UNIT –II: Advantages of Electric Heating 15 20-Dec-12 Thurs Methods of electric heating
16 21-Dec-12 Fri Resistance heating
17 24-Dec-12 Mon Induction heating , Problems on Induction heating 18 26-Dec-12 Wed Dielectric heating
19 27-Dec-12 Thurs Numerical problems 20 28-Dec-12 Fri Tutorial- III 21 31-Dec-12 Mon Numerical problems 22 2-Jan-13 Wed
UNIT – III: Electric welding Resistance welding
23 3-Jan-13 Thurs Arc welding, Electric welding equipment 24 4-Jan-13 Fri Tutorial- IV
25 7-Jan-13 Mon Comparison between DC welding and AC welding 26 8-Jan-13 Tues Numerical problems
27 9-Jan-13 Wed Numerical problems 28 10-Jan-13 Thurs
UNIT – IV: Illumination Fundamentals- Illumination, Terms & definitions 29 11-Jan-13 Fri Laws of illumination , Polar curves 30 16-Jan-13 Wed Photometry
31 17-Jan-13 Thurs Integrating sphere 32 18-Jan-13 Fri Tutorial- V
33 24-Jan-13 Thurs Source of light , Numerical problems 34 28-Jan-13 Mon
UNIT – V: Various Illumination Methods- Discharge lamps
35 29-Jan-13 Tues MV lamps 36 30-Jan-13 Wed SV lamps
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING
(AUTONOMOUS)Approved by AICTE, NBA Accredited, ISO 9001:2008 Certified, Affiliated to JNTUK L.B.REDDY NAGAR, MYLAVARAM-521 230,KRISHNA Dist. A.P
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
Phone: 08659-222933/extn:203 [email protected]
37
31-Jan-13 Thurs
Comparison between tungsten filament lamps and fluorescent tubes
38 1-Feb-13 Fri Tutorial- VI
39 4-Feb-13 Mon Fluorescent tubes , Basic principle of light control 40 5-Feb-13 Tues Types and design of lighting
41 6-Feb-13 Wed Flood lighting 42 7-Feb-13 Thurs Numerical problems 43 8-Feb-13 Fri Tutorial- VII
44 11-Feb-13 Mon UNIT – VI: Electric Traction-I, Introduction 45 12-Feb-13 Tues Systems of electric traction , Track electrification 46 13-Feb-13 Wed Review of existing electric traction systems in India 47 14-Feb-13 THurs Special features of electric traction motor
48 15-Feb-13 Fri Tutorial- VIII 49 18-Feb-13 Mon
Numerical problems UNIT – VII: Electric Traction-II, Mechanics of train movement 50 19-Feb-13 Tues
UNIT – VII: Electric Traction-II, Mechanics of train movement , Numerical problems
51 20-Feb-13 Wed Speed time curves for different services 52 21-Feb-13 Thurs Numerical problems
53 22-Feb-13 Fri Tutorial- IX
54 25-Feb-13 Mon Speed time curves for different services, quadrilateral 55 26-Feb-13 Tues Speed time curves for different services, trapezoidal 56 27-Feb-13 Wed Numerical problems
57 28-Feb-13 Thurs
UNIT – VIII: Electric Traction-III, Calculation of tractive effort, power Numerical problems
58 1-Mar-13 Fri Tutorial- X 59 4-Mar-13 Mon Numerical problems
60 5-Mar-13 Tue Effect of varying acceleration and braking retardation 61 6-Mar-13 Wed Numerical problems
62 7-Mar-13 Thurs Adhesive weight, coefficient of adhesion 63 8-Mar-13 Fri Numerical problems
64 11-Mar-13 Mon Adhesive weight, braking retardation 65 12-Mar-13 Tue Numerical problems
66 13-Mar-13 Wed Numerical problems 67 14-Mar-13 Thurs Numerical problems 68 15-Mar-13 Fri Numerical problems 69 18-Mar-13 Mon Revision
70 19-Mar-13 Thu Revision 71 20-Mar-13 Wed Revision 72 21-Mar-13 Thurs Revision 73 22-Mar-13 Fri Revision
Signature of the faculty HOD/EEE
Course: IV B.TECH. (II Semester) Subject: Utilization of Electrical Energy, A.Y: 2012- 13
Section : B
Faculty Name: J V Pavan Chand
S.No Date Week Topic Remarks
1 30-Nov-12 Fri UNIT – I: Drives introduction 2 3-Dec-12 Mon Factors affecting the choice of motor
3 04-Dec- 12 Tues DC separately motor characteristics and speed control 4 5-Dec-12 Wed DC series motor characteristics and speed control 5 6-Dec-12 Thurs DC motor braking characteristics
6 07-Dec-12 Fri Tutorial- I 7 10-Dec-12 Mon
AC motor, Induction motor characteristics and speed control
8 11-Dec-12 Tues
Induction motor speed control Problems on induction motor 9 12-Dec-12 Wed
Temperature rise in a machine, Problems on temperature rise
10 13-Dec-12 Thurs
Particular application of drives, types of industrial loads
12 14-Dec-12 Fri Tutorial- II 13 17-Dec-12 Mon
Continues, intermittent and variable loads, Load equivalization
13 18-Dec-12 Tues
Continues, intermittent and variable loads, Load equivalization
14 19-Dec-12 Wed UNIT –II: Advantages of Electric Heating 15 20-Dec-12 Thurs Methods of electric heating
16 21-Dec-12 Fri Resistance heating
17 24-Dec-12 Mon Induction heating , Problems on Induction heating 18 26-Dec-12 Wed Dielectric heating
19 27-Dec-12 Thurs Numerical problems 20 28-Dec-12 Fri Tutorial- III 21 31-Dec-12 Mon Numerical problems 22 2-Jan-13 Wed
UNIT – III: Electric welding Resistance welding
23 3-Jan-13 Thurs Arc welding, Electric welding equipment 24 4-Jan-13 Fri Tutorial- IV
25 7-Jan-13 Mon Comparison between DC welding and AC welding 26 8-Jan-13 Tues Numerical problems
27 9-Jan-13 Wed Numerical problems 28 10-Jan-13 Thurs
UNIT – IV: Illumination Fundamentals- Illumination, Terms & definitions 29 11-Jan-13 Fri Laws of illumination , Polar curves 30 16-Jan-13 Wed Photometry
31 17-Jan-13 Thurs Integrating sphere 32 18-Jan-13 Fri Tutorial- V
33 24-Jan-13 Thurs Source of light , Numerical problems 34 28-Jan-13 Mon
UNIT – V: Various Illumination Methods- Discharge lamps
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING
(AUTONOMOUS)Approved by AICTE, NBA Accredited, ISO 9001:2008 Certified, Affiliated to JNTUK L.B.REDDY NAGAR, MYLAVARAM-521 230,KRISHNA Dist. A.P
DEPARTMENT OF ELECTRICAL & ELECTRONICS ENGINEERING
Phone: 08659-222933/extn:203 [email protected]
35 29-Jan-13 Tues MV lamps 36 30-Jan-13 Wed SV lamps
37
31-Jan-13 Thurs
Comparison between tungsten filament lamps and fluorescent tubes
38 1-Feb-13 Fri Tutorial- VI
39 4-Feb-13 Mon Fluorescent tubes , Basic principle of light control 40 5-Feb-13 Tues Types and design of lighting
41 6-Feb-13 Wed Flood lighting 42 7-Feb-13 Thurs Numerical problems 43 8-Feb-13 Fri Tutorial- VII
44 11-Feb-13 Mon UNIT – VI: Electric Traction-I, Introduction 45 12-Feb-13 Tues Systems of electric traction , Track electrification 46 13-Feb-13 Wed Review of existing electric traction systems in India 47 14-Feb-13 THurs Special features of electric traction motor
48 15-Feb-13 Fri Tutorial- VIII 49 18-Feb-13 Mon
Numerical problems UNIT – VII: Electric Traction-II, Mechanics of train movement 50 19-Feb-13 Tues
UNIT – VII: Electric Traction-II, Mechanics of train movement , Numerical problems
51 20-Feb-13 Wed Speed time curves for different services 52 21-Feb-13 Thurs Numerical problems
53 22-Feb-13 Fri Tutorial- IX
54 25-Feb-13 Mon Speed time curves for different services, quadrilateral 55 26-Feb-13 Tues Speed time curves for different services, trapezoidal 56 27-Feb-13 Wed Numerical problems
57 28-Feb-13 Thurs
UNIT – VIII: Electric Traction-III, Calculation of tractive effort, power Numerical problems
58 1-Mar-13 Fri Tutorial- X 59 4-Mar-13 Mon Numerical problems
60 5-Mar-13 Tue Effect of varying acceleration and braking retardation 61 6-Mar-13 Wed Numerical problems
62 7-Mar-13 Thurs Adhesive weight, coefficient of adhesion 63 8-Mar-13 Fri Numerical problems
64 11-Mar-13 Mon Adhesive weight, braking retardation 65 12-Mar-13 Tue Numerical problems
66 13-Mar-13 Wed Numerical problems 67 14-Mar-13 Thurs Numerical problems 68 15-Mar-13 Fri Numerical problems 69 18-Mar-13 Mon Revision
70 19-Mar-13 Thu Revision 71 20-Mar-13 Wed Revision 72 21-Mar-13 Thurs Revision 73 22-Mar-13 Fri Revision
Signature of the faculty HOD/EEE