Course File

Document Name: 1. File Content

Document ID:
(Index)

Name of the Programme: Information Technology

Academic Year/ Sem: 2023-24 ODD
Batch of the student: 2021-2025
Name of the Course Code/Name: IT3501/FULL STACK WEB DEVELOPMENT
Name of the Faculty: G.Kanmani AP/IT

1. File Content (Index)

2. Vision, Mission of the Department
3. Activity Planner
4. Time- Table
5. Student Name List with Register No.
6. Syllabus Copy
7. Course Objectives, Course Outcomes(CO), CO-PO Mapping& CO-PSO Mapping
8. Course Plan
9. Lesson Plan
10. Content Beyond Syllabus
11. Assignment, Student Seminar Topics & Self Study Topics
12. Question Papers
a. Question Bank(Unit Wise)
b. University Question Papers(Previous & Current)
c. Internal Tests & Model Exam Question Papers
d. Internal Assessment/ Objective type Question Papers(if any)
13. Student Academic Performance
a. Internal Test Mark List with Result Analysis,
b. Model Exam Mark List with Result Analysis
c. Any other Assessment Marks (Seminar, Add on course, Project, activities etc)
14. Remedial Class
a. Remedial Class Schedule (Time Table)
b. Remedial Class Student Attendance
c. Remedial Test/Assignment/Activity-QP & Marks
15. Consolidated Mark List
16. Course Attainment
17. Sample Answer Sheets
a. Internal Test, Model Exam Answer Sheets
b. Assessment Test Answer Sheets
c. Remedial Test Answer Sheets
18. Lecture Notes/ Hand Outs/ Net Down/OHP/PPT(Hard/Soft Copy)(Sample )
19. Log Book
 Course File

Document
Document ID: 2. Vision & Mission
Name:

VISION & MISSION of the Department

Vision of IT Department
 To prosper as a competent professional for serving industry and Nation's socio-
economic progress.
 To prosper as a competent professional for serving industry and Nation's socio-
economic progress.

Mission of IT Department
 To foster computing skills with an emphasis on professional competency,
interpersonal development and ethics.
 To enrich the aptitude of the students for facing the recent challenges of industry
and society.
 To inculcate the students for pursuing careers in industry, academic and research.

FACULTY IN-CHARGE HOD

 Course File

Document
Document ID: 2023-24/ RPSIT/IT 3. Activity Planner
Name:

s
FACULTY IN-CHARGE HOD
 Course File

Document
Document ID: 2023-24/ RPSIT/IT 4. Time-table
Name:

DO I II III IV V VI VII VIII

9-9.50 9.50-10.40 10.50-11.40 11.40- 1.10-2.00 2.00-2.50 3.00-3.50 3.50-4.30
12.30

Lunch break
1 FSWD
2 FSWD
3
4 FSWD FWD
5
6

FACULTY IN-CHARGE HOD

 Course File

Document 5. Student Name List

Document ID: 2023-24/ RPSIT/IT
Name:

S.NO REG.NUMBER NAME

1 611721205001 AKBAR ALI Y
2 611721205002 DHANUSH R
3 611721205003 DHARANIVENKATESH R K
4 611721205005 GOPINATH M
5 611721205006 JAYA SURYA B
6 611721205007 KAVIN KUMAR M
7 611721205008 KAVIYARASAN S
8 611721205009 MADHUMITHA S
9 611721205010 MINARRAJA K
10 611721205011 MOHANKUMAR N
11 611721205012 MURALIKRISHNA M
12 611721205013 NARMADHA M
13 611721205014 NAVEEN S
14 611721205015 PALANISAMY M
15 611721205016 PERAMAN G
16 611721205017 PERARASU S
17 611721205018 POOVARASAN E
18 611721205019 POOVARASAN K
19 611721205020 PREETHI S
20 611721205021 RATHIKASRI K
21 611721205022 RITHIK S
22 611721205023 SARATHI M
23 611721205024 SASITHA P
24 611721205025 SELLADURAI G (PMSS)
25 611721205026 SELVAGANAPATHI P
26 611721205027 SOUNDHARYA V
27 611721205028 SRIVATSAN B
28 611721205029 SURYA M
29 611721205030 TAMILKUMARAN K
30 611721205031 UMAPATHI R
31 611721205032 VAISHNAVI N
32 611721205033 VARADHARAJ S
33 611721205301 M.DEVAKUMAR
34 611721205701 DEEPAK KUMAR.P
35 611721205302 GHISHON.I
36 611721205303 O.HARIHARN

FACULTY IN-CHARGE HOD

 Course File

Document
Document ID: 2023-24/ RPSIT/IT 6. Syllabus Copy
Name:

IT3501 FULL STACK WEB DEVELOPMENT LTPC

3003

COURSE OBJECTIVES:
• To understand the various components of full stack development
• To learn Node.js features and applications
• To develop applications with MongoDB
• To understand the role of Angular and Express in web applications
• To develop simple web applications with React

UNIT I BASICS OF FULL STACK 9

Understanding the Basic Web Development Framework - User - Browser – Webserver - Backend
Services – MVC Architecture - Understanding the different stacks –The role of Express – Angular –
Node – Mongo DB – React
UNIT II NODE JS 9
Basics of Node JS – Installation – Working with Node packages – Using Node package manager –
Creating a simple Node.js application – Using Events – Listeners –Timers - Callbacks – Handling Data
I/O – Implementing HTTP services in Node.js
UNIT III MONGO DB 9
Understanding NoSQL and MongoDB – Building MongoDB Environment – User accounts – Access
control – Administering databases – Managing collections – Connecting to MongoDB from Node.js –
simple applications
UNIT IV EXPRESS AND ANGULAR 9
Implementing Express in Node.js - Configuring routes - Using Request and Response objects - Angular
- Typescript - Angular Components - Expressions - Data binding - Built-in directives
UNIT V REACT 9
MERN STACK – Basic React applications – React Components – React State – Express REST APIs -
Modularization and Webpack - Routing with React Router – Server-side rendering
COURSE OUTCOMES:
At the end of the course, students will be able to
CO1: Understand the various stacks available for web application development
CO2: Use Node.js for application development
CO3: Develop applications with MongoDB
CO4: Use the features of Angular and Express
CO5: Develop React applications
TOTAL: 45 PERIODS
TEXT BOOKS
1. Brad Dayley, Brendan Dayley, Caleb Dayley, ‘Node.js, MongoDB and Angular Web
Development’, Addison-Wesley, Second Edition, 2018 2. Vasan Subramanian, ‘Pro MERN Stack,
Full Stack Web App Development with Mongo, Express, React, and Node’, Second Edition,
Apress, 2019.
REFERENCES
1. Chris Northwood, ‘The Full Stack Developer: Your Essential Guide to the Everyday Skills Expected
of a Modern Full Stack Web Developer’, Apress; 1st edition, 2018
2. KirupaChinnathambi, ‘Learning React: A Hands-On Guide to Building Web Applications Using
React and Redux’, Addison-Wesley Professional, 2nd edition, 2018
3.https://www.tutorialspoint.com/the_full_stack_web_development/index.asp
4. https://www.coursera.org/specializations/full-stack-react
5. https://www.udemy.com/course/the-full-stack-web-development/

FACULTY IN-CHARGE HOD

 Course File

7. Course Objectives,
Document Course Outcomes (CO),
Document ID: 2023-24/ RPSIT/IT
Name: CO-PO Mapping& CO-
PSO Mapping

CO. No/ C310 Course Objective statement

C310.1 • To understand the various components of full stack development

CO. No/ C310

C310.2 • To learn Node.js features and applications
Course Outcome statement Bloom’s Taxonomy Level
CO1: Understand the various stacks available
C310.1
C310.3for web• application
To develop development
applications with MongoDB BL2
CO2: Use Node.js for application development
C310.2
C310.4 • To understand the role of Angular and Express in web applications
BL3

CO3: Develop applications with MongoDB

C310. 3
C310.5 • To develop simple web applications with React BL2

C310. 4
CO4: Use the features of Angular and Express BL2

C310.5
CO5: Develop React applications BL2

Mapping of PEO with PO

PEO PO
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
PEO1 3 3 3 2 2 3 2 3 3 2 2 3
PEO2 3 2 3 2 2 3 2 2 2 2 3
PEO3 3 3 3 2 2 - 2 2 2 3
PEO4 3 3 3 2 3 - 1 2 2 3
PEO5 3 3 3 3 3 3 2 2 2 3
PEO6 3 2 3 3 3 - 2 3 3 2 2 3

CO-PO-PSO Mapping

CO PO PSO
PO PO PO PO PO PO PO PO8 PO9 PO P PO PS PS PS
1 2 3 4 5 6 7 10 O 12 O1 O2 O3
11
CO1 2 3 - - - - - 2 2 2 - 1 - - -
CO2 2 3 3 - - - - 2 2 2 - 1 - - -
CO3 2 3 3 - - - - 2 2 2 - 1 - - -
CO4 2 3 3 - - - - 2 2 2 - 1 - - -
CO5PSO2 3 3 - - - - 2 PO 2 2 - 1 - - -
PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12
PSO1 2 3 3 2 1 - 1 1 1 - - 1
PSO2 2 3 3 2 1 - 1 1 1 - - 1
PSO3 - - - - - - - - - - - -
Mapping of PSO with PO

Correlation Levels:

1-Low/ Reasonable
2-Medium/Moderate
3-Strong/ High/substantial
-“– No Correlation.

FACULTY IN-CHARGE HOD

 Course File

Document 8. Course Plan

Document ID: 2023-24/ RPSIT/IT
Name:
Course Plan
Name of the Programme: Information Technology
Academic Year/ Sem: 2023-24 ODD
Batch of the student: 2021-2025
IT3501/FULL STACK WEB
Name of the Course Code/Name: DEVELOPMENT
Name of the Faculty: G.Kanmani AP/IT
Total No. of Periods Allotted for the Course: 45

Unit No. Title of the Unit No. of Periods No. of periods

Allotted Taken
1

Time Allotted for Tests & Feedback

Time Allotted for Revision

FACULTY IN-CHARGE HOD

 Course File

Document 9. LessonPlan
Document ID: 2023-24/ RPSIT/IT
Name:
Lesson Plan

Name of the Programme: S

Academic Year/ Sem:
Batch of the student:
Name of the Course Code/Name:
Name of the Faculty:

UNIT I RELATIONAL DATABASES

Date of
Planned Planned Relevant Teaching Reference Bloom
S.No Topic to be covered Completio
Hour Date CO’s No Aids Materials s Level
n
Purpose of Database
1 1 CO1 BB T1 REM
System
Views of data, Data CO1 BB
2 2 T1 UND
Models
Database System CO1 BB
3 2 T1 UND
Architecture
CO1 BB
Introduction to
4 1 T1 ANA
relational databases,
CO1 BB
5 Relational Model 1 T1 UND
Keys, Relational CO1 BB
6 1 T1 UND
Algebra
CO1 BB
7 SQL fundamentals 1 T1 UND
Advanced SQL CO1 BB
8 1 T1 UND
features
Embedded SQL– CO1 BB
9 1 T1 CRE
Dynamic SQL

FACULTY IN-CHARGE HOD

 UNIT II DATABASE DESIGN
Date
S.N Planne Planned Relevant Teaching Reference Blooms of
Topic to be covered
o d Hour Date CO’s No Aids Materials Level Comp
letion
Entity-Relationship BB
1 1 CO2 T1 REM
model
ER diagrams, CO2 BB
Enhanced-ER Model,
2 2 T1 ANA
ER-to-Relational
Mapping
Functional Dependencies, CO2 BB
3 2 T1 UND
Non-loss Decomposition
First, Second, Third CO2 BB
4 1 T1 APP
Normal Forms problems
CO2 BB
5 Dependency Preservation 1 T1 CRE
Boyce/Codd Normal CO2 BB
6 1 T1 UND
Form
Multi Valued CO2 BB
7 1 T1 UND
Dependencies
CO2 BB
8 Fourth Normal Form 1 T1 UND
Join Dependencies and CO2 BB
9 2 T1 EVA
Fifth Normal Form

FACULTY IN-CHARGE HOD

UNIT III TRANSACTIONS

Referenc
Date of
Planne Planne Relevant Teaching e Blooms
S.No Topic to be covered Completi
d Hour d Date CO’s No Aids Material Level
on
s
Transaction Concepts, BB
1 1 CO3 TB1 APP
ACID Properties
Schedules, CO3 BB TB1
2 2 REM
Serializability
Transaction support in CO3 BB TB1
3 1 EVA
SQL
CO3 BB TB1
Need for Concurrency,
4 2 APP
Concurrency Control
Two Phase Locking, CO3 BB TB1
5 1 UND
Timestamp
Multi version, CO3 BB TB1
6 Validation and 1 UND
Snapshot Isolation
Multiple Granularity CO3 BB TB1
7 2 REM
locking
Deadlock Handling, CO3 BB TB1
8 1 EVA
Recovery Concepts
Recovery based on CO3 BB TB1
9 deferred and immediate 2 APP
update
Shadow paging, CO3 BB TB1
10 1 APP
ARIES algoithms

FACULTY IN-CHARGE HOD

 UNIT IV IMPLEMENTATION TECHNIQUES
Releva
Plann Referenc Date of
S.N Planned nt Teaching Blooms
Topic to be covered ed e Completi
o Date CO’s Aids Level
Hour Materials on
No
RAID,File BB
1 CO4 TB1 UND
Organization 1
Organization of CO4 BB TB1
2 2 REM
Records in Files
Indexing and CO4 BB TB1
3 Hashing, Ordered 1 ANA
Indices
CO4 BB TB1
4 B+ tree Index Files 2 APP
CO4 BB TB1
5 B tree Index Files 1 EVA

CO4 TB1
6 B+ tree examples 1 PPT CRE
Static Hashing — CO4 TB1
7 1 PPT EVA
Dynamic Hashing
Query Processing CO4 TB1
Overview —
8 Algorithms for 2 PPT UND
SELECT and JOIN
operations
Query optimization CO4 TB1
9 using Heuristics and 1 PPT UND
Cost Estimation

Faculty In-charge HOD

UNIT V ADVANCED TOPICS
Plan Date of
S.N Planned Relevant Teaching Reference Blooms
Topic to be covered ned Completio
o Date CO’s No Aids Materials Level
Hour n
Distributed Databases
1 6 CO5 PPT TB1 ANA
Architecture
Data Storage, CO5 TB1
2 3 PPT REM
Transaction Processing
Object-based CO5 TB1
3 7 PPT UND
Databases
Object Database CO5 TB1
4 2 PPT REM
Concepts
Object-Relational CO5 TB1
5 1 PPT APP
features
CO5 TB1
ODMG Object Model,
6 3 PPT ANA
ODL, OQL
XML Databases, XML CO5 TB1
7 Hierarchical Model, 4 PPT UND
DTD, XML Schema
XQuery , Information CO5 TB1
8 5 PPT UND
Retrieval
IR Concepts, Retrieval CO5 TB1
Models, Queries in IR
9 4 PPT EVA
systems.
 Faculty In-charge HOD

Course File

Document 10. Content Beyond

Document ID: 2023-24/ RPSIT/IT
Name: Syllabus

Content Beyond Syllabus

S.No. Gap Action Date Topics Taken by Relevant POs

Taken & PSOs

1 NOSQL Seminar 16.04.2023 How to use NOSQL in DB- Dr S.Nithya PO5,PSO2

Purpose

Faculty In-charge HOD

 Course File

11. Assignment, Student

Document
Document ID: 2023-24/ RPSIT/IT Seminar Topics& Self
Name:
Study topic

Assignment Topics

S.No. Unit No. Topics Submission Date

1 2 Implementations of ER diagrams in real time 21.04.2022

applications
2 5 NOSQL and advanced DBMS 10.05.2022

Seminar Topics

Taken by
S.No. Unit No. Topics (Name of the Date
Student)
1 4 Static Hashing ,Dynamic
Hashing
2 4 Ordered indices
3 5 Transaction processing
4 5 Retrieval models

Self Study Topics

Unit
S.No. Topics References
No.
1. 1 SQL Operations https://www.simplilearn.com/sql-operators-article

2. 3 Normal Forms https://www.geeksforgeeks.org/normal-forms-in-

dbms/

3 5 XML Queries https://www.w3schools.com/xml/xquery_example.asp

Faculty In-charge HOD

 Course File

Document 12.a. Question Bank

Document ID: 2023-24/ RPSIT/IT
Name: