College :INDIRA GANDHI NATIONAL COLLEGE ,LADWA

Name of the Assistant / Associate Professor :

Class :B.Sc. /B.A. –VI Sem

Subject Lesson Plan :Computer : RDBMS / COMPUTER NETWORKS

Unit I / Data Models/ Introduction to data communication
Week 1, Day 1, 1/1/2018 Monday / Relational Model Concepts, Codd's Rules for Relational Model
Week 1, Day 2, 2/1/2018 Tuesday / , Hierarchical Data Model– Introduction, Features, Components, Example,
Week 1, Day 3, 3/1/2018 Wednesday / Network Data Model– Introduction, Features, Components, Example,
Week 1, Day 4, 4/1/2018 Thursday / Introduction to Data Communication and Computer Networks;
Week 1, Day 5, 5/1/2018 Friday / Uses of Computer Networks; Types of Computer Networks and their Topologies;
Week 1, Day 6, 6/1/2018 Saturday / Network Hardware Components: Connectors, Transceivers, Repeaters, Hubs,
Week 1, Day 7, 7/1/2018 Sunday / HOLIDAY
UNIT-I / Data Models / Introduction to data communication
Week 2, Day 1, 8/1/2018 Monday / Differences between Hierarchical Data Model and Network Data Model
Week 2, Day 2, 9/1/2018 Tuesday / Comparison of Relational Data Model with Hierarchical Data Model and Network Data Model.
Week 2, Day 3, 10/1/2018 Wednesday / Problems Discussion
Week 2, Day 4, 11/1/2018 Thursday / Network Interface Cards and PC Cards, Bridges, Switches,
Week 2, Day 5, 12/1/2018 Friday / Routers, Gateways;
Week 2, Day 6, 13/1/2018 Saturday / Problems Discussion
Week 2, Day 7, 14/1/2018 Sunday / HOLIDAY
UNIT-I / Data Models / Introduction to data communication
Week 3, Day 1, 15/1/2018 Monday / Relational Algebra:-Selection and Projection
Week 3, Day 2, 16/1/2018 Tuesday / Set Operation,
Week 3, Day 3, 17/1/2018 Wednesday / Join and Division
Week 3, Day 4, 18/1/2018 Thursday / Network Software: Network Design issues and Protocols;
Week 3, Day 5, 19/1/2018 Friday / Connection-Oriented and Connectionless Services;
Week 3, Day 6, 20/1/2018 Saturday / OSI Reference Model;
Week 3, Day 7, 21/1/2018 Sunday / HOLIDAY
Unit I / Data Models / Introduction to data communication
Week 4, Day 1, 22/1/2018 Monday / HOLIDAY: Vasant Panchami
Week 4, Day 2, 23/1/2018 Tuesday / Join and Division examples
Week 4, Day 3, 24/1/2018 Wednesday / HOLIDAY
Week 4, Day 4, 25/1/2018 Thursday / TCP/IP Model;
Week 4, Day 5, 26/1/2018 Friday / HOLIDAY
Week 4, Day 6, 27/1/2018 Saturday / Problems Discussion
Week 4, Day 7, 28/1/2018 Sunday / HOLIDAY
Unit II / Relational Calculus / Analog and Digital Communications
Week 5, Day 1, 29/1/2018 Monday / Tuple Relational Calculus
Week 5, Day 2, 30/1/2018 Tuesday / Domain Relational Calculus.
Week 5, Day 3, 31/1/2018 Wednesday / HOLIDAY GURU RAVIDAS JAYANTI
Week 5, Day 4, 1/2/2018 Thursday / Analog and Digital data and signals;
Week 5, Day 5, 2/2/2018 Friday / Bandwidth and Data Rate, Capacity,
Week 5, Day 6, 3/2/2018 Saturday / Baud Rate; Guided and Wireless
Week 5, Day 7, 4/2/2018 Sunday / HOLIDAY
UNIT-II / Relational Calculus / Analog and Digital Communications
Week 6, Day 1, 5/2/2018 Monday / Functional Dependencies and Normalization -- Purpose Data Redundancy, Update Anomalies,
Week 6, Day 2, 6/2/2018 Tuesday / Partial/Fully Functional Dependencies
Week 6, Day 3, 7/2/2018 Wednesday / , Transitive Functional Dependencies
Week 6, Day 4, 8/2/2018 Thursday / Transmission Media
Week 6, Day 5, 9/2/2018 Friday / Communication Satellites
Week 6, Day 6, 10/2/2018 Saturday / HOLIDAY
Week 6, Day 7, 11/2/2018 Sunday / HOLIDAY
UNIT-II / Relational Calculus / Analog and Digital Communications
Week 7, Day 1, 12/2/2018 Monday / , Characteristics of Functional Dependencies, Decomposition and Normal Forms1NF, 2NF
Week 7, Day 2, 13/2/2018 Tuesday / HOLIDAY .
Week 7, Day 3, 14/2/2018 Wednesday / Normal Forms3NF & BCNF
Week 7, Day 4, 15/2/2018 Thursday / Switching and Multiplexing;
Week 7, Day 5, 16/2/2018 Friday / Modems and modulation techniques
Week 7, Day 6, 17/2/2018 Saturday / Modems and modulation techniques
Week 7, Day 7, 18/2/2018 Sunday / HOLIDAY
Unit II / Relational Calculus / Analog and Digital Communications
Week 8, Day 1, 19/2/2018 Monday / Examples of Normal Forms
Week 8, Day 2, 20/2/2018 Tuesday / Examples Discussion of normal Forms
Week 8, Day 3, 21/2/2018 Wednesday / Class Test
Week 8, Day 4, 22/2/2018 Thursday / Class test
Week 8, Day 5, 23/2/2018 Friday / Data Link Layer Design issues
Week 8, Day 6, 24/2/2018 Saturday / Error Detection and Correction methods Sliding Window Protocols:
Week 8, Day 7, 25/2/2018 Sunday / HOLIDAY
UNIT-III / SQL: / Data Link Layer
Week 9, Day 1, 26/2/2018 Monday / Data Definition and data types,
Week 9, Day 2, 27/2/2018 Tuesday / Create Table
Week 9, Day 3, 28/2/2018 Wednesday / HOLIDAY
Week 9, Day 4, 1/3/2018 Thursday / HOLIDAY
Week 9, Day 5, 2/3/2018 Friday / HOLIDAY
Week 9, Day 6, 3/3/2018 Saturday / HOLIDAY
Week 9, Day 7, 4/3/2018 Sunday / HOLIDAY
UNIT-III / SQL: / Data Link Layer
Week 10, Day 1, 5/3/2018 Monday / CREATE TABLE examples
Week 10, Day 2, 6/3/2018 Tuesday / Insert Data,Viewing Data
Week 10, Day 3, 7/3/2018 Wednesday / Insert Data,Viewing Data examples
Week 10, Day 4, 8/3/2018 Thursday / One-bit, Go Back N and Selective Repeat;
Week 10, Day 5, 9/3/2018 Friday / Media Access Control: ALOHA, Slotted ALOHA
Week 10, Day 6, 10/3/2018 Saturday / Problems Discussion
Week 10, Day 7, 11/3/2018 Sunday / HOLIDAY
UNIT-III / SQL: / Data Link Layer
Week 11, Day 1, 12/3/2018 Monday / Filtering Table Data, Sorting data
Week 11, Day 2, 13/3/2018 Tuesday / Creating Table from a Table
Week 11, Day 3, 14/3/2018 Wednesday / Problems Discussion
Week 11, Day 4, 15/3/2018 Thursday / CSMA, Collision free protocols;
Week 11, Day 5, 16/3/2018 Friday / Introduction to LAN technologies Ethernet, Switched Ethernet,
Week 11, Day 6, 17/3/2018 Saturday / Fast Ethernet, Gigabit Ethernet; Token Ring
Week 11, Day 7, 18/3/2018 Sunday / HOLIDAY
Unit III / SQL: / Data Link Layer
Week 12, Day 1, 19/3/2018 Monday / Destroy table, Update, View , Delete, Join, Concatenating data from Table
Week 12, Day 2, 20/3/2018 Tuesday / Specifying Constraints in SQL Primary Key, Foreign Key, Unique Key, Check Constraint, Using Functions
Week 12, Day 3, 21/3/2018 Wednesday / Problems Discussion
Week 12, Day 4, 22/3/2018 Thursday / Introduction to Wireless LANs and Bluetooth;
Week 12, Day 5, 23/3/2018 Friday / HOLIDAY
Week 12, Day 6, 24/3/2018 Saturday / Problems discussion
Week 12, Day 7, 25/3/2018 Sunday / HOLIDAY
Unit IV / PL/SQL / routing Algorithms
Week 13, Day 1, 26/3/2018 Monday / PL/SQL-Introduction, Advantages of PL/SQL
Week 13, Day 2, 27/3/2018 Tuesday / The Generic PL/SQL Block:,
Week 13, Day 3, 28/3/2018 Wednesday / PL/SQL Execution Environment; PL/SQL Character Set
Week 13, Day 4, 29/3/2018 Thursday / HOLIDAY
Week 13, Day 5, 30/3/2018 Friday / Routing Algorithms: Flooding, Shortest Path Routing
Week 13, Day 6, 31/3/2018 Saturday / Distance Vector Routing; Link State Routing
Week 13, Day 7, 1/4/2018 Sunday / HOLIDAY
UNIT-IV / PL/SQL / routing Algorithms
Week 14, Day 1, 2/4/2018 Monday / PL/SQL Data Types Declaration Assignment of Variables
Week 14, Day 2, 3/4/2018 Tuesday / Control Structure in PL/SQL: Conditional Control,
Week 14, Day 3, 4/4/2018 Wednesday / Programming Examples
Week 14, Day 4, 5/4/2018 Thursday / Hierarchical Routing; Congestion Control
Week 14, Day 5, 6/4/2018 Friday / Traffic shaping; Choke packets; Load shedding;
Week 14, Day 6, 7/4/2018 Saturday / Problems Discussion
Week 14, Day 7, 8/4/2018 Sunday / HOLIDAY
UNIT-IV / PL/SQL / routing Algorithms
Week 15, Day 1, 9/4/2018 Monday / Iterative Control
Week 15, Day 2, 10/4/2018 Tuesday / Iterative Control Examples
Week 15, Day 3, 11/4/2018 Wednesday / Problem Discussion
Week 15, Day 4, 12/4/2018 Thursday / Application Layer: Introduction to DNS, E-Mail and WWW services
Week 15, Day 5, 13/4/2018 Friday / Network Security Issues:
Week 15, Day 6, 14/4/2018 Saturday / HOLIDAY
Week 15, Day 7, 15/4/2018 Sunday / HOLIDAY
Unit IV / PL/SQL / routing Algorithms
Week 16, Day 1, 16/4/2018 Monday / Sequential Control
Week 16, Day 2, 17/4/2018 Tuesday / Sequential Control Examples
Week 16, Day 3, 18/4/2018 Wednesday / HOLIDAY
Week 16, Day 4, 19/4/2018 Thursday / Security attacks;
Week 16, Day 5, 20/4/2018 Friday / Encryption methods
Week 16, Day 6, 21/4/2018 Saturday / Encryption methods
Week 16, Day 7, 22/4/2018 Sunday / HOLIDAY
Unit IV / PL/SQL / routing Algorithms
Week 17, Day 1, 23/4/2018 Monday / Revision
Week 17, Day 2, 24/4/2018 Tuesday / Revision
Week 17, Day 3, 25/4/2018 Wednesday / Revision
Week 17, Day 4, 26/4/2018 Thursday / Firewalls; Digital Signatures
Week 17, Day 5, 27/4/2018 Friday / Revision
Week 17, Day 6, 28/4/2018 Saturday
Week 17, Day 7, 29/4/2018 Sunday / HOLIDAY
REVISION / REVISION
Week 18, Day 1, 30/4/2018 Monday / Revision

Page 1 of 5