S6 Academic Handbook

Rajagiri School of Engineering & Technology
SEMESTER 6
PERIOD: Jan 2019 –Apr 2019
Department of Information Technology 1

Program Outcomes (PO)
Information Technology Program Students will be able to:
PO 1.Engineering knowledge: Apply the knowledge of mathematics, science, engineering

fundamentals, and an engineering specialization to the solution of complex engineering problems.
PO 2.Problem analysis: Identify, formulate, review research literature, and analyze complex engineering
problems reaching substantiated conclusions using first principles of mathematics, natural sciences, and
engineering sciences.
PO 3.Design/development of solutions: Design solutions for complex engineering problems and design system
components or processes that meet the specified needs with appropriate consideration for the public health
and safety, and the cultural, societal, and environmental considerations.
PO 4.Conduct investigations of complex problems: Use research-based knowledge and research methods
including design of experiments, analysis and interpretation of data, and synthesis of the information to
provide valid conclusions.
PO 5.Modern tool usage: Create, select, and apply appropriate techniques, resources, and modern engineering
and IT tools including prediction and modeling to complex engineering activities with an understanding of
the limitations.
PO 6.The engineer and society: Apply reasoning informed by the contextual knowledge to assess societal,
health, safety, legal and cultural issues and the consequent responsibilities relevant to the professional
engineering practice.
PO 7.Environment and sustainability: Understand the impact of the professional engineering solutions in
societal and environmental contexts, and demonstrate the knowledge of, and need for sustainable
development.
PO 8.Ethics: Apply ethical principles and commit to professional ethics and responsibilities and norms of the
PO 9.Individual and team work: Function effectively as an individual, and as a member or leader in diverse
teams, and in multidisciplinary settings.
PO 10.Communication: Communicate effectively on complex engineering activities with the engineering
community and with society at large, such as, being able to comprehend and write effective reports and
design documentation, make effective presentations, and give and receive clear instructions.

PO 11.Project management and finance: Demonstrate knowledge and understanding of the engineering and
management principles and apply these to one’s own work, as a member and leader in a team, to manage
projects and in multidisciplinary environments.
PO 12. Life-long learning: Recognize the need for, and have the preparation and ability to engage in
independent and life-long learning in the broadest context of technological change.
Program Specific Outcomes (PSO)

Information Technology Program Students will be able to:
PSO1: Acquire skills to design, analyse and develop algorithms and implement those using high-level
programming languages.
PSO2: Contribute their engineering skills in computing and information engineering domains like network
design and administration, database design and knowledge engineering.
PSO3: Develop strong skills in systematic planning, developing, testing, implementing and providing IT
solutions for different domains which helps in the betterment of life.
Program Educational Objectives (PEO)

Graduates of Information Technology program shall
PEO 1: Have strong technical foundation for successful professional careers and to evolve as key-players/
entrepreneurs in the field of information technology.
PEO 2: Excel in analyzing, formulating and solving engineering problems to promote life-long learning, to
develop applications, resulting in the betterment of the society.
PEO 3: Have leadership skills and awareness on professional ethics and codes.

INDEX
Sl. No Page No
1 Distributed System 7
1.1 Course Information Sheet 8
1.2 Assignment Questions 14
1.3 Course Plan 14
2 Principles of management 16
2.23.2 Assignment Questions 22
2.3 Course Plan 22
3 Compiler Design 24
3.2 Assignment Questions 31
3.3 Course Plan 33
4 Data Warehousing and management 35
4.1 Course information Sheet 36
4.2 Tutorials 44
4.3 Assignment questions 45
4.4 Course plan 46
5 Internet Technology 48

5.3 Course plan 53
6 Information Retrieval 57
6.3 Course plan 63
7 Software project management 64
7.3 Course plan 70
8 Internet Technology lab 71
8.2 Lab Schedule 78
9 Computer network lab 84
9.2 Lab Schedule 94
9.3 Open Questions 95
9.3 Advanced Questions 100
10 Comprehensive exam 103

ASSIGNMENT SCHEDULE FOR S6 IT
Week Subject Subject Teacher
Mary john
Week 1 Distributed Systems
Principles of management Lakshmi VijayKumar

Week 2
Week 3 Compiler Design Binu A
Week 4 Data warehousing and management Saritha S
Week 5 Internet technology Divya james
Software project management/ Abey Abraham/

Week 6
Information retrieval Lakshmi KS

IT 306
Distributed System

COURSE INFORMATION SHEET - Jan 2019
PROGRAMME: Information Technology DEGREE: BTECH

COURSE: Distributed Systems SEMESTER: Sixth CREDITS: 3
COURSE CODE: IT306 COURSE TYPE: CORE
REGULATION:2016
COURSE AREA/DOMAIN: Operating System CONTACT HOURS:3 hours/Week.
CORRESPONDING LAB COURSE CODE (IF ANY):No LAB COURSE NAME:NA
SYLLABUS:
UNIT DETAILS HOURS
Characterization of Distributed Systems-Introduction-Examples-Resource Sharing and the

I Web-Challenges. System Models-Architectural-Fundamental. Inter process 7
Communication-Introduction-API for Internet protocols-External data representation and
marshalling--Client-server communication-Group communication- Case study: Inter
process Communication in UNIX.
Distributed Objects and Remote Invocation-Introduction-Communication between

II distributed objects-Remote procedure calls-Events and notifications-Case study: Java RMI. 7
Operating System Support-Introduction-OS layer-Protection-Processes and threads-
Communication and invocation OS architecture.
Distributed File Systems-Introduction-File service architecture-Case Study: Sun Network
III File System-Enhancements and further developments. 7
Name Services-Introduction-Name Services and the Domain Name System-Directory
Services-Case Study: Global Name Service
Time and Global States-Introduction-Clocks, events and process states-Synchronizing physical
IV clocks-Logical time and logical clocks-Global states-Distributed debugging. 5
V Coordination and Agreement-Introduction-Distributed mutual exclusion – Elections ¬ 8

Multicast communication-Consensus and related problems.
Distributed Shared Memory-Introduction-Design and implementation issues-Sequential

consistency and Ivy case study Release consistency and Munin case study-Other consistency
VI 8
models.
CORBA Case Study- Introduction-CORBA RMI-CORBA services.
TOTAL HOURS 42

TEXT/REFERENCE BOOKS:
T/R BOOK TITLE/AUTHORS/PUBLICATION
Text Books:
T
George Coulouris, Jean Dollimore, Tim Kindberg, “Distributed Systems: Concepts and Design”,
Pearson 2009, 4th Edition.
References:
1. Andrew S Tanenbaum and Marteen Van Steen, “Distributed Systems Principles and
Paradigms”, Pearson Education / Prentice Hall of India , New Delhi, 2002.
R 2. Pradeep K Sinha, “Distributed Operating Systems: Concepts and Design”, Prentice Hall of
India, New Delhi, 2004.
3. MukeshSinghal, Niranjan G Shivarathri, “Advanced Concepts in Operating systems”, Tata
McGraw Hill Ltd.
4. Tanenbaum A S, “ Modern Operating System”, 3/e, PHI
COURSE PRE-REQUISITES:
C.CODE COURSE NAME DESCRIPTION SEM
CS202 Computer Organization and Basics of computer organization 4
Architecture
IT305 Operating System Functionalities of OS 5
COURSE OBJECTIVES:
• To understand the concepts that underlie distributed computing systems along with design
and implementation issues.
• To study the key mechanisms and models for distributed systems.

COURSE OUTCOMES:
SNO DESCRIPTION Blooms’ Taxonomy Level

IT306.1 Students will be able to gain a clear understanding Knowledge (level1),
of the concepts that underlie distributed computing systems Understand, Analyze (level 2
along with design and implementation issues
and 4)
IT306.2 Students will be able to define key mechanisms and analyze different Knowledge (Level 1),
models for distributed systems. Understand, Analyze (level 2
and 4), Evaluate (level 5)
IT306.3 Students will be able to correlate the different types of file systems Analyze (level 4)
and naming services which are used by different client processes.
IT306.4 Students will be able to understand time related issues in distributed Understand (level 2)
systems.
IT306.5 Students will be able to correlate different election algorithms related Knowledge(Level 1),
to the issue of how processes coordinate their actions and agree on Understand
shared values in distributed systems. (level 2) and Analyse (level4)
IT306.6 Students will be able to understand different shared memory Understand(level 2)
programming models in distributed systems.
CO-PO AND CO-PSO MAPPING
PO PO2 PO PO PO PO PO PO PO PO PO PO PSO1 PSO PSO3

1 3 4 5 6 7 8 9 10 11 12 2
IT306.1 1 1 _ _ _ _ _ _ _ _ _ 2 2 _ _
IT306.2 1 3 2 2 _ _ _ _ _ _ _ _ - 2 _
IT306.3 3 - 3 _ _ _ _ _ _ _ _ - 2 _
IT306.4 1 3 2 2 _ _ _ _ _ _ _ _ - 1 _
IT306.5 2 3 3 2 _ _ _ _ _ _ _ _ 3 _ _
IT306.6 1 _ 2 _ _ _ _ _ _ _ _ _ - _ _

JUSTIFICATIONS FOR CO-PO/PSO MAPPING

MAPPING LOW/ME JUSTIFICATION
DIUM/HI
GH
IT306.1-PO1 L The knowledge of basic concepts of distributed systems will help the students to
apply the same to formulate solutions for engineering problems.
IT306.1-PO2 L The knowledge of different ways of handling distributed systems principles will
help the students to apply the same to identify and analyze engineering problems.
IT306.1- M The knowledge of distributed systems concepts helps students to develop system
PO12 programs and system calls and implement using Java language and shell scripts.
IT306.1- M The knowledge of basic concepts of processes will help the students to apply the
PSO1 same to formulate solutions for engineering problems.
IT306.2-PO1 L Understanding of different mechanisms will help to review and analyze their
operations in distributed system.
IT306.2-PO2 H Thorough understanding of different models will help in the design and development
of abstract models for communication.
IT306.2-PO3 M Study of protocols in communication will help in conducting detailed investigation
of complex communication problems in distributed system.
IT306.2-PO4 M Knowledge in communication models helps in applying appropriate techniques in
distributed system design.
IT306.2- M Understanding of different mechanisms and models will aid in design of real time
PSO2 communication protocols for complex problems
IT306.3-PO1 H Correlating the study of file systems to real world applications will aid in formulating
engineering problems with similar background and arriving at with solutions
IT306.3-PO3 H The real world application study of file systems and name services will help to
design and develop solutions of similar kind engineering problems
IT306.3- M Study of naming services can be utilized in designing, analyzing and interpreting of
PSO2 different problems and provide valid solutions.
IT306.4-PO1 L Detailed analytical and evaluative study of time related issues will help in
identification, formulation and finding feasible solutions for real world
computational problems

IT306.4-PO2 H An evaluative knowledge of time related issues will help in applying the same while
designing and developing solutions to computational problems
IT306.4-PO3 M Evaluative learning of different type of clocks for time management will help in
analysis and synthesis of real time computational problems related to distributed
systems.
IT306.4-PO4 M Can contribute knowledge in global states of distributed computations despite the
lack of global time.
IT306.4- L Understanding the different types of clocks, events and process states problems in
PSO2 distributed system will aid in applying the knowledge to find solutions of complex
problems
IT306.5-PO1 M Different election algorithms related to the issue of how processes coordinate their
actions and agree on shared values in distributed systems can be identified,
formulated, reviewed and conclusions can be reached, when we are aware of the
basic requirements.
IT306.5-PO2 H Complexity study of different election algorithms will help in design and
development of solutions for real time computational problems.
IT306.5-PO3 H Study of different election algorithms will help to provide valid conclusions of real
time computational problems.
IT306.5-PO4 M Students will be able to contribute in designing new models for coordinating actions
in distributed systems and provide an implementation of the same.
IT306.5- H Students will acquire skills to design ,analyse and develop election algorithms for
PSO1 coordinating and sharing values between different process
IT306.6-PO1 L The knowledge of basic concepts of distributed shared memory and CORBA services
will help the students to apply the same to formulate solutions for engineering
problems.
IT306.6-PO3 M Complexity study of different consistency models will help in design and
development of solutions for real time computational problems.
GAPES IN THE SYLLABUS - TO MEET INDUSTRY/PROFESSION REQUIREMENTS:

SNO DESCRIPTION PROPOSED
ACTIONS
1 TCP /UDP Socket Examples Seminar
PROPOSED ACTIONS: TOPICS BEYOND SYLLABUS/ASSIGNMENT/INDUSTRY VISIT/GUEST LECTURER/NPTEL ETC
TOPICS BEYOND SYLLABUS/ADVANCED TOPICS/DESIGN:

1 TCP socket Example

2 UDP Socket Example
WEB SOURCE REFERENCES:

1 http://www.brokenthorn.com/Resources/OSDev13.html
2 http://www.osnews.com/story/24405/Hobby_OS-deving_3_Designing_a_Kernel/
3 http://lwn.net/
4 https://www.kernel.org/
5 http://ww5.linuxdrivers.net/
DELIVERY/INSTRUCTIONAL METHODOLOGIES:
 CHALK & TALK  STUD. ASSIGNMENT  WEB RESOURCES
 LCD/SMART BOARDS  STUD. SEMINARS  ADD-ON COURSES
ASSESSMENT METHODOLOGIES-DIRECT
 TESTS/MODEL  UNIV.
 ASSIGNMENTS  STUD. SEMINARS
EXAMS EXAMINATION
 STUD. LAB
☐ STUD. VIVA ☐ MINI/MAJOR PROJECTS ☐ CERTIFICATIONS
PRACTICES
☐ ADD-ON
☐ OTHERS
COURSES
ASSESSMENT METHODOLOGIES-INDIRECT
 ASSESSMENT OF COURSE OUTCOMES (BY  STUDENT FEEDBACK ON
FEEDBACK, ONCE) FACULTY (TWICE)
☐ ASSESSMENT OF MINI/MAJOR PROJECTS BY EXT.

☐ OTHERS
EXPERTS
Prepared by Approved by
Mary John (HOD)

Assignment Topics (2019)
SL NO Assignment Topics Submission Dates
1 Q1: Enhancement and Future 20-02-2019

developments of SUN NFS
Q2: Case study: Global Name Service
2 Q1: Consensus and related Problems 23-03-2019
Q2: Munin and Release consistency
Model
COURSE PLAN
Sl.No Module Planned
1 1 Characterization of Distributed Systems-Introduction-Examples
2 1 Resource Sharing and the Web-Challenges
3 1 system Models-Architectural
4 1 Fundamental
5 1 Inter process Communication-Introduction-API for Internet protocols
6 1 External data representation and marshalling--Client-server communication
7 1 Group communication- Case study: Inter process Communication in UNIX.
8 2 Distributed Objects and Remote Invocation-Introduction- Communication between distributed objects-
9 2 Remote procedure calls- Events and notifications
10 2 Operating System Support
11 2 Operating System Support
12 2 Introduction-OS layer-Protection-
13 2 Processes and threads
14 2 Introduction-OS layer-Protection-Processes and threads

15 2 Communication and invocation OS architecture.
16 2 Communication and invocation OS architecture
17 2 Java RMI
18 3 Distributed File Systems-Introduction-File service architecture
19 3 Sun Network File System
20 3 Name Services
21 3 Name Services and the Domain Name System-Directory Services
22 4 Time and Global States
23 4 Introduction-Clocks, events and process states
24 4 Synchronizing physical clocks
25 4 Synchronizing physical clocks
26 4 Logical time and logical clocks-Global states
27 4 Distributed debugging
28 5 Coordination and Agreement
29 5 Agreement-Introduction-Distributed mutual exclusion
30 5 Elections
31 5 Multicast communication
32 5 Multicast communication
33 6 Distributed Shared Memory
34 6 Introduction-Design and implementation issues
35 6 Sequential consistency and Ivy case study
36 6 Release consistency and Munin case study
37 6 Other consistency models
38 6 CORBA Case Study- Introduction
39 6 CORBA RMI
40 6 CORBA services

HS300
Principles of Management

HS300 : PRINCIPLES OF MANAGEMENT
COURSE INFORMATION SHEET
PROGRAMME: Electrical and Electronics Engineering, DEGREE: B.TECH

Civil Engineering, Computer Science Engineering,
Information Technology and Engineering
COURSE: PRINCIPLES OF MANAGEMENT SEMESTER: 6 CREDITS: 3
COURSE CODE: HS300 COURSE TYPE: CORE
REGULATION: 2018
COURSE AREA/DOMAIN: MANAGEMENT CONTACT HOURS: 3-0-0
CORRESPONDING LAB COURSE CODE (IF ANY): LAB COURSE NAME: NA
NIL
SYLLABUS:
UNIT DETAILS HOURS
Introduction to Management: definitions, managerial roles and functions; Science or
Art perspectives- External environment-global, innovative and entrepreneurial
I perspectives of Management (3 Hrs.)– Managing people and organizations in the context 6
of New Era- Managing for competitive advantage - the Challenges of Management (3
Hrs.)
Early Contributions and Ethics in Management: Scientific Management- contributions

of Taylor, Gilbreths, Human Relations approach-contributions of Mayo, McGregor's
II 6
Theory, Ouchi's Theory Z (3 Hrs.) Systems Approach, the Contingency Approach, the
Mckinsey 7-S Framework Corporate Social responsibility- Managerial Ethics. (3 Hrs)
FIRST INTERNAL EXAM

Planning: Nature and importance of planning, -types of plans (3 Hrs.)- Steps in planning,
III 6
Levels of planning - The Planning Process. – MBO (3 Hrs.)
Organising for decision making: Nature of organizing, organization levels and span of
control in management Organisational design and structure –departmentation, line and staff
IV concepts (3 Hrs.) Limitations of decision making-Evaluation and selecting from 6
alternatives- programmed and non programmed decisions - decision under certainty,
uncertainty and risk-creative process and innovation (3 Hrs.)
SECOND INTERNAL EXAM
Staffing and related HRD Functions: definition, Empowerment, staff – delegation,
decentralization and recentralisation of authority – Effective Organizing and culture-
responsive organizations –Global and entrepreneurial organizing (3 Hrs.) Manager
V 9
inventory chart-matching person with the job-system approach to selection (3 Hrs.) Job
design-skills and personal characteristics needed in managers-selection process, techniques
and instruments (3 Hrs.)
Leading and Controlling: Leading Vs Managing – Trait approach and Contingency
VI 9
approaches to leadership - Dimensions of Leadership (3 Hrs.) - Leadership Behavior and
styles – Transactional and Transformational Leadership (3 Hrs.) Basic control process-

control as a feedback system – Feed Forward Control – Requirements for effective control
– control techniques – Overall controls and preventive controls – Global controlling (3
Hrs.)
TOTAL HOURS 42
T Harold Koontz and Heinz Weihrich, Essentials of Management, McGraw Hill Companies, 10th Edition
T Daft, New era Management, 11th Edition, Cengage Learning
Heinz Weirich, Mark V Cannice and Harold Koontz, Management: a Global, Innovative and
R1
Entrepreneurial Perspective, McGraw Hill Education, 14th Edition
R2 Peter F Drucker, The Practice of Management, McGraw Hill, New York
R3 Robbins and Coulter, Management, 13th Edition, 2016, Pearson Education
R4 I.M .Pandey, Financial Management, Vikas Publishing House. New Delhi
COURSE OBJECTIVES:
To develop ability to critically analyse and evaluate a variety of management practices in the contemporary
1
context
2 To understand and apply a variety of management and organisational theories in practice
To be able to mirror existing practices or to generate their own innovative management competencies
3
required for today's complex and global workplace
To be able to critically reflect on ethical theories and social responsibility ideologies to create sustainable
4
organisations

COURSE OUTCOMES:
COURSE
EXPLANATION
OUTCOME
CO1 To recall and identify the relevance of management concepts
KNOWLEDGE
CO2 To describe, discuss and relate management techniques adopted within an
COMPREHENSION organization
CO3 To apply management techniques for meeting current and future management
APPLICATION challenges faced by the organization
CO4 To compare the management theories and models critically and to inspect and
ANALYSIS question its validity in the real world
CO5 To assess and modify different theories of management so as to relate it to current

SYNTHESIS management challenges
CO6 To apply principles of management in order to execute the role as a manager

EVALUATION
CO-PO MAPPING
PO PO PO PO PO PO PO PO PO PO 10 PO 11 PO 12
1 2 3 4 5 6 7 8 9
CO/PO
CO 1 3 3
CO 2 2 3 3 3 3
CO 3 2 3 3
CO 4 3 3 2 2
CO 5 3 3
CO 6 2 3 3

CO-PO MAPPING (JUSTIFICATION)

CO
/P
PO
O PO 2 PO 3 PO 4 PO 5 PO 6 PO 7 PO 8 PO 9 PO 10 PO 11 PO 12
1
Management is a social
science hence helps to Apply management
CO
apply basic management principles in a team work
1
principles to societal and to manage projects
problems
Management is a social Management principles are

This helps to understand the This enhances the
science hence helps to flexible and adaptable and
CO managerial ethical principles leadership quality of
apply basic management hence it can be used and
2 that has to be followed while students before entering
principles to societal applied in the future course of
monitoring a project into team works
problems action
Management principles are

This enhances the
Apply management flexible and adaptable and
CO leadership quality of
principles in a team work hence it can be used and
3 students before entering
and to manage projects applied in the future course of
into team works
action
Management is a social Management principles are

This helps to understand the This enhances the
science hence helps to flexible and adaptable and
CO managerial ethical principles leadership quality of
apply basic management hence it can be used and
4 that has to be followed while students before entering
principles to societal applied in the future course of
monitoring a project into team works
problems action
Management principles are

Apply management flexible and adaptable and
CO
principles in a team work hence it can be used and
5
and to manage projects applied in the future course of
action
Management is a social
This enhances the
science hence helps to Apply management
CO leadership quality of
apply basic management principles in a team work
6 students before entering
principles to societal and to manage projects
into team works
problems

GAPS IN THE SYLLABUS - TO MEET INDUSTRY/PROFESSION REQUIREMENTS:

PROPOSED
SNO DESCRIPTION
ACTIONS
1 Henry Fayol’s management principles Tutorial classes
2 Financial management NPTEL
3 Human resource management NPTEL
4 Total Quality Management- Quality Circle NPTEL
5. Environmental context of management NPTEL
6 Organizational Communication NPTEL
Proposed Actions: Topics beyond Syllabus/Assignment/Industry Visit/Guest

Lecturer/NptelEtc

1 Managerial competencies
2 Customer management
3 Economics and financial qualitative analysis
4 Operations and technology
5 Building resources in a Start-Up
6 Marketing Tactics
1 www.wto.org
2 www. comtrade.org
3 www.euroasiapub.org/ijrim/june2012/
4 www.startupmission.kerala.gov.in
 CHALK &  STUD. ☐ WEB RESOURCES ☐LCD/SMART
TALK ASSIGNMENT
BOARDS
 STUD. ☐ ADD-ON COURSES  ICT ENABLED
SEMINARS CLASSES
 ASSIGNMENTS  STUD.  TESTS/MODEL  UNIV.
SEMINA EXAMS EXAMINA
RS TION
☐ STUD. LAB ☐ STUD. VIVA ☐ MINI/MAJOR ☐
PRACTICES PROJECTS CERTIFICATIONS
☐ ADD-ON COURSES ☐ OTHERS  GROUP
DISCUSSION(IV)
 ASSESSMENT OF COURSE OUTCOMES  STUDENT FEEDBACK ON
(BY FEEDBACK, ONCE) FACULTY (TWICE)
☐ ASSESSMENT OF MINI/MAJOR PROJECTS BY ☐ OTHERS
EXT. EXPERTS
Prepared by Approved
by LekshmiVijayakumar, Saritha V &Reny Elizabeth Dr. Antony V Varghese
ASSIGNMENT I
TASK: REPORT SUBMISSION AND PRESENTATION
(You may use PPT or any display charts if you want)

 QUESTION: 1. Write a note on Corporate Social Responsibility (CSR)
2. State the objectives of CSR from various literatures
3. State the relevance of CSR
4. Identify two companies who are engaged in CSR.
5. Elaborate how they engage in CSR with proof
6. Write a note on Business Ethics
COURSE PLAN
Sl. Module Planned

no
1 1 Introduction to management
2 1 Functions of management
3 1 Science or art perspective-external environment
4 1 Managing people and organisations in new era
5 1 Competitive advantage-managerial role
6 2 Scientific management taylor, gilbreth
7 2 Ethics in management
8 2 Human relations approach-mayo-mcgregor-ouchisz,system
approach-contingency approach
9 2 7s frame work,csr
10 1 Managerial ethics
11 3 Planning-importance of planning-types of plan
12 3 Steps in planning-levels of planning
13 3 Planning and mbo
14 4 Organizing-nature of organizing
15 4 Organisational levels-span of control
16 4 Organisational design-departmentalization
17 4 Line and staff organisation
18 4 Limitations of decision making evaluating and selecting
alternatives, programmed and non- programmed decision
19 4 Decision under certainty, risk and uncertainty, creative process
and innovation
20 4 Decision making
21 5 Staffing- definition, empowerment delegation, decentralisation,
recentralisation
22 5 Effective organisation and culture, responsive organisation
23 5 Global and entrepreneurial organising

24 1 Manager inventory chart matching person with job system

approach to selection job design
25 5 Skills and personal characteristics needed for a manger,
26 5 Selection process and techniques used in selection
27 6 Leading and controlling in management
28 6 Leading and controlling in management
29 6 Trait and contingency approach in management
30 6 Leadership behaviour and styles- transactional and
transformational controlling- basic control process, control as a
feedback system,
31 6 Feed forward control, requirements for effective control.
Control techniques, overall and preventive controls. Global
controls
32 6 Revision

CS304:
COMPILER DESIGN

CS304:COMPILER DESIGN
COURSE INFORMATION SHEET - 2019
PROGRAMME: INFORMATION DEGREE: BTECH
TECHNOLOGY
COURSE: COMPILER DESIGN SEMESTER: 6 CREDITS: 3
COURSE CODE: CS304 REGULATION: COURSE TYPE: CORE
COURSE AREA/DOMAIN: COMPUTER CONTACT HOURS: 3+0 (Tutorial)

SCIENCE/IT hours/Week.
CORRESPONDING LAB COURSE CODE (IF LAB COURSE NAME:NIL

ANY):NIL
SYLLABUS:
Unit Details Hours
1 Introduction to compilers – Analysis of the source program, Phases of a compiler, 7 hrs
Grouping of phases, compiler writing tools – bootstrapping
Lexical Analysis: The role of Lexical Analyzer, Input Buffering, Specification of
Tokens using Regular Expressions, Review of Finite Automata, Recognition of
Tokens.
2 Syntax Analysis: Review of Context-Free Grammars – Derivation trees and Parse 6 hrs
Trees, Ambiguity.
Top-Down Parsing: Recursive Descent parsing, Predictive parsing, LL(1)
Grammars.
3 Bottom-Up Parsing: Shift Reduce parsing – Operator precedence parsing (Concepts 7 hrs
only)
LR parsing – Constructing SLR parsing tables, Constructing, Canonical LR parsing
tables and Constructing LALR parsing tables.
4 Syntax directed translation: Syntax directed definitions, Bottom- up evaluation of S- 8 hrs
attributed definitions, L- attributed definitions, Top-down translation, Bottom-up
evaluation of inherited attributes.
Type Checking : Type systems, Specification of a simple type checker.
5 Run-Time Environments: Source Language issues, Storage organization, Storage- 7 hrs
allocation strategies.
Intermediate Code Generation (ICG): Intermediate languages – Graphical
representations, Three-Address code, Quadruples, Triples. Assignment statements,
Boolean expressions.
6 Code Optimization:Principal sources of optimization, Optimization of Basic blocks 7 hrs
Code generation: Issues in the design of a code generator. The target machine, A
simple code generator.

Text Books
1. Aho A. Ravi Sethi and D Ullman. Compilers – Principles Techniques and Tools, Addison
Wesley, 2006.
2. D. M.Dhamdhare, System Programming and Operating Systems,Tata McGraw Hill &
Company, 1996.
References
1. Kenneth C. Louden, Compiler Construction – Principles and Practice, Cengage Learning

Indian Edition, 2006.
2. Tremblay and Sorenson, The Theory and Practice of Compiler Writing, Tata McGraw
Hill & Company,1984.
IT 303 Theory of This course introduces the theory of formal languages 5
Computation and automata. The primary focus is on the two methods

of defining languages: using generators (e.g.,
grammars/regular expressions) and using recognizers(e.g.,
finite state machines)
CS 205 Data Structures and This course will introduce fundamental concepts of 3
Algorithms various data structures which are used in different
phases of compilation.
Course Objectives
 To provide a thorough understanding of the internals of Compiler Design.
Expected Outcome
The students will be able to

No Description Blooms
Taxonomy
Level
Explain the concepts and different phases of compilation with compile time Knowledge
1
error handling. (level 1)
Represent language tokens using regular expressions, context free grammar Understand,
2 and finite automata and design lexical analyzer for a language. Analyze(level
2 and 4)
Compare top down with bottom up parsers, and develop appropriate parser Evaluate
3
to produce parse tree representation of the input. (level 5)
Generate intermediate code for statements in high level language. Understand
4
(level 2)
Design syntax directed translation schemes for a given context free Understand,
5 grammar. Analyze(level
2 and 4)
Apply optimization techniques to intermediate code and generate machine Knowledge
6
code for high level language program. (level 1)
CO-PO/PSO Mapping
PO PO PO PO PO PO PO PO PO PO PO PO PSO PSO PSO

1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
CO1 3 1 3 2
CO2 3 2 3 3
CO3 3 3 1 3
CO4 3 2 3 2
CO5 3 3 2 2
CO6 3 2 3 2
JUSTIFICATIONS FOR CO-PO MAPPING
MAPPING LOW/MEDIUM/HIGH JUSTIFICATION

CO1-PO1 H Students will acquire knowledge about phases of
compilation
CO1-PO3 L Students will be able to understand the role of Lexical
Analyzer in Compilation Process
CO1-PO12 H Information acquired from the compilation phases
provides lifelong learning in the context of Compiler
Construction.
CO1-PSO2 M Having the knowledge about the compiler construction
tools helps in the study and design of compiler.
CO2-PO2 H Knowledge of Ambiguities in the context free Grammar
helps students in problem analysis.
CO2-PO3 M Students gain the ability to design syntax analyzer tool
used for compilation process.
CO2-PO4 H Studies about the various parsing techniques helps the
students to understand about Parsing Process.
CO2-PO12 H Students will be able to analyze different parsing
techniques used for Compilation
CO3-PO2 H Studies about the type checking process helps in the
semantic analysis phase of compilation.
CO3-PO3 H Understanding the various storage al location strategies
helps in organization of information in the Run Time
Environment of Compilation.

CO3-PO12 L Information acquired from bottom up and top down

evaluation provides lifelong learning in the compilation
CO3-PSO3 H Students could apply the knowledge of Overloaded and
Polymorphic function used in semantic Analysis Phase of
Compiler.
CO4-PO1 H Students gain the ability to learn about the Intermediate
code generation in compilation process.
CO4-PO2 H Students will understand the need of intermediate
representation for the generation of target code .
CO4-PO12 M The students could understand and implement different
types Intermediate Representation of code used for
generating target code.
CO4-PSO2 M Information acquired from the fundamentals of
intermediate representation leads to implementation of
target code
CO5-PO1 H Students will be obtain basic knowledge of code
optimization
CO5-PO2 H Information acquired from the sources of optimization
helps in implementation of target code
CO5-PO12 M Students could apply the knowledge of code optimization
in Compiler Construction
CO5-PSO2 M Students will be acquiring knowledge about code
improving transformation.
CO6-PO1 H Students will be acquiring knowledge about Instruction
Scheduling
CO6-PO4 M Students will be acquiring knowledge about Register
Allocation
CO6-PO12 H Students will be acquiring knowledge about Instruction
Level Optimization
CO6-PSO3 M Students will be acquiring knowledge about Design
issues in Code Generation for a Target Processor
No Description Proposed Actions

1 Familiarization Lexer and Parser Tools Topic Beyond Syllabus
2 Awareness on Compiler Writing Tools and Techniques Topic Beyond Syllabus
3 Awareness on Computer Architecture for fine tuning Target Topic Beyond Syllabus
Codes
4 Testing the Target Code Generated Topic Beyond Syllabus
1. Familiarization on ANTRL
2. Familiarization on GSL Universal Code Generator
3. Familiarization on Gem5 for Testing Generated Code
WEB SOURCE REFERENCES
1. www.cse.iitd.ernet.in/~sak/courses/cdp/slides.pdf
2. http://iitmweb.iitm.ac.in/phase2/downloads/106108113/

3. http://nptel.ac.in/courses/106108052/
4. www.coursera.org/course/compilers
5. www.wikipedia.org/wiki/Compiler
6. dragonbook.stanford.edu/lecture-notes/Stanford-CS143/03-Lexical-Analysis.pdf
7. dinosaur.compilertools.net/lex/
8. web.cecs.pdx.edu/~harry/compilers/slides/SyntaxPart1.pdf
9. www.engineering.sdstate.edu/~gamradtk/461/chap4p1.
10. www.c4learn.com/semantic-analysis.html
11. www.isi.edu/~pedro/Teaching/CSCI565.../IntermCodeGen.part1.6p
12. en.wikipedia.org/wiki/Optimizing_compiler
☐ CHALK & TALK ☐ STUD. ☐ WEB
ASSIGNMENT RESOURCES
☐ LCD/SMART ☐ STUD. ☐ ADD-ON
BOARDS SEMINARS COURSES
☐ ASSIGNMENTS ☐ STUD. ☐ TESTS/MODEL ☐ UNIV.
SEMINARS EXAMS EXAMINATION
☐ STUD. LAB ☐ STUD. VIVA ☐ MINI/MAJOR ☐
☐ ADD-ON ☐ OTHERS
COURSES
☐ ASSESSMENT OF COURSE OUTCOMES ☐ STUDENT FEEDBACK ON

☐ ASSESSMENT OF MINI/MAJOR ☐ OTHERS
PROJECTS BY EXT. EXPERTS
Binu A HoD
(Faculty)



COURSE PLAN 2019
No Module Topics to be covered

1 1 Introduction to compilers – Analysis of the source program
2 1 Phases of a compiler
3 1 Grouping of phases
4 1 compiler writing tools – bootstrapping
5 1 Lexical Analysis: The role of Lexical Analyzer, Input Buffering
6 1 Specification of Tokens using Regular Expressions
9 1 Review of Finite Automata, Recognition of Tokens
10 1 Review of Finite Automata, Recognition of Tokens
11 2 Syntax Analysis: Review of Context-Free Grammars
12 2 Derivation trees and Parse Trees
13 2 Ambiguity
14 2 Ambiguity
15 2 Top-Down Parsing: Recursive Descent parsing
16 2 Predictive parsing, LL(1) Grammars
17 2 Predictive parsing, LL(1) Grammars
18 3 Bottom-Up Parsing: Shift Reduce parsing
19 3 Operator precedence parsing (Concepts only)
20 3 LR parsing
21 3 Constructing SLR parsing tables
22 3 Constructing SLR parsing tables
23 3 Constructing, Canonical LR parsing tables
24 3 Constructing LALR parsing tables
25 4 Syntax directed translation: Syntax directed definitions
26 4 Bottom- up evaluation of S- attributed definitions
27 4 L- attributed definitions
28 4 Top-down translation
29 4 Bottom-up evaluation of inherited attributes
30 4 Type Checking : Type systems, Specification of a simple type checker
31 5 Run-Time Environments: Source Language issues
32 5 Storage organization
33 5 Storage- allocation strategies

34 5 Intermediate Code Generation (ICG): Intermediate languages

35 5 Graphical representations, Three- Address code, Quadruples, Triples
36 5 Assignment statements, Boolean expressions
37 6 Code Optimization:Principal sources of optimization
38 6 Optimization of Basic blocks
39 6 Code generation: Issues in the design of a code generator.
40 6 The target machine, A simple code generator
41 6 Revision
42 6 Revision

IT 304
DATA WAREHOUSING &

MANAGEMENT

PROGRAMME: Information Technology DEGREE: BTECH
COURSE: Data Warehousing and Mining SEMESTER: S6 CREDITS: 3

COURSE CODE: IT304 COURSE TYPE: CORE/ELECTIVE /
REGULATION: 2015 BREADTH/ S&H
COURSE AREA/DOMAIN: Database CONTACT HOURS: 4 hours/Week.
CORRESPONDING LAB COURSE LAB COURSE NAME:
CODE (IF ANY):
SYLLABUS:
UNIT DETAILS HOURS
Data Mining, Applications, Data Mining Models, Data Warehousing and OLAP, Challengs,
Tools, Data Mining Principles, Data Preprocessing: Data Preprocessing Concepts, Data
Visualization, Data Sets and Their Significance, Classification Models, Multi Resolution
Spatial Data Mining, Classifiers, Association Rules Mining, Cluster Analysis, Practical Data
Mining Tools, Advanced Data Mining Techniques, Web Mining, Text Mining, CRM
Applications and Data Mining, Data warehousing.
Data Mining: Concepts: Concepts, Data Mining Applications, Data Mining
Stages, Data Mining Models, Data Warehousing and OLAP, Need for Data
1 Warehousing, Challenges, Application of Data Mining Principles, Machine 8
Learning and Statistics, Ethics of Data Mining, Popular Tools. OLTP Vs
DWH, Applications of DWH
Data Preprocessing: Data Preprocessing Concepts, Data Cleaning, Handling

2 Missing Data, Data Transformation and Discretization, Data Visualization. 6
UCI Data Sets and Their Significance
FIRST INTERNAL EXAMINATION
3 Classification Models: Introduction to Classification Models, 6

Decision Tree, Neural Networks Floating Point Instructions
4 7
Naive Bayes Classifier, Support Vector Machines. Prediction Models, Issues
regarding classification and prediction.
SECOND INTERNAL EXAMINATION
Association Rules Mining: Concepts, Apriori Algorithm. Cluster Analysis:

5 8
Introduction, Concepts, K-Means Clustering, DensityBased Clustering,
Weighted Graph Partitioning, Hypergraph Partitioning,
Practical Data Mining Tools: Weka, R Package for Data Mining. Advanced Data
Mining Techniques: Introduction, Web Mining- Web Content Mining, Web
6 Structure Mining, Web Usage Mining. Text Mining, CRM Applications and Data 7
Mining, CRM Data Mining Models. Data Warehousing with Oracle BI
TOTAL HOURS 42

T Jaiwei Han, Micheline Kamber, “Data Mining Concepts and Techniques”, Elsevier,
2006.
T M. Sudeep Elayidom, “Data Mining and Warehousing”, 1st Edition, 2015
Cengage Learning India Pvt. Ltd
R Pang-Ning Tan, Michael Steinbach, “Introduction to Data Mining”, Addison
Wesley, 2006.
R Dunham M H, “Data Mining: Introductory and Advanced Topics”, Pearson
Education, New Delhi, 2003
R Mehmed Kantardzic, “Data Mining Concepts, Methods and Algorithms”, John Wiley
and Sons, USA, 2003.
CS 208 Principles of data base design Student will have knowledge of 4
relationaldatabase structure
COURSE OBJECTIVES:
1 To understand Data Mining, its origin, taxonomy and applications
2 To understand types of data and to improve the quality of data and efficiency and the
ease of the mining process.
3 To understand the supervised learning that is Classification, its applications and
approaches.
4 To understand how to identify associations among objects and to learn various
algorithms to find them
5 To learn the unsupervised learning to identify the relation among the objects and to
understand applications and algorithms for Clustering
COURSE OUTCOMES:
Sl No. DESCRIPTION
1 The student will understand the concept of data mining and its applications.
2 To understand various data pre-processing techniques to improve the quality of data

and efficiency and the ease of the mining process.
3 The student will understand the concept of data classification methods
4 The student will understand the concept of association rule mining methods
5 To understand the unsupervised learning techniques and the algorithm used for data
clustering.
6 The student will understand the advanced data mining techniques and the popular data
mining tools used.
CO MAPPING WITH PO, PSO

Programme Outcomes (POs) Programme-

Specific Outcomes
CO (PSOs)
No. 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
1 3 3 3 1 1 2 1 2 1
2 2 2 3 1 1 1 2 2 1
3 3 1 3 1 3 1 1 2 3 2
4 3 2 3 3 1 1 3 3 2
5 3 2 3 1
6 3 1 3 1 3 3 2
JUSTIFICATION FOR CO-PO-PSO CORRELATION:

JUSTIFICATION FOR CO-PO MAPPING
MAPPING LEVEL JUSTIFICATION
IT304.1-PO1 3
Study the concept of data mining and its applications involves solving complex
engineering problems
IT304.1-PO2 3 Principles of mathematics and engineering sciences are used in understanding
various data mining functionalities
IT304.1-PO3 3 Using the knowledge of various data mining functionalities, we can design and
develop solutions for complex engineering problems
IT304.1-PO4 1
Knowledge of various data mining concepts can be used to design and conduct
experiments to provide valid conclusions
IT304.1-PO9 1
Expertise developed, which will enable the student to become a productive
member of a design team
IT304.1-PO12 2
The student will become aware of the need for lifelong learning and the
continued upgrading of technical knowledge
IT304.2-PO1 2 Study of various data pre-processing techniquesto improve the quality of
data involves solving complex engineering problems
IT304.2-PO2 2
Principles of mathematics and engineering sciences are used in various data
pre-processing techniques
IT304.2-PO3 3 Knowledge of various data pre-processing techniques that improve the
efficiency of the mining processcan be used to design and develop
solutions for complex engineering problems.
IT304.2-PO4 1
The knowledge of various data pre-processing techniques can be used to
design and conduct experiments to provide valid conclusions
IT304.2-PO9 1 Expertise developed, which will enable the student to become a productive
IT304.2-PO12 1 The student will become aware of the need for lifelong learning and the
IT304.3-PO1 Study of data classification methods involves solving complex engineering

3
problems

IT304.3-PO2 Principles of mathematics and engineering sciences are used in various aspects
1
of data classification methods
IT304.3-PO3 3 Knowledge of data classification methods can be used to design and develop
solutions for complex engineering problems
IT304.3-PO4 1 The data classification knowledge can be used to design and conduct
experiments to provide valid conclusions
IT304.3-PO6 3 Knowledge of data classification methods will help understand issues and
societal problems related to cybercrimes and computer hacking
IT304.4-PO1 3 The association rule mining methods study involves solving complex
engineering problems
IT304.4-PO2 2 Principles of mathematics and engineering sciences are used to learn the
concept of association rule mining methods.
IT304.4-PO3 3 Knowledge of various association rule mining methods can be used to

design and develop solutions for complex engineering problems
IT304.4-PO4 3 The concept of association rule mining methods can be used to design
and conduct experiments to provide valid conclusions
IT304.5-PO1 3 The study of unsupervised learning techniques involves solving

complex engineering problems
IT304.5-PO2 2 the study of the algorithm used for data clustering involves principles
of mathematics and engineering
IT304.5-PO3 3 The study of unsupervised learning techniques and the algorithm

used for data clustering can be used to design and develop solutions
for complex engineering problems
IT304.5-PO4 3 The knowledge of clustering algorithms can be used to design and

conduct experiments to provide valid conclusions

IT304.6-PO1 3 The knowledge of advanced data mining techniques and the usage of
popular data mining toolsinvolves solving complex engineering
problems
IT304.6-PO2 1 Designof advanced data mining techniques involves principles of

mathematics and engineering
popular data mining tools can be used to design and develop solutions
for complex engineering problems
popular data mining tools can be used to conduct experiments to
solve real world problems to provide valid conclusions
JUSTIFICATION FOR CO-PSO MAPPING

MAPPING LEVEL JUSTIFICATION
IT304.1-PSO1 1 Study the concept of data mining and its applications can Acquire skills to
design, analyse and develop algorithms and implement them using high-
levelprogramming languages.
IT304.1-PSO2 2 Knowledge of data mining concepts and its applications can contribute their
skills in database design and knowledge engineering domain.
IT304.1-PSO3 2 Study the concept of data mining and its applications contribute to Develop
strong skills in developing, testing implementing and providing IT solutions
for different domains which helps in the betterment of life.
IT304.2-PSO1 2 Study of various data pre-processing techniquescan Acquire skills to design,
analyse and develop efficient data mining algorithms.
IT304.2-PSO2 2 Study ofvarious data pre-processing techniques can contribute their
skills in database design and knowledge engineering domain
IT304.2-PSO3 1 Study ofvarious data pre-processing techniques contribute to Develop
IT304.3-PSO1 2
Knowledge of data classification methods can Acquire skills to design, analyse
and develop efficient data mining algorithms
IT304.3-PSO2 3
Knowledge of data classification methods can contribute their skills in
knowledge engineering domain
IT304.3-PSO3 2 Knowledge of data classification methods contribute to Develop strong skills
in developing, testing implementing and providing IT solutions for different
domains which helps in the betterment of life.
IT304.4-PSO1 3 Study of association rule mining methods can Acquire skills to design,
analyse and develop efficient data mining algorithms
IT304.4-PSO2 3 Study of association rule mining methods can contribute their skills in
knowledge engineering domain

IT304.4-PSO3 2 Knowledge of association rule mining methods contribute to Develop

IT304.6-PSO1 3 Study of Advanced data mining concepts and tools acquire skills to
design, analyse and develop algorithms and implement them using
high-level programming languages
IT304.6-PSO2 3 Study of advanced data mining concepts and tools can contribute
their skills in knowledge engineering domain
IT304.6-PSO3 2 Knowledge of advanced data mining concepts and tools develop
strong skills in systematic planning, developing, testing
implementing and providing IT solutions for different domains
which helps in the betterment of life

SNO DESCRIPTION PROPOSED PO MAPPING
ACTIONS
1 Data Warehouse Schemas Assignments and 1, 2, 3, 4, 5, 6
seminars
PROPOSED ACTIONS: TOPICS BEYOND SYLLABUS/ASSIGNMENT/INDUSTRY
VISIT/GUEST LECTURE/NPTEL ETC

S DESCRIPTION PO MAPPING
No:
1 Data Integration and Reduction Techniques 1, 2, 3, 4, 5, 6
DESIGN AND ANALYSIS TOPICS:

Sl. No. DESCRIPTION PO MAPPING
1 ALU Design 1, 2, 3, 4, 5, 9, 10
2 Microarchitecture and Control Unit Design
3 Memory System Design & Analysis

1. https://archive.ics.uci.edu/ml/
2. http://www.saedsayad.com/decision_tree.htm
☑ CHALK & TALK ☑ STUD. ☐WEB RESOURCES
ASSIGNMENT

☑ LCD/SMART ☐ STUD. ☐ ADD-ON

COURSES
BOARDS SEMINARS
☑ ASSIGNMENTS ☑STUD. SEMINARS ☑ TESTS/MODEL ☐ UNIV.
EXAMS EXAMINATION
☐STUD. LAB ☐ STUD. VIVA ☐ MINI/MAJOR ☐
COURSES
☑ ASSESSMENT OF COURSE OUTCOMES ☑ STUDENT FEEDBACK ON
Ms. Saritha S Ms. Saritha S

(Faculty in Charge) (HoD)

Tutorial
Do the following problems using WEKA tool
1. For the table below find the frequent item sets and the association rules with at least 20%
support and 70% confidence
TID ITEMS
11 Bread, Cheese, Juice
12 Bread, Cheese, Coffee, Donut, Juice
13 Biscuit, Bread, Cereal
14 Cereal, Cheese, Chocolate, Donut, Juice
15 Chocolate, Coffee
16 Donut
17 Donut, Egg, Juice
18 Biscuit, Bread, Cheese, Coffee
19 Bread, Cereal, Chocolate, Donut, Juice
20 Cheese, Chocolate, Donut, Juice
21 Milk, Tea, Yogurt
22 Bread, Cereal, Cheese, Coffee
23 Chocolate, Donut, Juice, Milk, Newspaper
24 Newspaper, Pastry, Rolls
25 Rolls, Sugar, Tea

ASSIGNMENT -1
Do the following problems in WEKA tool
1. Build a decision tree classification model for the following data
Name Hair Height Weight Lotion Label

Sarah Blonde Average Light No Sunburned
Dana Blonde Tall Average Yes None
Alex Brown Short Average Yes None
Annie Blonde Short Average No Sunburned
Emily Red Average Heavy No Sunburned
Pete Brown Tall Heavy No None
John Brown Average Heavy No None
Katie Blonde Short Light Yes None
2. Perform Association Rule Mining on weka data set weather.nominal.arff . Answer the following
questions
a. What are the L3 itemsets?
b. What candidates are left after the prune step of the Apriori algorithm?
c. Identify the candidates with minimum support.
ASSIGNMENT -2
Do the following problems in WEKA tool
1. Download the dataset from the following link and built a decision tree classification model
teaching.csse.uwa.edu.au/units/CITS3401/laboratories/data/bank-data.csv
2. Find out how Association Rule Mining can help doctors to identify correlated diseases from the
given dataset.
1. Diabetes, Kidney Infection, High BP

2. Heart Attack, Diabetes, Eye Sight Problem, Kidney Infection
3. High BP, Diabetes, Kidney Function
4. High Cholesterol, Diabetes, Eye Sight Problem, High BP
5. Kidney Infection, Diabetes, Eye Sight Problem, High Cholestrol
6. Eye Sight Problem, Kidney Infection, High BP

COURSE PLAN
Class S6 IT
Subjec IT
t 304
Data Warehousing and Data Mining
Code&
Name
Sl.No Modul Day Planned
e
1 I Day 1 Overview: Data mining Introduction,
2 I Day 2 Applications of data mining, KDD process steps
3 I Day 3 Data Mining Techniques and models
4 I Day 4 Machine Learning and Statistics, Ethics of Data Mining,
5 I Day 5 Major issues/challenges in Data Mining, Popular Tools
6 I Day 6 Data Warehousing and OLAP
7 I Day 7 OLTP Vs DWH, Applications of DWH
8 I Day 8 Data warehouse architecture, DW schemas
Data preprocessing, Need of preprocessing the data, Major Tasks in

9 II Day 9 Data Preprocessing
10 II Day 10 Data Cleaning, Handling Missing Data

11 II Day 11 Data Transformation
12 II Day 12 Data Discretization
13 II Day 13 Data Visualization
14 II Day 14 UCI Data Sets and Their Significance
15 Day 15 Test-1
16 III Day 16 Introduction to Classification Models,
17 III Day 17 Decision Tree

18 III Day 18 Decision Tree: Example
19 III Day 19 Neural Networks
20 III Day 20 Neural Networks: Examples
21 IV Day 21 Naive Bayes Classifier
22 IV Day 22 Support Vector Machines
23 IV Day 23 Prediction Models
24 IV Day 24 Issues regarding classification and prediction.
25 Day 25 Test 2
26 V Day 26 Association rule mining, market basket analysis

Frequent pattern mining algorithm with examples (Apriori
27 V Day 27 algorithm)
28 V Day 28 Cluster Analysis: Introduction, Concepts,
Categorization of Major Clustering Methods – Partitioning
29 V Day 29 Methods: K-means, K-medoids
30 V Day 30 Density‐Based clustering Methods
31 V Day 31 Weighted graph partitioning
32 V Day 32 Hyper graph partitioning

33 V Day 33 Revision Module V
34 VI Day 34 Practical Data Mining Tools: Weka

35 VI Day 35 R Package for Data Mining
36 VI Day 36 Advanced Data Mining Techniques: Introduction, Web Mining

37 VI Day 37 Web Content Mining, Web Structure Mining
38 VI Day 38 Web Usage Mining.
39 VI Day 39 Text Mining,
CRM Applications and Data Mining, CRM Data Mining Models.
40 VI Day 40
41 VI Day 41 Data Warehousing with Oracle BI
42 VI Day 42 Revision Module VI

IT 302
INTERNET TECHNOLOGY

PROGRAMME: INFORMATION TECHNOLOGY DEGREE: BTECH (January 2019– May 2019)
COURSE: INTERNET TECHNOLOGY SEMESTER: VI

COURSE CODE: IT 302 COURSE TYPE: CORE
COURSE AREA/DOMAIN: WEB APPLICATION CONTACT HOURS: 4 hours/Week.
CORRESPONDING LAB COURSE CODE (IF ANY): LAB COURSE NAME: INTERNET TECHNOLOGY
IT 332 LAB
SYLLABUS:
UNIT DETAILS HOURS
I Introduction to Computers and the Internet- Web Basics, Introduction to HTML5
- W3C HTML5 Validation Service, Headings, Linking, Images, Special Characters
and Horizontal Rules, Lists, Tables, Forms, Internal Linking, meta elements, New
HTML5 Form input Types, input and data list elements and autocomplete 6
Attribute, Page-Structure Elements.
II Introduction to Cascading Style Sheets -Inline Styles, Embedded Style Sheets,

Conflicting Styles, Linking External Style Sheets, Positioning Elements - Absolute
Positioning, z-index, Relative Positioning, span, Backgrounds, Element
Dimensions, Box Model and Text Flow, Media Types, Drop-Down Menus
6
III JavaScript: Introduction to Scripting - Control Statements - if Selection

Statement, if…else Selection Statement, while Repetition Statement, for
Repetition Statement, switch Multiple-Selection Statement, do…while
Repetition Statement, break and continue Statements, JavaScript: Functions- 6
Function Definitions, Random Number Generation, JavaScript Global Functions,
JavaScript: Arrays - Declaring, Allocating and Using Arrays, Passing Arrays to
Functions, Sorting Arrays with sort, Searching Arrays with index Of, JavaScript:
Objects: Math, String, Date, Boolean and Number, document Object.
IV Document Object Model (DOM): Modeling a Document: DOM Nodes and Trees,
Traversing and Modifying a DOM Tree, DOM Collections, Dynamic Styles, Using a
Timer and Dynamic Styles to Create Animated Effects, JavaScript Event Handling: 6
load Event, Event mouse move and the event Object, Form Processing with
focus and blur, submit and reset, Event Bubbling
V XML: Introduction, XML Basics, Structuring Data, XML Namespaces, Document

Type Definitions (DTDs), W3C XML Schema Documents, XML Vocabularies:
MathML, Extensible Style sheet Language and XSL Transformations, Document
Object Model (DOM). Ajax-Enabled Rich Internet Applications with XML and 9
JSON: Introduction, Rich Internet Applications (RIAs) with Ajax, Using XML and
the DOM , Creating a Full-Scale Ajax-Enabled Application
VI Web Servers: Introduction, HTTP Transactions, Multitier Application 9

Architecture, Client-Side Scripting versus Server-Side Scripting, Accessing
Web Servers.

Server Side Programming with PHP - Introduction, converting Between Data

Types, Arithmetic Operators, Initializing and Manipulating Arrays, String
Comparisons, String Processing with Regular Expressions, Form Processing
and Business Logic, Using PHP to Process HTML5 Forms, Accessing
MySQL Database with PHP, Using Cookies, Dynamic Content
TOTAL HOURS 60
1 Robert W Sebesta, Programming with World Wide Web , 7th ed., Pearson Education ,New Delhi, 2009
2 Deitel & Deitel Internet & World Wide Web How To Program 4th ed., Pearson International Edition
Education ,New Delhi, 2009
3 Bob Boiko, Content Management Bible, 2nd Edition, Wiley Publishers. [Chapter 1, 2]
4 Chris Bates, Web Programming Building Internet Applications, 3/e, Wiley India Edition 2009.
5 Bear Bibeault and Yehuda Katz, jQuery in Action, Second Edition, Manning Publications.[Chapter 1] Black
Book, Kogent Learning Solutions Inc. 2009
6 Dream Tech, Web Technologies: HTML, JS, PHP, Java, JSP, ASP.NET, XML, AJAX,
9 Jeffrey C Jackson, Web Technologies A Computer Science Perspective, Pearson Education Inc. 2009.
IT 307 COMPUTER NETWORKS Basic awareness of network communication V
COURSE OBJECTIVES:
1 To impart the basics of web page design
2 To understand important components of HTML5 documents and use HTML5 to create web
pages
3 To learn to use JavaScript in WebPages to enhance the functionality and appearance of web
pages
4 To know XML schema and transformation
5 To design dynamic web pages using PHP
COURSE OUTCOMES:
Blooms’
Sl No DESCRIPTION
Taxonomy Level
Understand
C01 Graduate will be able to summarize the basic tags and properties in HTML and CSS.
(Level 2)
C02 Evaluate
Graduate will be able to select HTML tags and CSS properties to design web pages.
(Level 5)
C03 Graduates will be able to prepare XML documents to store and transport data. Apply
(Level 3)
Apply
C04 Graduates will be able to write programs in PHP.
(Level 3)
Graduates will be able to develop web applications using Knowledge
C05
Javascript and PHP. (Level 1)

PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2 PSO3
C01 1 _ 2 _ _ _ _ _ _ _ _ _ 2 _ _
C02 _ 2 3 2 _ _ _ _ _ _ _ _ _ _ 2
C03 _ 2 2 _ _ _ _ _ _ _ _ _ 1 _ 2
C04 1 2 3 2 _ _ _ _ _ _ _ _ 2 2 _
C05 - _ 3 _ _ _ _ _ _ _ _ _ 3 _ _

C01-PO1 L Graduate attains a basic knowledge about XHTML and its tags.
C01-PO3 H Graduate is equipped to use XHTML tags for design of a static web page
and forms.
C01-PSO1 M Graduate is made able to identify the core principles of basic web page
creation.
C02-PO2 M Graduate is made capable of identifying the basic suitable tags and CSS
styles to design web pages.
C02-PO3 H Graduate is able to design simple and creative web pages.
C02-PO4 M Graduate is able to apply CSS properties to basic tags in XHTML.
C0.2-PSO3 M Graduate is able to use XHTML and CSS for developing innovative web
pages.
C03-PO2 M Graduate will be able to create XML documents to store and maintain data.
C03-PO3 M Graduates are able to create DTDs to design the structure of XML
documents.
C03-PSO1 L Graduate attains a basic knowledge on XML schemas and their need in
XML.
C03-PSO3 M Graduate attains information on basic structure of XML documents which
can be used for creating XML documents.
C04-PO1 L Graduate achieves a basic insight on PHP programming languages.
C04-PO2 M Graduate is able to analyze a problem and write solutions using PHP.
C04-PO3 H Graduate is able to develop solutions to complex problems using the given
programming languages.
C04-PO4 M Graduates achieves knowledge on writing PHP programs
C04-PSO1 M Graduates achieves knowledge on writing PHP programs
C04-PSO2 M Graduates achieves knowledge on writing PHP programs
C05-PO3 H Graduate is made able to develop web pages using javascipt and PHP.

1 www.w3schools.com/
2 www.w3.org/
3 www.htmldog.com / Tutorials/ HTML
4 www.validator.w3.org/
5 www.php.net/manual/en/index.php
6 httpd.apache.org/download.cgi
7 https://alistapart.com/article/frameworks
8 http://getbootstrap.com/css/
9 https://www.w3.org/TR/WD-DOM/introduction.html

 CHALK & TALK  STUD.  WEB RESOURCES
ASSIGNMENT
 LCD/SMART STUD. SEMINARS  ADD-ON COURSES
BOARDS
 ASSIGNMENTS STUD. SEMINARS  TESTS/MODEL  UNIV.
EXAMS EXAMINATION
STUD. LAB STUD. VIVA MINI/MAJOR CERTIFICATIONS
PRACTICES PROJECTS
ADD-ON COURSES OTHERS
 ASSESSMENT OF COURSE OUTCOMES (BY  STUDENT FEEDBACK ON FACULTY
FEEDBACK, ONCE) (TWICE)
ASSESSMENT OF MINI/MAJOR PROJECTS BY EXT. OTHERS
EXPERTS
Ms. Divya James Saritha S
(Faculty) (H.O.D)
IT302: Internet Technology
Course Plan
Day Topic
1. Module-1 : Introduction
Introduction to Computers and the Internet, Web Basics
2. Introduction to HTML5 - W3C HTML5 Validation Service, Headings
3. Linking, Images, Special Characters and Horizontal Rules,
4. Lists,Tables, Forms, Internal Linking, meta elements,
5. New HTML5 Form input Types, input and data list elements and
autocomplete Attribute
6. Page-Structure Elements.
7. Module-1 : Revision class
8. Module-1 : Class Test
9. Module-2 :Introduction to Cascading Style Sheets

Inline Styles, Embedded Style Sheets

10. Conflicting Styles, Linking External Style Sheets
11. Positioning Elements - Absolute Positioning, z-index
12. Relative Positioning, span, Backgrounds
13. Element Dimensions, Box Model and Text Flow
14. Media Types, Drop-Down Menus
17. First Internal Examination
18. Module-3 :JavaScript: Introduction to Scripting
Control Statements - if Selection Statement,
if else Selection Statement
19. while Repetition Statement, for Repetition Statement, switch Multiple-
Selection Statement,
20. do...while Repetition Statement, break and continue Statements,
21. JavaScript: Functions-
Function Definitions, Random Number Generation,
JavaScript Global Functions,
22. JavaScript: Arrays - Declaring, Allocating and Using Arrays,
Passing Arrays to Functions,
23. Sorting Arrays with sort, Searching Arrays with index Of
24. JavaScript: Objects: Math, String, Date, Boolean and Number,
document Object
26. Module-4 :Document Object Model (DOM):
Modeling a Document: DOM Nodes and Trees
27. Traversing and Modifying a DOM Tree
28. DOM Collections, Dynamic Styles
29. Using a Timer and Dynamic Styles to Create Animated Effects
30. JavaScript Event Handling: load Event, Event mouse move and
the event Object
31. Form Processing with focus and blur
32. submit and reset, Event Bubbling Assignment -II
35. Second Internal Examination
36. Module-5 : XML: Introduction
XML Basics,
37. Structuring Data,XML Namespaces,
38. Document Type Definitions (DTDs),
39. W3C XML Schema Documents, XML Vocabularies: MathML,
40. Extensible Style sheet Language and XSL Transformations,
Document Object Model (DOM).
41. Ajax-Enabled Rich Internet Applications with XML and JSON:
Introduction
42. Rich Internet Applications (RIAs) with Ajax
43. Using XML and the DOM
44. Creating a Full-Scale Ajax-Enabled Application
47. Module-6 : Web Servers: Introduction
HTTP Transactions
48. Multitier Application Architecture
49. Client-Side Scripting versus Server-Side Scripting,
Accessing Web Servers.

50. Server Side Programming with PHP:

Introduction, converting Between Data Types, Arithmetic Operators
51. Initializing and Manipulating Arrays, String Comparisons
52. String Processing with Regular Expressions, Form Processing and
Business Logic
53. Using PHP to Process HTML5 Forms
54. Accessing MySQL Database with PHP
55. Using Cookies, Dynamic Content
IT 302 Internet Technology
Assignment 1
1. Write an HTML5 document that produces the table shown in Fig:
2. (Website Registration Form with Optional Survey)

Create a website registration form to obtain a user’s first name, last name and e-mail
address. In addition, include an optional survey question that asks the user’s year in
college (e.g., Freshman). Place the optional survey question in a details element that the
user can expand to see the question.
3. Write a CSS rule that makes all text 1.5 times larger than the base font of the system and
colors the text red.
Write a CSS rule that places a background image halfway down the page, tiling it horizontally.
The image should remain in place when the user scrolls up or down.
4. Make a navigation button using a div with a link inside it. Give it a border, background,
and text color, and make them change when the user hovers the mouse over the button.
Use an external style sheet.

Assignment 2
1. Design an XML page to store news.Write a program to parse the xml document and display the
content of the xml file in an HTML file as given in the following specification. Use XSLT.
Title of the Website
News Head Line Category (Category as a superscript)
Place : First 20 characters of news content. After that More Link
Author
Date
2. Design an XML document to store information about a student in an engineering college. The
information must include USN, Name, Name of the College, Branch, Year of Joining, and e-
mail id. Make up sample data for 3 students. Develop a program to parse an xml document and
display the contents of the xml file in an html file using XSLT.

IT362
INFORMATION
RETREIVAL


PROGRAMME: INFORMATION TECHNOLOGY DEGREE: B.TECH
COURSE: Information Retrieval SEMESTER: VI CREDITS: 3
COURSE CODE: IT362 REGULATION: 2017 COURSE TYPE: Elective
COURSE AREA/DOMAIN: DATA MINING CONTACT HOURS: 3 hours/Week
CORRESPONDING LAB COURSE CODE (IF ANY): NIL LAB COURSE NAME: NA
SYLLABUS:
UNIT DETAILS HOURS
Introduction – Information versus Data Retrieval. Modeling of Information retrieval.
I Boolean Model, Vector Model, Probabilistic Model, Set Theoretical Models, Structured 7
Text Retrieval Models.
Classification, Measures of Association, Cluster Hypothesis, Single Link Clusters, File
II Structures, Inverted Files, Index Sequential Files, Ring Structures, Doubly Chained Trees, 7
Hash Addressing.
III Evaluation, Relevance, Precision and Recall, Interpolation, Averaging techniques, The
7
Swets Model.
IV Search Engines, Boolean Search, Matching Functions, Serial Search, Cluster
7
Representatives, Cluster based retrieval.
Web search basics – Web characteristics - crawling and indexes – Features of a crawler –
V Crawler architecture – DNS resolution – The URL frontier – Distributing indexes – 7
Connectivity servers.
VI Link Analysis – The Web as a graph – Anchor text and the web graph, Page Rank –
7
Markov chains, Page Rank computation, Topic-specific Page Rank, Hubs and authorities.
TOTAL HOURS 42
T C. Manning, P. Raghavan, and H. Schütze, “Introduction to Information Retrieval”, Cambridge
University Press, 2008.
T C.J. Van Rijsbergen , Information Retrieval:, http://www.dcs.gla.ac.uk/Keith/Preface.html
T Ricardo Baexa-Yates and Berthier Ribeiro-Neto, “Modern Information Retrieval”, Addison Wesley
Longman, 1999.
R Bruce Croft, Donald Metzler and Trevor Strohman, “Search Engines: Information Retrieval in Practice”,
1st Edition Addison Wesley, 2009.
R Manu Konchady, “Building Search Applications: Lucene, Ling Pipe”, First Edition, Gate Mustru
Publishing, 2008.
R Mark Levene, “An Introduction to Search Engines and Web Navigation”, 2nd Edition Wiley, 2010.
R Ophir Frieder, “Information Retrieval: Algorithms and Heuristics: The Information Retrieval Series”,
2nd Edition, Springer, 2004.
R Stefan Buettcher, Charles L. A. Clarke, Gordon V. Cormack, “Information Retrieval: Implementing and
Evaluating Search Engines”, The MIT Press, 2010.
C.CODE COURSE NAME SEM
CS205 Data structures 3
COURSE OBJECTIVES:
1 To provide with foundation knowledge in information retrieval.
2 To equip with sound skills to solve computational search problems.
COURSE OUTCOMES:
Blooms’
SNO DESCRIPTION
Taxonomy Level

Students will be able to understand the basics of IR and describe various Knowledge
1
models in information retrieval. (Level1)
2 Students will be able to apply IR principles to locate relevant information large Apply (Level 3)
collections of data.
Students will be able to analyze performance of retrieval systems when dealing Analyze
3
with unmanaged data sources. (Level 4)
Create
4 Students will be able to design retrieval systems for web search tasks.
(Level 6)
Students will be able to evaluate and use different information retrieval Evaluate, Apply
5
techniques in various application areas. (Level 5, Level 3)
Understand
6 Students will be able to summarize the concepts of link analysis.
(Level 2)
PO PO PO PO PO PO PO PO PO PO PO PO PSO PSO PSO

1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
IT362.1 2 2 _ _ _ _ _ _ _ _ _ _ 3 2 _
IT362.2 _ _ 2 2 _ _ _ _ _ _ _ _ _ 2 _
IT362.3 _ _ _ _ 2 _ _ _ _ _ _ _ _ _ 2
IT362.4 2 2 2 _ _ _ _ _ _ _ _ _ _ 2 _
IT362.5 2 2 2 2 2 _ _ _ _ _ _ _ _ _ 2
IT362.6 2 2 2 _ 2 _ _ _ _ _ _ _ _ 2 _
IT362 2 2 2 2 2 _ _ _ _ _ _ _ 3 2 2

Learning different information retrieval models enable students to
IT362.1-PO1 M apply engineering fundamentals and mathematics in information
retrieval problems.
Students acquire skills to choose appropriate models for
IT362.1-PO2 M
information retrieval and analyze complex retrieval problems.
Students will be able to contribute their skills in information
IT362.1-PSO1 H
retrieval by learning the fundamental concepts.
Students will be able to contribute their engineering skills in
IT362.1-PSO2 M
knowledge engineering.
Students will be able to design solutions for fast and efficient
IT362.2-PO3 M
retrieval systems which in turn help society.
Conduct investigations for solving complex retrieval problems to
IT362.2-PO4 M
achieve high accuracy.
Apply engineering skills to use the appropriate file structures and
IT362.2-PSO2 M
methods that could help in quick and accurate retrieval process.
Apply appropriate techniques and modern engineering and IT tools
IT362.3-PO5 M
including prediction and modeling to complex retrieval problems.
Able to develop strong skills for testing and evaluating different
IT362.3-PSO3 M
retrieval processes based on accuracy and speed.
Apply fundamentals of engineering and mathematics for designing
IT362.4-PO1 M
retrieval systems for web search tasks.

Students will be able to identify, formulate, review research

literature and analyze complex retrieval problems reaching
IT362.4-PO2 M
substantiated conclusions using first principles of mathematics,
natural sciences, and engineering sciences.
Students will be able to design complex retrieval systems in
IT362.4-PO3 M
accordance with the growing demand of public.
Acquire skills to design, analyse and develop efficient retrieval
IT362.4-PSO1 M algorithms and implement those using high-level programming
languages.
Students will be able to evaluate and use different information
IT362.5-PO1 M retrieval techniques in various application areas applying
fundamentals of engineering and mathematics.
Students will be able to analyze existing problems in retrieval
IT362.5-PO2 M
systems and compare the pros and cons of existing systems.
Students will be able to solve problems in existing retrieval
IT362.5-PO3 M
systems and use them in different application areas.
Students will be able to conduct detailed study on existing systems
IT362.5-PO4 M
and bring out scope for improvement in those systems.
Students could apply modern tools and techniques for developing
IT362.5-PO5 M fast and accurate retrieval systems which can be used for different
applications.
Develop strong skills in systematic planning, developing, testing
IT362.5-PSO3 M implementing and providing solutions for different retrieval tasks
which in turn helps society.
Students will be able to apply basic engineering knowledge in link
IT362.6-PO1 M
analysis.
IT362.6-PO2 M Students will be able to analyze existing problems in link analysis.
Design solutions for complex link analysis problems and design
IT362.6-PO3 M system solutions that meet the specified needs with appropriate
consideration for the society.
Students will be able to apply modern tools and techniques for
IT362.6-PO5 M
solving link analysis problems.
Students will be able to contribute their engineering skills in
IT362.6-PSO2 M solving link analysis problems which have tremendous scope in the
upcoming information oriented future.
PROPOSED
SNO DESCRIPTION
ACTIONS
1 Suffix tree and Suffix arrays ASSIGNMENT
PROPOSED ACTIONS: TOPICS BEYOND SYLLABUS/ASSIGNMENT/INDUSTRY VISIT/GUEST
LECTURER/NPTEL ETC

1 Multimedia-IR
2 Multilingual IR


1 http://people.ischool.berkeley.edu/~hearst/irbook/
2 http://singhal.info/ieee2001.pdf
3 http://www.dcs.gla.ac.uk/Keith/Preface.html
4 http://www-nlp.stanford.edu/IR-book/
5 http://rakaposhi.eas.asu.edu/cse494/
☐ CHALK & TALK ☐ STUD. ASSIGNMENT ☐ WEB RESOURCES
☐ LCD/SMART BOARDS ☐ STUD. SEMINARS ☐ ADD-ON COURSES
☐ ASSIGNMENTS ☐ STUD. SEMINARS ☐ TESTS/MODEL ☐ UNIV. EXAMINATION
EXAMS
☐ STUD. LAB ☐ STUD. VIVA ☐ MINI/MAJOR ☐ CERTIFICATIONS
PRACTICES PROJECTS
☐ ADD-ON COURSES ☐ OTHERS
☐ ASSESSMENT OF COURSE OUTCOMES (BY ☐ STUDENT FEEDBACK ON FACULTY (TWICE)
FEEDBACK, ONCE)
☐ ASSESSMENT OF MINI/MAJOR PROJECTS BY EXT. ☐ OTHERS
EXPERTS
Prepared by Approved
byLakshmi K.S Saritha S
(Faculty) (HOD)
Course Plan
Planned
SI. No Module Planned
Day
1 1 Day 1 Introduction: Information versus Data Retrieval
2 1 Day 2 Modeling of Information retrieval
3 1 Day 3 Boolean Model

4 1 Day 4 Vector Model
5 1 Day 5 Probabilistic Model
6 1 Day 6 Set Theoretical Models
7 1 Day 7 Structured Text Retrieval Models
8 2 Day 8 Classification, Measures of Association
9 2 Day 9 Cluster Hypothesis, Single Link Clusters
10 2 Day 10 File Structures, Inverted Files
11 2 Day 11 Index Sequential Files

12 2 Day 12 Ring Structures

13 2 Day 13 Doubly Chained Trees
14 2 Day 14 Hash Addressing
15 3 Day 15 Evaluation
16 3 Day 16 Relevance
17 3 Day 17 Precision and Recall
18 3 Day 18 Interpolation
19 3 Day 19 Averaging techniques
20 3 Day 20 The Swets Model
21 4 Day 21 Search Engines
22 4 Day 22 Boolean Search
23 4 Day 23 Matching Functions
24 4 Day 24 Serial Search
25 4 Day 25 Cluster Representatives
26 4 Day 26 Cluster based retrieval
27 5 Day 27 Web search basics – Web characteristics
28 5 Day 28 Crawling and indexes
29 5 Day 29 Features of a crawler
30 5 Day 30 Crawler architecture
31 5 Day 31 DNS resolution
32 5 Day 32 The URL frontier
33 5 Day 33 Distributing indexes
34 5 Day 34 Connectivity servers
35 6 Day 35 Link Analysis – The Web as a graph
36 6 Day 36 Anchor text and the web graph
37 6 Day 37 Page Rank – Markov chains
38 6 Day 38 Page Rank computation
39 6 Day 39 Topic-specific Page Rank
40 6 Day 40 Hubs and authorities
41 5 Day 41 Revision
42 6 Day 42 Revision

ASSIGNMENT
ASSIGNMENT NO: 1
1. Explain in detail about the Swets Model.
ASSIGNMENT NO: 2
1. Briefly explain the following:

a) Suffix Tree
b) Suffix Array
c) Multi-lingual IR
d) Multimedia IR
2. Using an example, explain how suffix tree is converted to a suffix array.

IT 364
SOFTWARE PROJECT
MANAGEMENT

PROGRAMME: INFORMATION TECHNOLOGY DEGREE: BTECH

COURSE: SOFTWARE PROJECT MANAGEMENT SEMESTER: VI CREDITS: 3
COURSE CODE: IT 364 COURSE TYPE: ELECTIVE

REGULATION: 2019
COURSE AREA/DOMAIN: SOFTWARE CONTACT HOURS: 3 hours/Week.
DEVELOPMENT
SYLLABUS:
UNIT DETAILS HOURS
Introduction to software engineering- scope of software engineering, historical aspects,
economic aspects, maintenance aspects, specification and design aspects, team
programming aspects. Layered technology, processes, methods and tools. Phases in
I Software development 7
Process models- prescriptive process models- waterfall model, incremental models,
evolutionary models, and concurrent models. Specialised process models- component based
development, formal methods model, aspect oriented software development. The unified
process, personal and team process models.
Agile development- agility, agile process. Extreme programming- XP Values, The XP
Process, Industrial XP, The XP Debate. Agile development models- Adaptive Software
Development (ASD), Scrum, Dynamic Systems Development Method (DSDM),
Crystal, Feature Driven Development (FDD), Lean Software Development (LSD),
II Agile Modeling (AM) , Agile Unified Process (AUP). 7
Project management concepts- the management spectrum, people, product, process,

and project.
Process and project metrics- software measurement- size oriented, function oriented,
LOC and function point, metrics for software quality- measuring quality, defect
III removal efficiency, integrating metrics within the software process. 7
Estimation for software projects- project planning, software scope, resources. Software project
estimation, decomposition techniques- Software Sizing, Problem-Based Estimation, Process-
Based Estimation.
Empirical estimation models- structure of estimation models, COCOMO II model.
Estimation for agile development. Make/buy decision.
IV Project scheduling- relationship between people and effort, effort distribution. Task set, 7
defining a task network. Scheduling- timeline chart, tracking the schedule. Earned value
analysis.
Risk management- risk strategies, software risks, risk identification, risk projection, risk
refinement, Risk Mitigation, Monitoring, and Management. The RMMM Plan.
Software Configuration Management - An SCM Scenario, Elements of a Configuration
V Management System, Baselines, Software Configuration Items. The SCM Repository - The 8
Role of the repository, General Features and Content, SCM Features. The SCM Process-
Identification of Objects in the Software Configuration, Version Control, Change Control,
and Configuration Audit, Status Reporting
Software quality assurance- Background Issues, Elements of Software Quality Assurance.
SQA Tasks, Goals, and Metrics. Formal Approaches to SQA. Statistical Software Quality
Assurance- A Generic Example, Six Sigma for Software Engineering. Software Reliability -
Measures of Reliability and Availability, Software Safety. The ISO 9000 Quality Standards.
VI The SQA Plan. 6
Software process improvement- Approaches to SPI, Maturity Models. The SPI Process-
Assessment and Gap Analysis, Education and Training, Selection and Justification,
Installation/Migration, Evaluation, Risk Management for SPI, Critical Success Factors. The
CMMI, The People CMM. Other SPI Frameworks. SPI Return on Investment. SPI trends.

TOTAL HOURS 54
1. Roger S. Pressman, Software Engineering, 8/e, McGraw Hill, 2014.
2. Ian Sommervile, Software Engineering, 7/e, University of Lancastor, Pearson Education,
2004.
R 3. Bob Huges, Mike Cotterell, Rajib Mall, Software Project Management, 8/e, McGraw Hill,
2015.
4. Walker Royce, Software Project Management : A Unified Frame Work, Pearson
Education.
IT 306 Software Architecture and Design Detailed study of software development models S4
COURSE OBJECTIVES:
1 To develop awareness regarding the theoretical and methodological issues related to software
project management.
2 To develop software projects based on current technologies.
COURSE OUTCOME:
SNO DESCRIPTION Blooms’ Taxonomy Level
C364.1 Identify the theoretical and methodological issues involved in modern Knowledge (Level 1)
software engineering project management Understand (Level 2)
C364.2 Develop the transferable skills in logical analysis, communication and Apply (Level 3)
project management necessary for working within a team.
C364.3 Translate a specification to a design, and identify the components to build Knowledge (Level 1)
the architecture for a given problem, using an appropriate software Understand (Level 2)
engineering methodology. Apply (Level 3)
C364.4 Select and use project management frameworks that ensure successful Analyze(Level 4)
outcomes. Evaluate (Level 5)
C364.5 Develop software projects based on current technologies, by managing Apply (Level 3)
resources economically and keeping ethical values.

PO P PO PO PO PO PO PO PO PO PO PO PSO PSO PSO
1 O2 3 4 5 6 7 8 9 10 11 12 1 2 3
CO.1 3 2 1
CO.2 3 2 2 2
CO.3 2 2 2 1 1 3 2
CO.4 2 2 2 2 3 2
CO.5 2 2 2 1 1 3 2

The knowledge of theoretical and methodological issues involved in
CO.1-PO1 H modern software engineering project management helps the students to
solve complex engineering problems.
Helps to identify the theoretical and methodological issues involved in
CO.1-PO2 M
modern software engineering project management
CO.1-PSO1 L Allows the students to design solutions for complex engineering
problems processes that meet the specified needs with appropriate

consideration for the public health and safety, and the cultural, societal,
and environmental considerations.
CO.2-PO1 H They can apply this knowledge for working in a team to solve complex
engineering problems,
Developing the transferable skills in logical analysis, communication and
CO.2-PO2 M project helps to identify formulate and analyze complex engineering
problems.
By working as a team helps to solve problems that meet the specified
CO.2-PO3 M needs with appropriate consideration for the public health and safety,
and the cultural, societal, and environmental considerations.
Develop the transferable skills in logical analysis, communication and
CO.2-PSO1 M
project management necessary for working within a team.
Helps to translate a specification to a design, and identify the components
CO.3-PO1 M
to build the architecture for a given problem.
Able to design, and identify the components to build the architecture for
CO.3-PO2 M a given problem, using an appropriate software engineering
methodology.
By designing the components to build the architecture for a given
problem, using an appropriate software engineering methodology helps
CO.3-PO3 M
to meet specified needs with appropriate consideration for the public
health and safety
Knowledge on software engineering methodology helps to develop
CO.3-PO4 L
applications to solve complex engineering problems
Allows creating, selecting, and applying appropriate techniques,
CO.3-PO5 L
resources, tools to build the architecture for a given problem.
Helps to identify the components to design and implement the
CO.3-PSO1 H
architecture for a given problem.
Allow to contribute their designing skills in information engineering
CO.3-PSO2 M
domains.
Knowledge on project management frameworks that ensure successful
CO.4-PO1 M
outcomes helps to solve complex engineering problems.
Helps to select and use project management frameworks to identify,
CO.4-PO2 M
formulate and analyze complex engineering problems.
Allow to select appropriate framework to solve complex problems that
CO.4-PO3 M the specified needs with appropriate consideration for the public health
and safety, and the cultural, societal, and environmental considerations.
Knowledge on project management frameworks that ensure successful
CO.4-PO4 M
outcomes helps to conduct investigations of complex problems.
Students acquire the ability to select and use project management
CO.4-PSO1 H
frameworks that ensure successful outcomes.
Able to contribute their skills in selecting project management
CO.4-PSO2 M frameworks that ensure successful outcomes in information
engineering domains.
Students will be able to develop software projects based on current
CO.5-PO5 M technologies by applying appropriate techniques, resources and IT
tools.
Students will be able to develop software projects based on current
CO.5-PO6 M technologies, by managing resources economically and keeping
ethical values.
Students will be able to understand the impact of professional
CO.5-PO7 M
engineering solutions in societal and environmental contexts.
This gives an understanding of management principles as a member
CO.5-PO11 L
and leader in a team to manage projects.
Students gain the ability to engage in independent and lifelong
CO.5-PO12 L
learning in the broadest context of technological change.
CO.5-PSO1 H Students will acquire the skills to design and develop software

projects based on current technologies, by managing resources

economically and keeping ethical values.
Students will be able to contribute their development skills in
CO.5-PSO2 M
computing and information engineering domains.

Si DESCRIPTION PROPOSED RELEVANCE RELEVANCE
NO ACTIONS WITH POs WITH PSOs
1 Familiarization of management tools LAB/SEMINAR 2,3,5 2
PROPOSED ACTIONS: TOPICS BEYOND SYLLABUS/ASSIGNMENT/INDUSTRY VISIT/GUEST LECTURER/NPTEL
ETC

Si DESCRIPTION PROPOSED RELEVANCE RELEVANCE
NO ACTIONS WITH POs WITH PSOs
1 Familiarization of change TOPIC BEYOND 2,3 1
management SYLLABUS

1 http://www.nptel.iitm.ac.in/courses/Webcourse-contents/IIT%20Kharagpur/Soft%20Engg/New_index1.html
2 http://www.cl.cam.ac.uk/~lp15/papers/Notes/SE-I.pdf
3 http://www2.imm.dtu.dk/courses/02161/2012/slides/week01ln.pdf
4 http://www.dcs.ed.ac.uk/teaching/cs1/CS1/Ah/Notes/IntroSoftwareEng.pdf
5 https://msdn.microsoft.com
 CHALK & TALK  STUD. ASSIGNMENT  WEB RESOURCES
 LCD/SMART BOARDS  STUD. SEMINARS ☐ ADD-ON COURSES
  STUD.  TESTS/MODEL  UNIV.
ASSIGNMENT SEMINARS EXAMS EXAMINATIO
S N
 STUD. LAB STUD. VIVA ☐ MINI/MAJOR ☐ CERTIFICATIONS
PRACTICES PROJECTS
COURSES
☐ ASSESSMENT OF MINI/MAJOR PROJECTS ☐ OTHERS
BY EXT. EXPERTS
Prepared by Approved b
Abey Abraham Ms. Saritha S,

HOD

RAJAGIRI SCHOOL OF ENGINEERING & TECHNOLOGY

Department of Information Technology
ASSIGNMENT QUESTIONS – JAN –JUNE 2019
Assignment 1
1. Agile Development Models
Assignment 2
1. SPI Frameworks. SPI Return on Investment. SPI trends.
IT 364 SOFTWARE PROJECT MANAGEMENT

Course Plan - Jan 2019
Day Module Topic

Day 1 Introduction to SE
Day 2 Layered Technology
Day 3 Phases in Software Development
Day 4 Prescriptive Process Models
I
Day 5 Incremental Process Models
Day 6 Evolutionary models
Day 7 Specialised process models
Day 8 The unified process
Day 9 Agile development
Day 10 Extreme programming
Day 11 ASD, Scrum, DSDM
II
Day 12 Crystal, FDD, LSD, AM
Day 13 Agile Unified Process
Day 14 Project management concepts
Day 15 Process and project metrics-
Day 16 Metrics for software quality
Day 17 III Integrating metrics within the software process.
Day 18 Estimation for software projects-
Day 19 Software project estimation

Day 20 Decomposition techniques

Day 21 Empirical estimation models
Day 22 Estimation for agile development
Day 23 Project scheduling
IV
Day 24 Task set, defining a task network
Day 25 Scheduling
Day 26 Earned value analysis.
Day 27 Risk management
Day 28 The RMMM Plan.
Day 29 V Software Configuration Management
Day 30 The SCM Repository
Day 31 The SCM Process-
Day 32 Software quality assurance
Day 33 Formal Approaches to SQA
Day 34 Software Reliability
Day 35 VI The SQA Plan.
Day 36 Software process improvement
Day 37 Risk Management for SPI
Day 38 The CMMI,

IT 332:
INTERNET TECHNOLOGY
LAB

PROGRAMME: INFORMATION TECHNOLOGY DEGREE: BTECH (JULY 2019 – NOVEMBER

2017=9)
COURSE: INTERNET TECHNOLOGY LAB SEMESTER: VI
COURSE CODE: IT 332 COURSE TYPE: CORE
COURSE AREA/DOMAIN: WEB APPLICATION CONTACT HOURS: 4 hours/Week.
REGULATION:2018
CORRESPONDING LAB COURSE CODE (IF ANY): LAB COURSE NAME:
SYLLABUS:
UNIT DETAILS HOURS
Install setup and configure Web server bundles (wamp/xampp/Apache/IIS
etc.)
Create a web page with all possible elements of HTML5
Create a web page with all types of Cascading style sheets
Programs to demonstrate JavaScript array, object and functions
Client Side Scripts for Validating Web Form Controls Using JavaScript
Program to demonstrate DOM event bubbling
Programs using XML – DTD
Programs using XML – Schema
Programs using XML – XSLT/XS
Programs using AJAX
Server Side Scripting using PHP
Programs using session tracking in PHP
Programs using cookies tracking in PHP
Programs using MySQL database connectivity in PHP

1 Robert W Sebesta, Programming with World Wide Web , 7th ed., Pearson Education ,New Delhi, 2009
2 Deitel&Deitel Internet & World Wide Web How To Program 4th ed., Pearson International Edition
Education ,New Delhi, 2009
3 Bob Boiko, Content Management Bible, 2nd Edition, Wiley Publishers. [Chapter 1, 2]
4 Chris Bates, Web Programming Building Internet Applications, 3/e, Wiley India Edition 2009.
5 Bear Bibeault and Yehuda Katz, jQuery in Action, Second Edition, Manning Publications.[Chapter 1] Black
Book, Kogent Learning Solutions Inc. 2009
6 Dream Tech, Web Technologies: HTML, JS, PHP, Java, JSP, ASP.NET, XML, AJAX,
9 Jeffrey C Jackson, Web Technologies A Computer Science Perspective, Pearson Education Inc. 2009.
IT 307 COMPUTER NETWORKS Basic awareness of network communication V
COURSE OBJECTIVES:
1 To impart the basics of web page design
2 To understand important components of HTML5 documents and use HTML5 to create web
pages
3 To learn to use JavaScript in WebPages to enhance the functionality and appearance of web
pages
4 To know XML schema and transformation
5 To design dynamic web pages using PHP
COURSE OUTCOMES:
Blooms’
SNO DESCRIPTION Taxonomy
Level
Understand,
Apply,
Students will able to understand, analyze and apply the role of languages like
C332 .1 Analyze
HTML, XML, and JavaScript.
(level 2, 3
and 4)
Knowledge,
Students will able toanalyze a web page and identify its elements and Analyze
C332 .2
attributes. (level 1 and
4)
Create
C332 .3 Students will able to create XML documents and DTD.
(level 6)
Create
C332 .4 Students will able to create dynamic web pages using PHP.
(level 6 )
Knowledge
C332 .5 Students will have a thorough knowledge on data manipulation in a web.
(level 1)

PO PO PO PO PO PO PO PO PO P0 PO PO PSO PSO PSO

1 2 3 4 5 6 7 8 9 11 1 2 3
10 12
C332.1 2 1 - - - - - - - - - - 1 - -
C332.2 2 2 1 - - - - - - - - - 2 - -
C332.3 3 2 2 1 - - - - - - - - 2 1 -
C332.4 3 2 3 2 - - - - - - - - 2 2 -
C332.5 2 3 3 2 - - - - - - - - 3 2 -
C332(Overall 2 2 3 2 2 2
Attainment)
LOW
Mapping /MEDIUM Justification
/HIGH
Understanding the role of web page designinglanguages helps to find out

C332.1-PO1 M
the solution of complex engineering problems.
Knowledge on HTML, XML and Javascript helps to identify, formulate,

C332.1-PO2 L review research literature, and analyzecomplexengineering problems
reaching substantiated conclusions.
C332.1-PSO1 L This basic knowledge prepares the students for professional careers, with
a strong technical foundation.
Understanding of basic elements and attributes helps to find out the

C332.2-PO1 M
solution of complex engineering problems.
C332.2-PO2 M Identify, formulate and analyze elements and its attributes of webpages
helps to solve complexengineering problems.
This knowledge helps to design solutions for complex engineering

C332.2-PO3 L problems anddesign system components or processes that meet the
specified needs with appropriate consideration for the public health and
safety, and the cultural, societal, and environmental considerations.
Analysis of web page helps toprepare the students for professional

C332.2-PSO1 M careers, with a strong technical foundation and to nurture the managerial
skills to model themselves as entrepreneurs/ key-players in the field of IT.
Knowledge on XML documentshelps to find out the solution of complex

C332.3-PO1 H
engineering problems.
Understanding of XML documents and DTD helps to identify, formulate

C332.3-PO2 M and analyzecomplexengineering problems reaching substantiated
conclusions.

Basic knowledge on XML and DTD can be used to design solutions for
C332.3-PO3 M complex engineering problems anddesign system components or
processes that meet the specified needs.
This basic understanding helps to use research-based knowledge and

C332.3-PO4 L researchmethods including design of experiments, analysis and
interpretation of data, and synthesis of the information to provide valid
conclusions.
C332.3-PSO1 M Knowledge about XML documents and DTD prepare the students for
professional careers, with a strong technical foundation.
C332.3-PSO2 L XML document creation helps to prepare students to excel in analysing,

formulating and solving engineering problems.
They understand the basic concepts of PHP which helps to find out the
C332.4-PO1 H
solution of complex engineering problems.
Knoweldge on PHP helps to identify, formulate, review research

C332.4-PO2 M literature, and analyzecomplexengineering problems reaching
substantiated conclusions.
Creation of dynamic web pages helps to design solutions for complex

engineering problems anddesign system components or processes that
C332.4-PO3 H meet the specified needs with appropriate consideration for the public
health and safety, and the cultural, societal, and environmental
considerations.
Understanding of basic concepts of PHP use research-based knowledge

C332.4-PO4 M and researchmethods including design of experiments, analysis and
interpretation of data, and synthesis of the information to provide valid
conclusions.
C332.4-PSO1 M Understanding of PHP prepares the students for professional careers, with
a strong technical foundation in web page designing.
C332.4-PSO2 M Dynamic web page designing prepare students to excel in analysing,

formulating and solving engineering problems.
They acquire thorough knowledge on data manipulation in a webhelps to

C332.5-PO1 M
find out the solution of complex engineering problems.
C332.5-PO2 H Knowledge on data manipulation in a web helps to identify, formulate,

review research literature, and analyzecomplexengineering problems.
C332.5-PO3 H Data manipulation in a web helps to design solutions for complex

engineering problems.
Understanding on data manipulation in a web use research-based

C332.5-PO4 M knowledge and researchmethods including design of experiments,
analysis and interpretation of data, and synthesis of the information to
provide valid conclusions.
Knowledge on data manipulation in a web prepare the students for

C332.5-PSO1 H professional careers, with a strong technical foundation and to nurture the
managerial skills to model themselves as entrepreneurs/ key-players in
the field of IT.
C332.5-PSO2 M This knowledge prepares students to excel in analysing, formulating and

solving engineering problems.


1 www.w3schools.com/
2 www.w3.org/
3 www.htmldog.com / Tutorials/ HTML
4 www.validator.w3.org/
5 www.php.net/manual/en/index.php
6 httpd.apache.org/download.cgi
7 https://alistapart.com/article/frameworks
8 http://getbootstrap.com/css/
9 https://www.w3.org/TR/WD-DOM/introduction.html
 CHALK & TALK  STUD.  WEB RESOURCES
ASSIGNMENT
 LCD/SMART STUD. SEMINARS  ADD-ON COURSES
BOARDS
 ASSIGNMENTS STUD. SEMINARS  TESTS/MODEL  UNIV.
EXAMS EXAMINATION
STUD. LAB STUD. VIVA MINI/MAJOR CERTIFICATIONS
PRACTICES PROJECTS
ADD-ON COURSES OTHERS
ASSESSMENT OF MINI/MAJOR PROJECTS BY EXT. OTHERS
EXPERTS
Ms.Mary John
(Faculty) (H.O.D)

COURSE PLAN
DAY PROGRAMS
Install, setup and configure Web server bundles

1
(wamp/xampp/Apache/IIS etc.)
2 Create a web page with all possible elements of HTML5
3 Create a web page with all types of Cascading style sheets
4 Programs to demonstrate JavaScript array, object and functions
5 Client Side Scripts for Validating Web Form Controls Using JavaScript
6 Program to demonstrate DOM event bubbling
7 Programs using XML – DTD
8 Programs using XML – Schema
9 Programs using XML – XSLT/XS
10 Programs using AJAX
11 Server Side Scripting using PHP
12 Programs using session tracking in PHP
13 Programs using cookies tracking in PHP
14 Programs using MySQL database connectivity in PHP
Lab Cycle
Course Code : IT332
Course Title : Internet Technology Lab
1. Install, setup and configure Web server bundles (wamp/xampp/Apache/IIS etc.)

2. Create a registration form in the following template:

3. Create a web page with all possible page structure elements in the following template:


4. Create a web site of an online shop using HTML and CSS (external style sheet).

(Must contain following html elements images, links , tables, lists etc and CSS
properties such as background properties, font, alignment , positioning and drop down
menu)
(or)
Create a web page for your curriculum vitae using the following CSS properties.
(Heading 1: Georgia, color blue, background red, bold, size 24px

Heading 2: Georgia, color dark red, size 18px
Body: background light grey, Arial, fixed background image at bottom-right
Table: thick green border, contents center alignment
Also apply the following CSS properties such as div, width, height, overflow ,border,
padding & margin)
5.To create a sample invoice page and apply styles as per the template:
6. Write a JavaScript program that accepts a number as a parameter and check the number is
prime or not.
7.Write a Javascript program to find the maximum, minimum,sum and average of numbers in
an array.
8:Write a Javascript program to sort a list of elements using Bubble Sort.
9.Write a Javascript program to implement a calculator
10. Write the client side scripts for Validating HTML Registration Using JavaScript.
11. Create an XML file with the following:

 Student Id
 Name
 Phone
 Email
 Date of birth
Validate and display the XML page using DTD
12.Create an AJAX application with the following features:
 The user clicks the link "Make a request" in the browser;

 This calls the makeRequest() function with a parameter – the name test.html of an HTML file
in the same directory;
 The request is made and then (onreadystatechange) the execution is passed to alertContents();
 alertContents() checks if the response was received and it's an OK and then alert()s the contents
of the test.html file.
13. To write a PHP code for cookies for creation and display all available cookies.
14. Write a PHP code to get all session variable values.
15. To create a database in MySql for employer information system and display the details in the
database using PHP.

IT334
COMPUTER
NETWORK LAB

PROGRAMME: INFORMATION DEGREE: BTECH

TECHNOLOGY
COURSE:COMPUTER NETWORKS LAB SEMESTER: VI CREDITS: 1
REGULATION : 2016
COURSE AREA/DOMAIN: CONTACT HOURS: 3 hours/Week

INTERNETWORKING
SYLLABUS:
DETAILS HOURS
Familiarization of Internetworking - Network Cables - Colour coding -

6
Crimping. Internetworking Operating Systems - Configurations
Implementing static routing.
Implementing dynamic routing using RIP 6
Implementing dynamic routing using OSPF
Implementing dynamic routing using EIGRP
Layer 2 Switching configuration -VLAN configuration.

6
VTP Configuration, VTP pruning.
Implement inter-VLAN routing.
Access Control List

6
a. Standard Access Lists.
b. Extended Access Lists
3
Familiarization of network simulators

27(9 Lab
TOTAL HOURS
Sessions)
R CCNA –Cisco Certified Network Associate. Study Guide ,Todd Lammle, CCSI, Wiley
India Edition-Sixth Edition
IT307 Computer Networks Basics in Computer Networks S5
COURSE OBJECTIVES:
1 Build an understanding of the fundamental concepts of computer networking
2 Familiarize the student with the basic taxonomy and terminology of the computer
networking area
3 Introduce the student to advanced networking concepts, preparing the student for entry
Advanced courses in computer networking
4 Allow the student to gain expertise in some specific areas of networking such as the design
and maintenance of individual networks
COURSE OUTCOMES:
Blooms’
SNO DESCRIPTION Taxonomy
Level
Knowledge
IT334.1 Identify the different types of network topologies and protocols.
(level 1)

Identify the different types of network devices and their functions Knowledge
within a network (level 1)
IT334.2
Familiarity with the basic protocols of computer networks, and Evaluate

IT334.3 evaluates how they can be used to assist in network design and
implementation. (level 5)
Understand,
Understand the concepts of routing mechanisms , network interfaces,
Analyze(level
IT334.4 and design/performance issues in local area networks and wide area
2 and 4)
networks
Understand
IT334.5 To be familiar with wireless networking concepts
(level 2)
PO PO PO PO PO PO PO PO PO PO PO PO PSO1 PSO2 PSO3

1 2 3 4 5 6 7 8 9 11
10 12
IT334. 3 _ 3 _ _ _ _ _ _ _ _ 3 _ 3 -
1
3 3 _ _ - _ _ - _ 3 - 3 _
IT334.
2
IT334. - 2 _ 2 _ _ _ _ _ _ 2 _ 3
3
IT334. 2 3 2 - _ _ _ _ _ _ _ - _
4
IT334. 1 3 _ 3 _ _ _ _ - _ 3 _ 1 _
5
SNO DESCRIPTION PROPOSED
ACTIONS

1 Detailed Study of TCP/IP protocols Seminars
PROPOSED ACTIONS: TOPICS BEYOND SYLLABUS/ASSIGNMENT/INDUSTRY

VISIT/GUEST LECTURER/NPTEL ETC
MAPPING LOW/MEDIUM JUSTIFICATION

/HIGH
IT334.1-PO1 H Students will acquire knowledge Network Topologies

and Protocols.
IT334.1-PO3 H Students will be able to understand how these LAN

Configuration and IP addressing is done in simulation
mode of packet tracer tool
IT334.1-PO12 H Information acquired from Packet Network Topologies

and Protocols provides lifelong learning in the context of
Network Designing.
IT334.1-PSO2 H Simulation using Packet tracer tool helps in contribution

of engineering skills in design of Network.
IT334.2-PO1 H Studies about the various networking components help

the students to understand about its basic functionalities
specially the switch and router configuration.
IT334.2-PO3 H Students gain the Knowledge of virtual LAN help

students in designing network.
IT334.2-P012 H Studies about the various networking device

Configuration provide lifelong learning in the context of
Network Designing.
IT334.2-PS02 H Students will be able to analyze different functionalities

provided by networking devices in the domain of
network design.
IT334.3-PO2 M Studies about the analysis of different network protocols

helps in the network designing.
IT334.3-PO5 M Static and dynamic routing protocols simulation will be

familiarized by the students.
IT334.3-PO12 M Information acquired from routing protocol evaluation

provides lifelong learning in the design of network.
IT334.3-PSO2 L Students could apply the knowledge of Routing protocol

simulation in the field of network design and
Implementation.

IT334.4-PO1 M Students gain the ability to learn about the concepts of

routing mechanisms, crimping and performance issues
in local area networks and wide area networks.
IT334.4-PO2 H Students will understand the Implementation of Web

Server, DHCP Server and DNS in simple LAN.
IT334.4-P03 M The students could understand Implementation of

wireless LAN using PCs, and a wireless router
IT334.5-PO1 L Students will be obtaining basic knowledge of wireless

networking concepts .
IT334.5-P03 H Students will be obtain basic knowledge of

Implementing inter-VLAN routing using VTP VLAN’s
and switches
IT334.5-P05 H Students could apply the knowledge of wireless routing
concepts for simulating the network using packet tracer
tool.
IT334.5-P012 H Students could apply the knowledge of wireless

networking concept for lifelong learning in the context of
technological change.
IT334.5-PS02 L Students will be acquiring knowledge to apply the

engineering skills in network design and implementation.
1 https://learningnetwork.cisco.com/thread/15662
2 http://recentccna.blogspot.in/
CHALK & TALK ☐STUD. WEB RESOURCES Lab Sessions
ASSIGNMENT
☐ LCD/SMART ☐STUD. SEMINARS ☐ ADD-ON COURSES

BOARDS
☐ASSIGNMENTS ☐STUD. SEMINARS TESTS/MODEL UNIV.

EXAMS EXAMINATION

 STUD. LAB ☐STUD. VIVA ☐ MINI/MAJOR ☐ CERTIFICATIONS

PRACTICES
PROJECTS
☐ ADD-ON COURSES ☐ OTHERS
 ASSESSMENT OF COURSE OUTCOMES (BY ☐ STUDENT FEEDBACK ON FACULTY

FEEDBACK, ONCE)
(TWICE)
☐ ASSESSMENT OF MINI/MAJOR PROJECTS BY ☐ OTHERS

EXT. EXPERTS
Bency Wilson (HOD)
(Faculty)
DEPARTEMENT OF INFORMATION TECHNOLOGY
IT334 Computer Networks Lab

LAB CYCLE - 2019
Experiment 1
a) FAMILIARIZATION OF NETWORK HARDWARE DEVICES.
b) FAMILIARIZATION OF NETWORK CABLES AND CONNECTORS.
c) STUDY OF TCP/IP PROTOCOL SUITE.
d) FAMILIARIZATION OF PACKET TRACER.
e) FAMILIARIZATION OF CISCO SWITCH COMMANDS.
f) FAMILIARIZATION OF CISCO ROUTER COMMANDS.
Experiment 2
A.) SIMPLE LAN
Implementation of simple LAN using 4PCs and a switch.
 Configure IP address (Use Class C private IPs) and hostnames on PCs
 Check the Connection using ping command
 View ARP tables on each PC
 View MAC table on switch
B.) SERVER CONFIGURATIONS

1. DNS SERVER
Implementation of DNS in simple LAN using 3PCs, one DNS Server and a switch.
 Configure DNS
 Configure IP address and DNS setting on PCs
 Perform nslookup
 Execute ping command using domain names


2. WEB SERVER
Implementation of Web Server in simple LAN using 3PCs, one DNS Server, one Web server
and a switch.
 Configure DNS
 Configure Web Server
 Configure IP address and DNS setting on PCs
 Perform nslookup
 Access web server from PCs using browser
3. DHCP SERVER
Implementation of DHCP based LAN using 4PCs, one DHCP server and a switch.
 Configure DHCP server
 View IP address on each PC
EXPERIMENT 3
A. STATIC ROUTING
Implementation of static routing using 8 PCs, 2 switches and three routers.
 Configure IP address and hostnames on PCs.
 Configure IP address to routers
 Update Static Routing Table
 Check the connection using trace route command
 View MAC table on switches
 View routing tables on routers
EXPERIMENT 4
A. DYNAMIC ROUTING - RIP
Implementation of dynamic routing based on RIP using 8 PCs, 2switches and three routers.
 Update Routing Table in routers
B. DYNAMIC ROUTING - OSPF

Implementation of dynamic routing based on OSPF using 8 PCs, 2switches and three routers.
C. DYNAMIC ROUTING - EIGRP

Implementation of dynamic routing based on EIGRP using 4PCs, 2switches and three routers.
EXPERIMENT 5 - VIRTUAL LAN

Implementation of simple VLAN using 6PCs and a switch.
a. Configure IP address and hostnames on PCs
b. Configure 2 VLAN’s, VLAN1 and VLAN2 in switch using commands
c. Assign Connected three Physical Ports to VLAN1 and remaining ports to VLAN2
d. Check the Connection using ping command
e. View ARP tables on each PC
f. View MAC table on switch
g. View VLAN Database
EXPERIMENT 6 - VLAN TRUNK PROTOCOL

Implementation of Simple Trunk (VTP) using 4PCs and two switches.
b. Configure 2 VLAN’s, VLAN1 and VLAN2 in switch using commands
c. Assign Connected two Physical Ports to VLAN1 and remaining ports to VLAN2
d. Check the Connection using ping command
e. View ARP tables on each PC
f. View MAC table on switch
g. View VLAN Database
h. Configure Trunk port on VLAN1 and VLAN2 using commands
i. Check the Connection using ping command
EXPERIMENT 7 - INTER VLAN ROUTING USING VTP

Implement inter-VLAN routing using VTP using 2 VLAN’s, two switches and a router.
b. Assign Connected Physical Ports to appropriate VLAN’s
c. Check the Connection using ping command
d. View ARP tables on each PC
e. View MAC table on switch
f. View VLAN Databases
g. Configure Trunk port
h. Check the Connection using ping command
i. Check the connection using trace route command
EXPERIMENT 8 – ACCESS CONTROL LIST
EXPERIMENT 9 – FAMILIARIZATION OF NS2

LAB SCHEDULE
Week Experiment
Week 1&2 Exp. No : 1
Week 3 Exp. No : 2
Week 4 Exp. No : 3
Week 5 Exp. No : 4
Week 6 Exp. No : 5
Week 7 Exp. No : 6
Week 8 Exp. No : 7
Week 9 Exp. No : 8
Week 10 Exp. No : 9
Week 11 Model Lab Exam
Week 12 Final Lab Exam

DEPARTMENT OF INFORMATION TECHNOLOGY
IT334 COMPUTER NETWORKS LAB
OPEN QUESTIONS
SAMPLE NETWORKS




DEPARTMENT OF INFORMATION TECHNOLOGY
IT334 COMPUTER NETWORKS LAB
ADVANCED QUESTIONS
Question 1
Configure a network as depicted, in Packet Tracer
 Implement RIP.
 Do trace route to “google.com” from Client PC, when “Router3” is ON
 Do trace route to “google.com” from Client PC, when “Router3” is OFF
 Show “Routing Table” of “Gateway Router”
o When “Router3” is ON
o When “Router3” is OFF
(To proceed, write necessary commands to configure Routers/Switches; May not be in detail)
Question 2

Configure a network as depicted, in Packet Tracer
 Implement Dynamic Routing using OSPF using area as “area1”.

 Do trace route to “google.com” from Client CS1, when Gateway Router Link (192.168.4.1) is
ON
 Do trace route to “google.com” from Client CS1, when Gateway Router Link (192.168.4.1) is
OFF
 Ping “IT3” from “CS1”, when Gateway Router Link (192.168.1.1) is ON
 Ping “IT3” from “CS1”, when Gateway Router Link (192.168.1.1) is OFF

Question 3

IT 352
Comprehensive Exam

PROGRAMME: Information Technology DEGREE: B.TECH
COURSE: Comprehensive Exam SEMESTER:S6 CREDITS: 2

REGULATION: 2015
COURSE AREA/DOMAIN: Information CONTACT HOURS: 2 hours/Week
Technology
CORRESPONDING LAB COURSE LAB COURSE NAME: NA
CODE (IF ANY): Nil
SYLLABUS:
UNIT DETAILS HOURS
Oral examination – To be conducted weekly during the slot allotted for the course in the
curriculum (@ three students/hour) – 50 marks
Written examination - To be conducted by the Dept. immediately after the second internal
examination– common to all students of the same branch – objective type (1 hour
duration)– 50 multiple choice questions ( 4 choices) of 1 mark each covering all the
courses up to and including semester V – no negative marks – 50 marks.
Oral Examination
1 Information Technology branch subjects up to and including semester V
Witten Examination: Part A
CS205 Data Structures, CS202 Computer Organization & Architecture,

2 80%
IT 204 Object Oriented Techniques, CS 208 Principles of Database
Design, IT 303 Theory of Computation, IT 305 Operating Systems,
IT 307 Computer Networks
Written Examination: Part B
3 MA101 Calculus, MA102 Differential Equations, BE100 Engineering 20%

Mechanics, BE103 Sustainable Engineering, BE110 Engineering Graphics,
B102 design & Engineering
Given in the curriculum
COURSE PRE-REQUISITES: Nil

COURSE OBJECTIVES:
1 To assess the comprehensive knowledge gained in basic courses relevant to
the branch of study
2 To comprehend the questions asked and answer them with confidence.
COURSE OUTCOMES:
Sl DESCRIPTION
No.
1 The students will be confident in discussing the fundamental aspects of
any engineering problem/situation and give answers in dealing with them
CO MAPPING WITH PO, PSO

Programme Outcomes (POs) Programme-
Specific Outcomes
CO (PSOs)
No. 1 2 3 4 5 6 7 8 9 10 11 12 1 2 3
1 2 2 1 1 1 2 1 2
JUSTIFICATION FOR CO-PO MAPPING
Comprehensive knowledge gained from mathematics and engineering

IT352.1-PO1 2
fundamentals contribute to solving complex engineering problems
Comprehensive knowledge gained in basic courses relevant to the Information
IT352.1-PO2 2 Technology branch contribute to identify, formulate, review research
literature, and analyze complex engineering problems
Comprehensive knowledge gained in basic courses can utilize in design and
IT352.1-PO3 1
develop solutions for complex engineering problems
Comprehensive knowledge gained in computer engineering courses helps to
apply reasoning informed by the contextual knowledge to assess societal and
IT352.1-PO6 1
safety issues and the consequent responsibilities relevant to the professional
Comprehensive knowledge gained in basic Information Technology courses
IT352.1-PO9 1
will enable the student to become a productive member of a design team
Comprehensive knowledge gained in basic courses in IT contributes to
IT352.1-PO11 2 demonstrate knowledge and understanding of the engineering principles and
apply these to one’s own work.
The student will become aware of the need for lifelong learning and the
IT352.1-PO12 1
continued upgrading of technical knowledge.
Students will be able to contribute their engineering skills in computing and
IT352.1-PSO2 2 information engineering domains like network design and administration,
database design and knowledge engineering.


1. http://nptel.ac.in/courses/
2. https://www.nodia.co.in/gate-previous-year-solved-papers
☑ CHALK & TALK ✓☐ WEB
RESOURCES
☑ LCD/SMART ☐ STUD. ☐ ADD-ON
BOARDS SEMINARS COURSES
ASSIGNMENTS STUD. SEMINARS ☑ TESTS/MODEL ☐ UNIV.
EXAMS EXAMINATION
☐STUD. LAB ☐✓STUD. VIVA ☐ MINI/MAJOR ☐
COURSES
☑ ASSESSMENT OF COURSE OUTCOMES ☑ STUDENT FEEDBACK ON
Lakshmi K.S Saritha S

(Faculty in Charge) (HoD)
101 Department of Information Technology

S6 Academic Handbook

Uploaded by

Copyright:

Available Formats

S6 Academic Handbook

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

S6 Academic Handbook

Uploaded by

Copyright:

Available Formats

Rajagiri School of Engineering & Technology

Department of Information Technology 1

Program Outcomes (PO)

Information Technology Program Students will be able to:

PO 1.Engineering knowledge: Apply the knowledge of mathematics, science, engineering

Department of Information Technology 2

Program Specific Outcomes (PSO)

Program Educational Objectives (PEO)

Department of Information Technology 3

1.1 Course Information Sheet 8

1.2 Assignment Questions 14

1.3 Course Plan 14

2.1 Course Information Sheet 17

2.23.2 Assignment Questions 22

2.3 Course Plan 22

3.1 Course Information Sheet 25

3.2 Assignment Questions 31

3.3 Course Plan 33

4 Data Warehousing and management 35

4.1 Course information Sheet 36

4.3 Assignment questions 45

4.4 Course plan 46

5.1 Course information Sheet 49

5.2 Assignment questions 55

Department of Information Technology 4

5.3 Course plan 53

6.1 Course information Sheet 58

6.2 Assignment questions 62

6.3 Course plan 63

7 Software project management 64

7.1 Course information Sheet 65

7.2 Assignment questions 69

7.3 Course plan 70

8 Internet Technology lab 71

8.1 Course information Sheet 72

8.2 Lab Schedule 78

9 Computer network lab 84

9.1 Course information Sheet 85

9.2 Lab Schedule 94

9.3 Open Questions 95

9.3 Advanced Questions 100

10 Comprehensive exam 103

10.1 Course Information Sheet 104

Department of Information Technology 5

ASSIGNMENT SCHEDULE FOR S6 IT

Week Subject Subject Teacher

Principles of management Lakshmi VijayKumar

Week 3 Compiler Design Binu A

Week 4 Data warehousing and management Saritha S

Week 5 Internet technology Divya james

Software project management/ Abey Abraham/

Department of Information Technology 6

Department of Information Technology 7

COURSE INFORMATION SHEET - Jan 2019

PROGRAMME: Information Technology DEGREE: BTECH

Characterization of Distributed Systems-Introduction-Examples-Resource Sharing and the

Distributed Objects and Remote Invocation-Introduction-Communication between

V Coordination and Agreement-Introduction-Distributed mutual exclusion – Elections ¬ 8

Distributed Shared Memory-Introduction-Design and implementation issues-Sequential