lesson plan 27/01/2016 : database management systems …
TRANSCRIPT
LESSON PLAN Date:
27/01/2016
To 09/07/2016
Sub. Name : DATABASE MANAGEMENT SYSTEMS
Branch: IT Semester: IV
S180 - DATABASE MANAGEMENT SYSTEMS
Lecture : 4 Periods/week Internal Marks : 25
Tutorial : 1 External Marks : 75
Credits : 4 External Examination : 3 Hrs
--------------------------------------------------------------------------------------------------------------
UNIT - I
Introduction: An overview of database management system, database system Vs file system,
Database system concepts and architecture, data models schema and instances, data independence and
data base language and interfaces, Data definitions language, DML, Overall Database Structure.
Data modeling using the Entity Relationship Model: ER model concepts, notation for ER diagram,
mapping constraints, keys, Concepts of Super Key, candidate key, primary key, Generalization,
aggregation, reduction of an ER diagrams to tables, extended ER model, relationships of higher degree.
UNIT - II
Relational data Model and Language: Relational data model concepts, integrity constraints: entity
integrity, referential integrity, Keys constraints, Domain constraints, relational algebra.
Introduction to SQL: Characteristics of SQL, Advantage of SQL. SQL data types and literals. Types
of SQL commands.SQL operators and their procedure. Tables, views and indexes. Queries and sub
queries. Aggregate functions. Insert, update and delete operations. Joins, Unions, Intersection, Minus,
Cursors in SQL.
UNIT - III
Normalization: Functional dependencies, normal forms, first, second, third normal forms, BCNF,
inclusion dependences, loss less join decompositions, normalization using FD, MVD, and JDs,
alternative approaches to database design.
UNIT – IV
Transaction Processing Concepts: Transaction system, Testing of serializability, Serializability of
schedules, conflict & view serializable schedule, recoverability, log based recovery, checkpoints,
ARIES algorithm, deadlock handling. Concurrency Control Techniques: Concurrency control,
locking Techniques for concurrency control, Time stamping protocols for concurrency control,
validation based protocol, multiple granularity, Recovery with concurrent transactions.
UNIT-V
Storage and Indexing: RAID levels, page formats, record formats, file types and organization, ISAM,
B-tree, B+-tree.
TEXT BOOK
1. “Database Concepts”, Korth, Silbertz, Sudarshan, McGraw Hill.
2. “Fundamentals Of Database Systems”, Elmasri, Navathe, Addision Wesley.
REFERENCES
1. “Database Management System”, Raghu Ramakrishnan, McGraw Hill
2. “DBMS: Complete Practical Approach”, Maheshwari Jain, Firewall Media, New Delhi.
3. “An Introduction To Database System”, Date C J, Addision Wesley.
Prerequisite: Elementary set theory, concepts of relations and functions, propositional logic data
structures (trees, Graphs, dictionaries)& File Concepts.
Course Educational Objectives:
This course enables the students to know about
DBMS basic concepts, Database Languages.
Data base Design.
Normalization process and Transaction processing.
Indexing.
Course Outcomes: After the completion of the course, students should be able to
CO1: Understand Database concepts, architecture, Data base languages, Data models and design of
database.
CO2: Understand the concepts of relational data models, different constraints and apply SQL
operations to retrieve data from the database.
CO3: Apply the normalization process for designed data base.
CO4:Understand the issues in transaction processing and analyze different Concurrency and recovery
strategies of DBMS
CO5: Analyze different file organization techniques & Indexing Techniques.
Lakireddy Bali Reddy College of Engineering
Department of IT
Outcome based lesson plan
Academic year: 2015-16 Course: Database Management systems
Programme: B.Tech Unit No: 1 to 5
Year & Sem: II & II (IV sem) Section: A
S.No Teaching Learning Process (TLP) Delivery Methods (DM) Assessment Methods (AM)
1 Solving Real world problem Chalk & Talk Assignments
2 Explaining application before theory ICT tools Quiz
3 Solving problems Group discussions Tutorials
4 Designing of experiments Industrial visit Surprise Tests
5 Problems on environmental, economics,
health & safety Field work Mid Exams
6 Problems on professional & ethics Case studies Model Exam
7 Seminar Mini Projects QAs
8 Problems using software Numerical treatment
9 Self study Design / Exercises
Detailed Lesson Plan
S.NO TOPIC TO BE COVERED Date
TLP DM AM Tentative Actual
UNIT –I: Introduction & Data modeling using the Entity Relationship Model
1 Introduction 28/01/2016 2 1
1,3,5,7
2
An overview of database
management system 29/01/2016 2 1
3 database system Vs file system 30/01/2016 2 1
4
Database system concepts and
architecture 1/02/2016 2 1
5 data models schema and instances 3/02/2016 2 1
6
data independence and data base
language and interfaces 4/02/2016 2 1
7 Data definitions language, DML 5/02/2016 2 1
8 Overall Database Structure 6/02/2016 2 1,2
9
ER model concepts- notation for ER
diagram 8/02/2016 2 1
10 mapping constraints, keys 10/02/2016 2 1,9
11
Concepts of Super Key, candidate
key, primary key 11/02/2016 2 1,9
12 Generalization, aggregation 12/02/2016 2 1,9
13
reduction of an ER diagrams to
tables 13/02/2016 2 1,9
14 extended ER model 15/02/2016 2 1,9
15 relationships of higher degree 17/02/2016 2 1,9
16 Tutorial – I 18/02/2016
UNIT –II: Relational data Model and Language & Introduction to SQL
17 Relational data model concepts 19/02/2016 2 1
1,3,5,7
18
integrity constraints: entity integrity,
referential integrity 20/02/2016 2 1,9
19 Keys constraints, Domain constraints 22/02/2016 2 1,9
20 relational algebra 24/02/2016 2 1,9
21
Characteristics of SQL, Advantage
of SQL 25/02/2016 2 1
22 SQL data types and literals 26/02/2016 2 1
23 Types of SQL commands 27/02/2016 2 1,9
24 SQL operators and their procedure 29/02/2016 2 1,9
25 Tables, views and indexes 02/03/2016 2 1,9
26 Queries and sub queries 03/03/2016 2 1,9
27 Queries and sub queries 04/03/2016
28 Joins 05/03/2016
29 Joins 09/03/2016
30 Aggregate functions 10/03/2016 2 1,9
31 Insert, update and delete operations 11/03/2016 2 1,9
32 Unions, Intersection, Minus 14/03/2016 2 1,9
33 Cursors in SQL 16/03/2016 2 1,9
34 Tutorial – II 17/03/2016
35
MID – I EXAMS
18/03/2016
36 19/03/2016
37 21/03/2016
38 24/03/2016
39 26/03/2016
UNIT –III: Normalization
37 Functional dependencies 28/03/2016 2 1
1,3,5,7 38 normal forms: first, second 30/03/2016 2 1,9
39 third normal forms 31/03/2016 2 1,9
40 BCNF 01/04/2016 2 1,9
41 inclusion dependences 04/04/2016 2 1,9
42 loss less join decompositions 31/03/2016 2 1,9
43 Tutorial – III 01/04/2016
44 normalization using FD 02/04/2016 2 1,9
45 normalization using MVD 04/04/2016 2 1,9
46 normalization using JD 06/04/2016 2 1,9
47
alternative approaches to database
design 07/04/2016 2 1,9
48
alternative approaches to database
design 11/04/2016 2 1,9
49 Tutorial – IV 13/04/2016
UNIT –IV: Transaction Processing Concepts & Concurrency Control Techniques
50 Transaction system 14/04/2016 2 1
1,3,5,7
51 Testing of serializability 15/04/2016 2 1
52 Serializability of schedules 16/04/2016 2 1
53
conflict & view serializable
schedule 18/04/2016 2 1
54 recoverability, log based recovery 20/04/2016 2 1
55 Checkpoints 21/04/2016 2 1
56 ARIES algorithm 22/04/2016 2 1
57 deadlock handling 23/04/2016 2 1
58 Tutorial –V 25/04/2016
59 Concurrency control 27/04/2016 2 1
60 Techniques for concurrency control 28/04/2016 2 1
61
Time stamping protocols for
concurrency control 29/04/2016 2 1
62 Locking 30/04/2016 2 1
63 validation based protocol 02/05/2016 2 1
64 multiple granularity 04/05/2016 2 1
65
Recovery with concurrent
transactions 05/05/2016 2 1
UNIT-V: Storage and Indexing
66 RAID levels 06/05/2016 2 1
1,3,5,7
67 RAID levels 07/05/2016 2 1
68 page formats 09/05/2016 2 1
69 record formats 11/05/2016 2 1
70 file types and organization 12/05/2016 2 1
71 file types and organization 30/05/2016 2 1
72 ISAM 01/06/2016 2 1
73 B-tree 02/06/2016 2 1
74 B+-tree. 03/06/2015 2 1
75 B+-tree. 04/06/2016 2 1
76 Tutorial – VI 06/06/2016
77
II MID EXAMS
09/06/2016
78 10/06/2016
79 13/06/2016
80 14/062016
81 15/06/2016
Resources Used:
TEXT BOOKS
1. “Database Concepts”, Korth, Silbertz, Sudarshan, McGraw Hill.
2. “Fundamentals Of Database Systems”, Elmasri, Navathe, Addision Wesley.
REFERENCES
1. “Database Management System”, Raghu Ramakrishnan, McGraw Hill
2. “DBMS: Complete Practical Approach”, Maheshwari Jain, Firewall Media, New Delhi.
3. “An Introduction To Database System”, Date C J, Addision Wesley.
Assessment Summary:
Assessment Task Weight age
(Marks)
Course Outcomes
CO1 CO2 CO3 CO4 CO5
Assignments --
Quizzes --
Tutorials --
Surprise Tests --
Mid Exams 20
Model Exams --
End Exam 75
Attendance 05
Total 100
Mapping Course Outcomes with Programme Outcomes:
Course
Code
Unit Course Outcomes Programme Outcomes
1 2 3 4 5 1 2 3 4 5 6 7 8 9 10 11 12
T141
I × × ×
II × × × ×
III × × × ×
IV × × ×
V × × ×
Instructor Course
Coordinator
Module Coordinator HOD
Name M.Mahesh
Kumar
Dr. D.Naga Raju
Sign with Date
T254 – MICROPROCESSORS AND INTERFACING
Lecture : 4 Periods/week Internal Marks : 25
Tutorial : 1 Period/Week External Marks : 75
Credits : 4 External Examination : 3 Hrs
LESSON PLAN-MICROPROCESSORS AND INTERFACING
S No. Tentativ
e Date
Topics to be covered Actual
Date
Num.
of
classes
Content
Delivery
Methods
UNIT – I
1. 24-06-15 Architecture of 8086 Microprocessor 1 DM4
2.
26-06-15
Special functions of General purpose
registers
1 DM1,DM2
3.
27-06-15
8086 flag register and function of
8086 Flags
1 DM1
4. 29-06-15 Addressing modes of 8086, 2 DM1, DM4
5. 01-07-15 Instruction set of 8086. 3 DM1
6. 03-07-15 Tutorial-I DM2
7.
06-07-15
Assembler directives, simple
programs, procedures, and macros
2 DM1,DM2
8.
08-07-15
Assembly language programs
involving logical, Branch & Call
instructions,
3 DM1,DM4
9.
09-07-15
Sorting, evaluation of arithmetic
expressions, string manipulation.
2 DM1
10. 10
10-07-15 Tutorial-II DM2
UNIT – II
11. 11-07-15 Pin diagram of 8086 2 DM1
12. 15-07-15
Minimum mode and maximum mode
of operation,
2 DM1,DM4
13. 17-07-15 Tutorial-III DM2
14. 20-07-15
Timing diagram, Memory interfacing
to 8086 (Static RAM & EPROM)
3 DM1,DM4
15. 24-07-15
Need for DMA. DMA data transfer
Method,
3 DM1,DM4
16. 26-07-15 Tutorial-IV DM2
17. 29-07-15
Interfacing with 8237/8257.
2 DM1,DM4
UNIT – III
18. 31-07-15
8255 PPI – various modes of operation
and interfacing to 8086
2 DM1,DM4
19. 03-08-15 Interfacing Keyboard 2 DM1
20. 04-08-15 Tutorial-V DM2
21. 05-08-15 Displays 2 DM1,DM4
22. 07-08-15 8279 2 DM1
23. 10-08-
2015 to
16-08-
2015
I-Mid Examinations
24. 18-08-15 Stepper Motor and actuators 2 DM1,DM4
25. 19-08-15 Tutorial-VI DM2
26. 20-08-15
D/A and A/D converter interfacing
2 DM1,DM4
UNIT-IV
27. 22-08-15
Interrupt structure of 8086.
1 DM1
28. 24-08-15
Vector interrupt table. Interrupt service
routines
2 DM1
29. 27-08-
2015
Introduction to DOS and BIOS
interrupts
2 DM1
30.
29-08-15
8259 PIC Architecture and interfacing
cascading of interrupt controller and its
importance,
3 DM1
31. 30-08-15 Tutorial-VII DM2
32.
03-09-15
Serial data transfer schemes.
Asynchronous and Synchronous data
transfer schemes
2 DM1
33. 07-09-15
8251 USART architecture and
interfacing,
2 DM1
34. 09-09-15
TTL to RS 232C and RS232C to TTL
conversion
2 DM1
35. 11-09-15 Sample program of serial data transfer, 2 DM1
36. 14-09-15
Introduction to High-speed serial
communications standards, USB.
2 DM1
37. 15-09-15 Tutorial-VIII DM2
UNIT-V
38. 16-09-15
Introduction to 80286, Salient features
of 80386
2 DM1
39. 18-09-15 Real and Protected mode 5 DM1
40. 26-09-15
Segmentation & Paging, Salient
Features of Pentium
3 DM1
41. 1-10-15
Branch Prediction 2 DM1
42. 3-10-15
Tutorial-IX DM2
43. 5-10-15 8051 Microcontroller Architecture, 2 DM1
44. 07-10-15
Register set of 8051, Modes of timer
operation,
2 DM1
45. 10-10-15 Serial port operation 3 DM1
46. 15-10-15 Interrupt structure of 8051 1 DM1
47. 16-10-15 Memory and I/O interfacing of 8051. 2 DM1
48. 17-10-15 Tutorial-X DM2
Total 81
Total number of classes required to complete the syllabus 69
Total number of classes available as per Schedule 81
NOTE: DELIVERY METHODS : DM1: Lecture interspersed with discussions/BB, DM2:
Tutorial, DM3: Assignment/Test, DM4: Presentations/PPT
At the End of the course, students will attain the Course Outcomes:CO1,CO2,CO3,CO4 & sample
proofs are enclosed in Course file.
Signature
Course Co-coordinator Instructor HOD
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING (AUTONOMOUS)
L.B.REDDY NAGAR, MYLAVARAM – 521 230
School of Management Studies A c a de mi c Y e ar : 20 1 5 – 1 6
S UB J E C T: I N D U S T RI A L E NG I N E E RI NG & M A N A G EM E NT STA FF :Mrs J ay a Lakshm i IT : I I S E M C R E D IT s : 0 4
SNO NO.
HOURS
DATE PLANNED TOPICS REMARKS
1. 01 UNIT I Management Introduction
2. 01 Definition, Nature
3. 01 Importance of management
4. 01 Functions
5. 01
Taylor’s scientific management theory
6. 01 Fayal’s principles of management
7. 01 Tutorials
8. 01 Contribution of Elton mayo
9. 01 MASLOW theory
10. 01 Herzberg, douglas, MC Gregor, basic concepts of Orgn.
11. 01 tutorials
12. 01 Basic concept of organization :Authority Responsibility
13. 01 Delegation of Authority and span of control
14. 01 Departmentation and Decentralization
15. 01 tutorials
16. 01 Orgn.structure Line and staff organization
17. 01 Line and staff organization
18. 01 Functional organization
19. 01 Committee Matrix organization
20. 01 Tutorials
21. 01 UNIT II Operatons Management
22. 01 Plant location Factors influencing location
23. 01 Principles and types of plant layouts
24. 01 Methods of production : job batch and mass production
25. 01 Work study
26. 01 Basic procedure involved in method study
27. 01 Work measure ment
28. 01 tutorial
29. 01 UNIT III quality and materials management
30. 01 Statistical quality control Meaning
31. 01 Variables and attributes
32. 01 X chart R Chart C Chart PC hart
33. 01 X chart R Chart C Chart PC hart
34. 01 Acceptance sampling Sampling plans
35. 01 Deming’s contribution to quality
36. 01 Materials management : objectives
37. 01 Need for inventory control
38. 01 Tutorials
39. 01 Purchase procedure
40. 01 Store records
41. 01 EOQ
42. 01 problens
43. 01 ABC analysis
44. 01 Stock levels
45. 01 Stock level problems
46. 01 UNIT IV Human Resource management Concepts of
HRM
47. 01 Basic functions of HR manager
48. 01 Man power planning
49. 01 Selection
50. 01 Recruitment
51. 01 Training and development Placement
52. 01 Wage and salary admn
53. 01 Promotion
54. 01 Transfers Separation performance. Appraisal
55. 01 Job evaluation and merit ranking
56. 01 Tutorials
57. 01 UNIT V project management Early techniques in project
management
58. 01 Network analysis Programme evaluation and review
technique (PERT)
59. 01 Critical path method
60. 01 Identifying critical path
61. 01 Problems
62. 01 problems
63. 01 problems
SIGNATURE OF FACULTY HOD
64. 01 problems
65. 01 Probability of completing project within time
66. 01 problems
67. 01 Project cost analysis project crashing
68. 01 Problems
69. 01 Problems
70. 01 Problems
71. 01 Problems
72. 01 REVISION
73. 01 REVISION
LESSON PLAN
Date:
25/01/2016 To
07/06/2016
COMPUTER ORGANIZATION Branch: IT Semester & Sections: VI
COMPUTER ORGANIZATION Lecture : 4 Periods/week Internal Marks: 25
Tutorial : 1 External Marks: 75
Credits : 4 External Examination: 3 Hrs
--------------------------------------------------------------------------------------------------------------
UNIT 1:
Introduction: Review of number systems, Boolean Representation, complements, Function and
structure of a computer, Functional components of a computer, interconnection of components,
Performance of a computer.
UNIT 2:
Representation of Instruction: Machine instructions, Operands, Addressing modes, Instruction
formats, Instructions sets, Instruction set architectures- CISC and RISC architectures.
UNIT 3:
Processing unit: Organization of a processor- Registers, ALU AND Control unit, Data path in a CPU
,Instruction cycle, Organization of a control unit- Operations of a control unit, Hardwired control unit,
Micro programmed control unit.
UNIT 4:
Memory Subsystem: Semiconductor memories, Memory cells – SRAM And DRAM Cells, Internal
Organization of a memory chip, Organization of a memory unit, Error correction memories,
Interleaved memories, Cache memory unit- Concept of cache memory , Mapping methods,
Organization of a cache memory unit, fetch and write mechanisams,memory management unit –
Concept of Virtual memory , Address translation , Hardware support for memory management.
Unit 5:
Input/ Output Subsystem : Access of I/O devices ,I/O ports,I/O control mechanisms- program
controlled I/O ,Interrupt controlled I/O ,and DMA controlled I/O ,I/O interfaces –Serial port , Parallel
port ,PCI bus ,SCSI bus, USB bus, firewall and Infiniband , I/O peripherals- Input devices, output
devices, Secondary storage devices.
TEXT BOOK:
C. Hamacher ,Z. Vranesic and S.Zaky, ”computer Organization ”, Mc Graw- Hill ,2002.
REFERNCES:
1. W.stallings, ”computer Organizatio and Architecture- Designing for Performance”, Prentice
Hall of India, 2002 .
2. D.A. Patterson and J.L. Hennessy, , ”computer Organizatio and Design- The Hardware /
Software Interface”, Morgan Kaufmann ,1998.
3. JP. Hayes, “computer Architecture and Organization”, Mc Graw- Hill ,1998.
COURSE OUTCOMES: After the completion of the course, students should be able to
CO1: Understand ALU Micro operations and instruction code format of a digital computer.
CO2: Understand the design of control unit, Stack organization, RISC and CISC processors.
CO3: Understand the hardware organization of various arithmetic operations on fixed point and
Floating point numbers. Get familiarized with various pipelining.
CO4: Understand memory hierarchy, issues in design and performance.
CO5: Understand the DMA and interrupt handling mechanism for CPU-I/O device communication.
Lakireddy Bali Reddy College of Engineering
Department of IT
Outcome based lesson plan
Academic year: 2015-16 Course: Computer Organization
Programme: B.Tech Unit No: 1 to 5
Year & Sem: II - II
S.No Teaching Learning Process (TLP) Delivery Methods (DM) Assessment Methods
(AM)
1 Solving Real world problem Chalk & Talk Assignments
2 Explaining application before theory ICT tools Quiz
3 Solving problems Group discussions Tutorials
4 Designing of experiments Industrial visit Surprise Tests
5 Problems on environmental, economics, health & safety
Field work Mid Exams
6 Problems on professional & ethics Case studies Model Exam
7 Seminar Mini Projects QAs
8 Problems using Software Numerical treatment
9 Self study Design / Exercises
Detailed Lesson Plan
S.NO TOPIC TO BE COVERED Date
TLP DM AM Tentative Actual
UNIT-I: Register transfer Language and Micro-operations , Basic Computer Organization And
Design 1 Introduction 27-01-16 2 1
1,3,5,7
2 Introduction 28-01-16 2 1
3 Register Transfer language 29-01-16 2 1
4 Register transfer bus and memory
transfers
01-02-16
2 1
5 Register transfer bus and memory
transfers
02-02-16
2 1
6 Arithmetic Micro operations, 03-02-16 2,3 1
7 logic micro operations 04-02-16 2,3 1
8 shift micro operations 05-02-16 2,3 1
9 Arithmetic logic shift unit 08-02-16 2,3 1
10 Tutorial – 1 09-02-16 2 1
11 Instruction codes 10-12-16 2 1
12 Computer Registers 11-02-16 2 1
13 Computer instructions 12-02-16 2 1
14 Instruction cycle 15-02-16 2 1
15 Memory – Reference Instructions 16-02-16 2 1
16 Input – Output and Interrupt 17-02-16 2 1
17 Tutorial - 2 18-02-16
18 Assignment/Quiz-1 19-02-16
UNIT-II: Micro Programmed Control, Central Processing Unit
19 Control memory 22-02-16 2 1
1,3,5,7
20 Address sequencing 23-02-16 2 1
21 micro program example 24-02-16 2 1
22 design of control unit Hard wired
control
25-02-16 2 1
23 Micro programmed control 26-02-16 2 1
24 Tutorial- 3 29-02-16 2 1
25 STACK organization. 01-03-16 2,3 1
26 STACK organization. 02-03-16 2,3 1
27 Program control 03-03-16 2 1
28 Instruction formats 04-03-16 2 1
29 Addressing modes 05-03-16 2,3 1
30 DATA Transfer 08-03-16 2 1
31 Data Manipulation 09-03-16 2 1
32 Reduced Instruction set computer 10-03-16 2 1
33 Differences between RISC and
CISC, Assignment/Quiz-2
11-03-16 2 1
MID – I EXAMS
14-03-2016 To
19-03-2016
UNIT-III: Pipelining And Vector Processing, Computer Arithmetic
34 Parallel processing, 21-03-16 2 1
1,3,5,7
35 Pipelining 22-03-16 2 1
36 Arithmetic Pipeline 23-03-16 2 1
37 RISC pipeline 24-03-16 2 1
38 Instruction Pipeline 28-03-16 2 1
39 Vector Processing 29-03-16 2 1
40 Tutorial-5 30-03-16
41 Data Representation, Fixed Point &
Floating Point Representation
31-03-16 2 1
42 Addition and subtraction 01-04-16 2 1
43 multiplication Algorithms 04-04-16 2 1
44 multiplication Algorithms 06-04-16 2 1
45 Tutorial-7 07-04-16 2,3 1
46 Division Algorithms 11-04-16 2,3 1
47 Division Algorithms 12-04-16
48
Floating – point Arithmetic
operations
13-04-16 2,3 1
49
Decimal Arithmetic unit, Decimal
Arithmetic operations
18-04-16 2,3 1
50
Decimal Arithmetic unit, Decimal
Arithmetic operations
19-04-16 2,3 1
51 Tutorial-8 20-04-16
52 Assignment/Quiz-3 21-04-16
UNIT-IV: Memory Organization
53 Memory Hierarchy 22-04-16 2 1,2
1,3,5,7
54 Main memory 25-04-16 2 1,2
55 Auxiliary memory 26-04-16 2 1,2
56 Associative memory 27-04-16 2 1,2
57 Tutorial-9 28-04-16 2 1,2
58 Cache memory 29-04-16 2 1,2
59 Virtual memory 02-05-16 2 1,2
60 Tutorial-10 03-05-16 2 1,2
61 Assignment/Quiz-4 04-05-16
UNIT-V: Input-Output Organization
62 Peripheral Devices 05-05-16 2 1,2
1,3,5,7
63 Input-Output Interface 06-05-16 2 1,2
64 Asynchronous data transfer 09-05-16 2 1,2
65 Modes of Transfer, 10-05-16 2 1,2
66 Priority Interrupt 11-05-16 2 1,2
67 Direct memory Access 12-05-16 2 1,2
68 Tutorial-11 13-05-16 2 1,2
69 Input–Output Processor (IOP) 01-06-16 2 1,2
70 Serial communication 02-06-16 2 1,2
71 Tutorial-12 03-06-16 2 1,2
72 Assignment/Quiz-5 06-06-16 2 1,2
73 Previous Papers Discussion 07-06-16 2 1,2
II MID EXAMS 08-06-16
to 15-06-16
Assessment Summary:
Assessment Task Weight age
(Marks)
Course Outcomes
CO1 CO2 CO3 CO4 CO5
Assignments
05
Quizzes
Tutorials
Surprise Tests
Mid Exams 20
Model Exams --
End Exam 75
Attendance --
Total 100
Mapping Course Outcomes with Programme Outcomes:
Course Code
Course Outcomes
Program Outcomes PSOs
a b c d e f g h i j k l 1 2 3 4 5
S169
CO1
CO2
CO3
CO4
CO5
Instructor Course
Coordinator
Module
Coordinator HOD
Name K Purushottama
Rao Dr. D. Naga Raju
Sign with Date
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING (Autonomous)
Department of Information Technology LESSON PLAN
S.n
o
DATE TOPIC TO BE COVERED ACTUAL
DATE
CONTENT
DELIVERY
METHODS
UNIT-I
1
WE
EK
1
22/06/2015 Introduction to s/w engineering DM1,DM8
2 24/06/2015 The evolving role of s/w DM1
3 25/06/2015 Definition of s/w, changing the nature of s/w DM1
4 26/06/2015 changing the nature of s/w DM1
5 27/06/2015 Legacy s/w, Software myths DM1
6
WE
EK
2
29/06/2015 Software myths DM1
7 01/07/2015 Introduction to s/w process and process layered technology
DM1
8 02/07/2015 Tutorial-I DM2
9 03/07/2015 Process patterns, different types DM1,DM8
10 04/07/2015 Process framework & Its phases DM1,DM8
11
WE
EK
3 06/07/2015 A Process framework & Its phases DM1
12 08/07/2015 Umbrella activities of process framework DM1
13 09/07/2015 Umbrella activities of process framework DM8
14 10/07/2015 S/W process assessment & its principles DM1
15 11/07/2015 CMMI, Process patterns DM8
16
WE
EK
4
13/07/2015 Tutorial-II DM2
17 15/07/2015 Process assessment DM1
18 16/07/2015 Personal and team process models DM1
19 17/07/2015 Process technology DM1,DM8
20 20/07/2015 Product process
DM2
21
WE
EK
5
UNIT-II
22 22/07/2015 Process Models Introduction DM1,DM8
23 23/07/2015 Prospective models DM1,DM8
24 24/07/2015 Water fall model its merits and demerits DM1,DM8
25/07/2015 V-shaped Model and its merits and
demerits DM1,DM8
25 25/07/2015 RAD Model ,component based model
DM1
26
WE
EK
6
27/07/2015 Tutorial-3 DM2
27 29/07/2015 Concurrent development model DM1,DM8
28 31/07/2015 Incremental model its merits and demerits DM1,DM8
29 01/07/2015 Prototype model its merits demerits
DM8
30 03/08/2015 Spiral model its merits and demerits DM8
31
WE
EK
7 05/08/2015 Functional requirements and Non functional
requirements DM8
32 06/08/2015 Functional requirements and Non functional requirements
DM1
33 07/08/2015 Tutorial-4 DM2
Course Code& Course Name: T308 –SOFTWARE ENGINEERING SEM:
V
Programme: B.Tech
Department: IT
LESSON PLAN
34
08/08/2015
Review of Unit-2 DM1,DM8
35 MID-I(10/08/2015 TO 17/08/2015)
UNIT-III
36 W
EE
K8
19/08/2015 Introduction to requirements engineering DM1,DM8
37 20/08/2015 RE tasks DM1,DM8
38 21/08/2015 Initiating the RE process DM1,DM8
39 22/08/2015 Eliciting requirements DM1
40
WE
EK
9
24/08/2015 Developing Use cases DM8
41 26/08/2015 Building the analysis models DM1
42 27/08/2015 Negotiating and validating requirements DM1
43 28/08/2015 Tutorial-5 DM2
44 29/08/2015 Introduction to requirement analysis DM8
45
WE
EK
10
31/08/2015 Analysis modeling approaches DM8
46 02/09/2015 Data modeling concepts DM1,DM8
47 03/09/2015 Data modeling concepts, OOA, scenario based modeling
DM1,DM8
48 04/09/2015 Flow based Modeling DM1,DM8
49
WE
EK
11
07/09/2015 Class based modeling, Creating a behavior DM8
50 09/09/2015 Review of Unit-3 DM8
UNIT-IV
51 10/09/2015 Introduction to Design Engineering DM1
52 11/09/2015 Design process and design concepts DM1,DM8
53 12/09/2015 Design models DM1,DM8
54
WE
EK
12
14/09/2015 Design Models DM1,DM8
55 16/09/2015 Pattern based software design DM1
56 17/09/2015 Creating an architectural design DM1
57 18/09/2015 Software architecture DM1,DM8
58 19/09/2015 Data design DM1,DM8
59
WE
EK
13
21/09/2015 Architectural styles and patterns DM1,DM8
60 23/09/2015 Architectural design DM1,DM8
61 25/10/2015 Tutorial-6 DM2
62 26/10/2015 Review of Unit-4
DM1,DM8
UNIT-V
63
WE
EK
1
4
28/10/2015 Introduction to testing strategies DM1
64 30/10/2015 Strategic issues for software testing DM1
65 01/10/2015 Test strategies for conventional software DM1,DM8
66 03/10/2015 Object oriented software DM1,DM8
67
WE
EK
15
05/10/2015 Validation testing DM1,DM8
68 07/10/2015 System testing, Debugging DM1,DM8
69 08/10/2015 Tutorial-7 DM2
70 09/10/2015 Software testing fundamentals DM1
71 10/10/2015 White box testing DM1
72
WE
EK
16
12/10/2015 Black box testing DM8
73 14/10/2015 Basis path testing DM8
74 15/10/2015 OO Testing Methods DM8
75 16/10/2015 OO Testing Methods DM8
76 17/10/2015 Review of Unit-5 DM8
NOTE: DELIVERY METHODS: DM1: Lecture interspersed with discussions/BB, DM2: Tutorial,
DM3: Lecture with a quiz, DM4: Assignment/Test, DM5: Demonstration ( laboratory, field visit ),
DM6: Group Discussion, DM7: Group Assignment/ Project, DM8: Presentations/PPT,
DM9:Asynchronous Discussion..
Signature
Name of the Faculty Name of Course Co-
ordinator
HOD
Signature of the Faculty Head of the Department
LakireddyBalireddy College of Engineering (Autonomous) L.B.Reddy Nagar, Mylavaram , Krishna District, A.P
Freshmen engineering Department LESSON PLAN
Subject : PROBABILITY & STATISTICS (P&S) - S 351
Academic Year : 2015-16 Semester : IV Date: 27.01.2016
To 07.06.2016 Faculty name : M.Rami Reddy Branch : IT
SYLLABUS
UNIT - I
PROBABILITY AND RANDOM VARIABLES
Conditional probability – Multiplication theorem-Baye’s theorem. Random variables –
Discrete and continuous Random Variables and their distribution functions, Mathematical
Expectation of Univariate Random Variable.
UNIT - II
PROBABILITY DISTRIBUTIONS
Probability Distributions-Binomial, Poisson, Normal and Gamma distributions-related
properties, simple applications. Moment Generating Function and properties. Moment
Generating Function for standard distributions.
UNIT - III
SAMPLING DISRIBUTION AND ESTIMATION
Population and samples. Sampling distribution of mean (with known and unknown variance),
proportion, variances. - Sampling distribution of sums and differences. Point and interval
estimators for mean, variance and proportions.
UNIT - IV
TESTING OF HYPOTHESIS
Null and Alternative Hypothesis, One tail and two tailed tests,Type I and Type II errors.
Testing of hypothesis concerning means, proportions and their differences using Z-test.Tests
of hypothesis using Student’s t-test, F-test and χ2 test. Applications of decision
making using the above tests.
UNIT - V
CORRELATION AND CURVE FITTING
Simple Bivariate Correlation and Regression lines.Curve fitting: Fitting a straight line –
Second degree curve-exponential curve by method of least squares and goodness of fit.
TEXT BOOKS
1. Miller & Freund’s “Probability and Statistics for Engineers” Prentice Hall of India,
New Delhi, 8th edition. 2011.
2. William W. Hines “Probability and Statistics in Engineering” John Wiley & Sons,
4th edition.2002
REFERENCES
1. Jay L.Devore “Probability and Statistics for engineering and the sciences.” Cengage
Learning india, 8th edition, 2012.
2. S.C.Gupta&V.K.Kapoor “Fundamentals of Mathematical Statistics” Sultan Chand and
sons, New Delhi. 11thedition 2002.
3. T.K.V.Iyangar “Probability and Statistics” S.Chand& Company, New Delhi, edition
2012.
4. B.V.Ramana “Higher Engineering Mathematics” TMH, New Delhi, 1st Edition, 2010.
Course Educational Objectives: The main objectives of this course are
1. To revise elementary concepts and techniques encountered in probability.
2. To extend and formalize knowledge of the concepts of probability and probability distributions.
3. To introduce the techniques for carrying out sampling methods and estimation of parameters.
4. To motivate the use of sampling tests using tests of significance.
5. To study the concepts of correlation and linear, non linear regression lines.
Course Outcomes: After the completion of the course, students should be able to
CO1: Apply knowledge of mathematics & probability techniques in engineering.
CO2: Design as well as to analyze and interpret the problems using Probability distributions. CO3: Apply the methods of sampling and estimation of parameter values.
CO4: Identify, formulate and solve problems using tests of hypothesis.
CO5: To measure the association between the variables and prediction of variables.
S. No.
Tentative Date
Topics to be covered Actual Date
Number of
Classes
Delivery
Method
UNIT- I 1 27-01-2016 Introduction class 1 DM1
2 28-01-2016 Syllabus and Basic concepts 1 DM1
3 30-01-2016 Introduction to probability 1 DM1
4 01-02-2016 Basic definitions, simple problems 1 DM1
5 02-02-2016 Problem on addition theorem 1 DM1
6 03-02-2016 Conditional probability 1 DM1
7 04-02-2016 Multiplication theorem, examples 1 DM1
8 06-02-2016 Independent events, theorems 1 DM1
9 08-02-2016 Problems on multiplication theorem 1 DM1
10 09-02-2016 Problems on independent events 1 DM1
11 10-02-2016 Baye’s theorem 1 DM1
12 11-02-2016 Problems on baye’s theorem 1 DM1
13 13-02-2016 Tutorial 1 DM2
14 15-02-2016 Assignment & Quiz questions 1 DM2,4
UNIT- II 15 16-02-2016 Random variables,(discrete and continuous) 1 DM1
16 17-02-2016 Mathematical Expectation ,relations 1 DM1
17 18-02-2016 Problems on PMF 1 DM1
18 20-02-2016 Problems on PDF 1 DM1
19 22-02-2016 Problems on pdf 1 DM1
20 23-02-2016 Binomial Distribution , mean and variance 1 DM1
21 24-02-2016 Problems on Binomial distribution 1 DM1
22 25-02-2016 Fitting of Binomial distribution 1 DM1
23 27-02-2016 Poisson distribution, mean and variance 1 DM1
24 29-02-2016 Problems on Poisson distribution, MGF 1 DM1
25 01-03-2016 Fitting of Poisson Distribution. 1 DM1
26 02-03-2016 Normal distribution 1 DM1
27 03-03-2016 Problems on Normal Distribution 1 DM1
28 05-03-2016 Problems on Normal Distribution 1 DM1
29 08-03-2016 Gamma distribution, simple applications 1 DM1
30 09-03-2016 Moment Generating Function and properties 1 DM1
31 10-03-2016 MGF of Binomial, Poisson and Normal 1 DM1
32 11-03-2016 Tutorial 1 DM1
33 12-03-2016 Assignment & Quiz questions 1 DM2,4
34 14-03-2016 I Mid Exams
35 15-03-2016 I Mid Exams
36 17-03-2016 I Mid Exams
37 18-03-2016 I Mid Exams
38 19-03-2016 I Mid Exams
UNIT III
39 21-03-2016 Population and samples 1 DM1
40 22-03-2016 Sampling distribution of mean 1 DM1
41 24-03-2016 Sampling distribution of mean 1 DM1
42 26-03-2016 Sampling distribution of proportions 1 DM1
43 28-03-2016 Sampling distribution of variances 1 DM1
44 29-03-2016 Sampling distribution of sums and differences 1 DM1
45 30-03-2016 Point and interval estimation of mean 1 DM1
46 31-03-2016 Point and interval estimation of mean 1 DM1
47 02-04-2016 Point and interval estimation of proportions. 1 DM1
48 04-04-2016 Tutorial 1 DM2
49 05-04-2016 Assignment & Quiz questions 1 DM2,4
UNIT IV
50 06-04-2016 Testing of Hypothesis , definitions 1 DM1
51 07-04-2016 Type I and Type II errors 1 DM1
52 11-04-2016 Large samples- Z-test for single mean 1 DM1
53 12-04-2016 Z-test for single mean 1 DM1
54 13-04-2016 Z-test for difference of means 1 DM1
55 16-04-2016 Z-test for single proportion 1 DM1
56 18-04-2016 Z-test for difference of proportions 1 DM1
57 19-04-2016 t-test for single mean 1 DM1
58 19-04-2016 t-test for difference of means 1 DM1
59 20-04-2016 Problems on t-tests 1 DM1
60 21-04-2016 F-test for population variances 1 DM1
61 23-04-2016 χ2 test for goodness of fit 1 DM1
62 25-04-2016 χ2 test for independence of attributes 1 DM1
63 27-04-2016 Problems on χ2 test 1 DM1
64 28-04-2016 Tutorial 1 DM2
65 30-04-2016 Assignment & Quiz questions 1 DM2,4
UNIT V
66 02-05-2016 Simple Bi-variate Correlation 1 DM1
67 03-05-2016 Problems on Pearson’s Correlation 1 DM1
68 04-05-2016 Problems on Pearson’s Correlation 1 DM1
69 05-05-2016 Problems on rank Correlation 1 DM1
70 07-05-2016 Regression lines 1 DM1
71 09-05-2016 Problems on Regression lines 1 DM1
72 10-05-2016 Problems on Regression lines 1 DM1
73 11-06-2016 Curve fitting- method of least squares 1 DM1
74 12-06-2016 Fitting a straight line, Second degree curve 1 DM1
75 01-06-2016 Fitting of exponential and other curves 1 DM1
76 02-06-2016 Tutorial 1 DM2
77 04-06-2016 Assignment & Quiz questions 1 DM2,4
78 06-06-2016 Revision 1 DM1
79 07-06-2016 Revision 1 DM1
Instructor Course
Coordinator
Module
Coordinator
HOD
Name
Sign with Date
SCHOOL OF MANAGEMENT STUDIES
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING (AUTONOMOUS) L.B.REDDY NAGAR, MYLAVARAM – 521 230
Professional Ethics Lesson Plan S.No. Date Topics to be covered
1 30-11-15 Discussion about Syllabus
2 01-12-15 Introduction to Professional Ethics
3 02-12-15 Unit 1: Senses of 'Engineering Ethics', variety of moral
issues, types of inquiry, moral dilemmas
4 04-12-15 Moral autonomy Kohlberg's theory Gilligan's theory
5 05-12-15 consensus and controversy, Models of Professional Roles,
theories about right action
7 07-12-15 Utilitarian theory, duty ethics
8 08-12-15 Right theory, Virtue ethics, self realization ethics, Justice Theory
9 09-12-15 Self interest customs and Religion.
10 11-12-15 Uses of Ethical theories.
11 14-12-15 Unit 2: Morals, Values and Ethics.
12 15-12-15 Integrity and Work Ethics.
13 16-12-15 Service Learning, Civic Virtue,
14 18-12-15 Respect for Others, Living Peacefully
15 19-12-15 Caring, Sharing, Honesty, Courage
16 21-12-15 Valuing Time, Cooperation, Commitment
17 30-12-15 Empathy, Self Confidence.
18 02-01-16 Character and Spirituality.
19 03-01-16 Unit3: Engineering as experimentation, engineering projects
(vs) standard projects
20 04-01-16 Engineers as responsible experimenters
21 05-01-16 Codes of ethics a balanced outlook on law
22 06-01-16 The challenger case study
23 07-01-16 Unit 4: Safety and risk assessment of safety and risk.
24 22-01-16 Risk Benefit Analysis and reducing risk.
25 23-01-16 The Three Mile Island and Chernobyl case studies.
26 24-01-16 Collegiality and loyalty respect for authority collective bargaining.
27 25-01-16 Collegiality and loyalty respect for authority collective
bargaining.
28 26-01-16 Confidentiality conflicts of interest.
29 27-01-16 Types Of conflicts of interest.
30 29-01-16 Occupational crime.
31 22-02-16 Types Of Occupational Crime.
32 23-02-16 Professional rights employee rights Intellectual Property Rights (IPR) discrimination.
33 24-02-16 Intellectual Property Rights (IPR) discrimination.
34 26-02-16 Intellectual Property Rights (IPR) discrimination
35 27-02-16 Unit 5: Introduction.
36 28-02-16 Multinational corporations.
37 01-03-16 Environmental ethics.
38 02-03-16 Computer ethics.
39 04-03-16 Computer ethics.
40 05-03-16 Weapons development.
41 06-03-16 Engineers as managers.
42 08-03-16 Consulting engineers
43 09-03-16 Engineers as expert witnesses and advisors
44 11-03-16 Moral leadership
45 03-04-16 Sample code of Ethics (Specific to Mech)
46 04-04-16 Sample code of Ethics in General
47 05-04-16 Advanced topics
Signature of the faculty Head of the Department
LAKIREDDY BALI REDDY COLLEGE OF ENGINEERING (Autonomous)
DEPARTMENT OF Information Technology
LESSON PLAN
Subject : Database management systems Lab Course : B.Tech Semester : IV Faculty : M.Mahesh Academic year :2015-16
SN
O
DATE TOPIC TO BE COVERED
Actual Date
Delivery Method
1 28/01/2015 Create a table named STUDENT and set the validation
rules while creating the structure:
Display the names of students whose names begin with
‘S’.
Display the details of students whose qualification is
‘MCA’
Display the details of students whose age is greater
than 24
DM5
2 04/02/2015 Create an EMPLOYEE table Assume all constraints, enter the data and calculate DA,HRA and Gross Pay.
DM5
3 11/02/2015 Create a table called StudentDetails by importing the details of students from MS-EXCEL Worksheet.
DM5
4 18/2/2015 Create the CATALOG table Get the details of all the books whose price is between 1000 and 1500 Get the details of all the books whose price is between 1000 and 1500 in the descending order of the prices. Get the details of all the books whose stock level is zero.
DM5
5 25/2/2015 Create a table named PERSON with Name and Age as attributes. Enter the data for 10 rows. Modify the structure of the table to add a new column “Address” Make the name and address as the Primary Key for this table
DM5
6 3/3/2015 Create two tables EMPLOYEE and DEPARTMENT Make Employee # and DeptNo the primary keys for EMPOLYEE and DEPARTMENT tables respectively. Make DeptNo of Employees tables, the foreign key for the DEPARTMENT tables
Display the names of places, where different employees are working
Display the details of Employees, Whose salary is greater than rs.5000.
DM5
7 10/3/2015 Create the CATALOG table Get the details of all the books whose year of publishing is 2005 Get the details of all the books whose year of publishing is 2002 or 2005 Get the details of all the books whose year of publishing is between 2000 and 2005
DM5
8 17/3/2015 Create the table EMPLOYEE Modifying the Job of all employees to ’MANAGER’ Enhance the salary of all employees by 10%. Delete the details of all employees, Whose salary is less then Rs.5000/-
DM5
9 31/3/2015 Illustrate the use of Append Query Display name and location of the department, where ALLEN is working
DM5
Display number and name of all the employees, who earn more than 2600 in alphabetical order by name Write a query that will accept a given job title and displays all rows according to that title
10 03/4/2015 Consider the EMPLOYEES, DEPARTMENT Tables Write a query to duplicate the EMPLOYEE table Calculate the department number where more then one clerk is working
DM5
11 21/4/2015 From the Interview Table, select only Intv_Id having Intv_Marks of more than 70, who recruited for posts Create a simple query named Interview List to select only cand_Idfrom Applicationstable with candidates From the Interview Table, select only Intv_Id having Intv_Marks of more than 70, who recruited for posts Create a look up field for Post _Recruited having the values Software Engineer, System Engineer, Support Incharge, Senior Manager.
DM5
12 28/4/2015 Build a form with the details of candidates selected for Interview. The details are to be automatically update to the Interview table Build a form with the details of candidates who have been recruit to various posts, using the information from the Recruitment table.
DM5
13 28/4/2015 Create the CATALOG table Find the name of all the books that start with the letter ‘C’ Find the details of the books with the title “TechnoTrends
Illustrate the use of Make-tables Query
DM5
14 5/5/2015 Create the CATALOG table Find the price of the book “Rapid Application Development Change the price of the book “software Engineering” to Rs. 500/-. Delete the record for the book named “The Internet Applications”.
DM5
15 12/5/2015 Generate a Report based on the table StudDetails, MarksDetails, using the Report Wizard
DM5
16 2/6/2015 Lab Internal Exam DM5
TEXTBOOKS: Korth,Silbertz, Sudarshan, "Database Concepts", McGraw Hill
REFERENCES:
1. Elmasri, Navathe, "Fundamentals of Database Systems", Addision Wesley
2. Raghu Ramakrishnan,"Database management system",McGraw Hill
3. Maheshwari jain,"DBMS:Complete Practical approach", Firewall media New Delhi
Prepared By: Head of the Department
Faculty Name:,K.V.ASHOK,R.HARI KISHAN LAB SCHEDULE
Date: 22-06-2015. Year: B.Tech - V SEM MICROPROCESSORS & INTERFACING IT
S.NO. UNIT DESCRIPTION II Batch(TUE ) I Batch(THU) Signature
Planned Performed Planned Performed
1. 1 Introduction to 8086 Kits & Debug 23/06/15 25/06/15
2. 3 Programs on Data Transfer & Exchange 30/06/15 02/07/15
3. 6 Programs on ADD,ADC,SUB 7/7/15 09/07/15
4. 8 Programs on MUL & DIV 21/07/15 23/07/15
5. 11
Programs on code Conversion 04/08/15 06/08/15
6. 14
Programs on Sorting 18/08/15 20/08/15
7. 16
Programs on String 25/08/15 27/08/15
8. 18
Programs on Subroutines, MASM 01/09/15 03/09/15
9. 21
DAC Interfacing- Generation of Waveforms 08/09/15 10/09/15
10. 23
Cycle ADC Interfacing 15/09/15 17/09/15
11. 25
Cycle Stepper Motor Interfacing 22/09/15 24/09/15
12. 27
Cycle Key Board Interfacing 29/09/15 1/10/15
13. 30
Cycle Display Interfacing 06/10/15 08/10/15
14. 32
Cycle 8051 Program- Program & IO 13/10/15 13/10/15
15. 35
Cycle INTERNAL EXAM 15/10/15 15/10/15
Signature of the Faculty HEAD OF THE DEPARTMENT