Computer Networking - Syllabus

Course Overview and Structure

Embark on a profound academic exploration as you delve into the Computer Networking course () within the distinguished Tribhuvan university's BCA department. Aligned with the BCA Curriculum, this course (CACS303) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 60+20+20 marks system, coupled with a challenging passing threshold of , propels students to strive for excellence, fostering a deeper grasp of the course content.

This 3 credit-hour journey unfolds as a holistic learning experience, bridging theory and application. Beyond theoretical comprehension, students actively engage in practical sessions, acquiring valuable skills for real-world scenarios. Immerse yourself in this well-structured course, where each element, from the course description to interactive sessions, is meticulously crafted to shape a well-rounded and insightful academic experience.


Course Description

This course offers detailed concept and structure of networking standards and principles. It includes introduction, functioning and significance of Physical Layer, Data Link Layer, Network Layer, Transport Layer, Application layer and some security mechanisms. It does not entirely focus on theoretical concept but also strongly focuses on practical skill based learning.

Course objectives 

The general objectives of this course are to provide theoretical as well as practical knowledge of computer networking to make students capable of implementing, managing and troubleshooting the issues of computer network in their personal as well professional life.

Units

Key Topics

  • Introduction to E-commerce
    IN-1

    Overview of E-commerce and its significance in the digital age.

  • E-business vs E-commerce
    IN-2

    Understanding the differences between E-business and E-commerce.

  • Features of E-commerce
    IN-3

    Key characteristics and benefits of E-commerce.

  • Pure vs Partial E-commerce
    IN-4

    Types of E-commerce models and their applications.

  • History of E-commerce
    IN-5

    Evolution and development of E-commerce over time.

  • E-commerce Framework
    IN-6

    Understanding the components of E-commerce framework including People, Public Policy, Marketing and Advertisement, Support Services, and Business Partnerships.

  • Types of E-commerce
    IN-7

    Overview of different types of E-commerce including B2C, B2B, C2B, C2C, M-Commerce, U-commerce, Social-Ecommerce, and Local E-commerce.

  • Challenges in E-commerce
    IN-8

    Common obstacles and difficulties faced in E-commerce.

  • Status of E-commerce in Nepal
    IN-9

    Current state and trends of E-commerce in Nepal.

Key Topics

  • Relational Model Concepts
    TH-1

    This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

  • Relational Model Constraints
    TH-2

    This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

  • Relational Database Schemas
    TH-3

    This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

  • Update Operations and Transactions
    TH-4

    This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

  • Basic Relational Algebra Operations
    TH-5

    This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

  • XML Schema
    TH-6

    Defining the structure and constraints of XML documents using XML Schema.

Key Topics

  • Relational Model Concepts
    TH-1

    This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

  • Relational Model Constraints
    TH-2

    This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

  • Relational Database Schemas
    TH-3

    This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

  • Update Operations and Transactions
    TH-4

    This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

  • Basic Relational Algebra Operations
    TH-5

    This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

  • XML Schema
    TH-6

    Defining the structure and constraints of XML documents using XML Schema.

  • Simple and Complex Types
    TH-7

    Understanding simple and complex data types in XML Schema.

  • XSD Attributes
    TH-8

    Using attributes in XML Schema to provide additional information.

  • Default and Fixed Values
    TH-9

    Specifying default and fixed values for elements and attributes in XML Schema.

4.1 Functions of Network Layer

4.2 Virtual Circuits and Datagram Subnets

4.3 IPv4 Address: Addresses: Address Space, Notations, Classful addressng, Classless addressing, Subnetting and Network Address Translation (NAT)

4.4 IPv4 Datagram format and fragmentation

4.5 IPv6 Address Structure and advantages over IPv4

4.6 Routing Algorithms: Distance Vector Routing, Link State Routing

4.7 Internet Control Protocols: ARP, RARP,ICMP

4.8 Routing protocols: OSPF, BGP, UNicast, Multicast and Broadcast

Key Topics

  • Relational Model Concepts
    TH-1

    This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

  • Relational Model Constraints
    TH-2

    This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

  • Relational Database Schemas
    TH-3

    This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

  • Update Operations and Transactions
    TH-4

    This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

  • Basic Relational Algebra Operations
    TH-5

    This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

  • XML Schema
    TH-6

    Defining the structure and constraints of XML documents using XML Schema.

Key Topics

  • Relational Model Concepts
    TH-1

    This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

  • Relational Model Constraints
    TH-2

    This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

  • Relational Database Schemas
    TH-3

    This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

7.1 A Model for Network Security

7.2 Principles of cryptography: Symmetric Key and Public Key 

7.3 Public Key Algorithm — RSA

7.4 Digital Signature Algorithm

7.5 Communication Security: IPSec, VPN, Firewalls, Wireless Security.

4.1 Functions of Network Layer

4.2 Virtual circuits and Datagram Subnets

4.3 IPv4 Addresses: Address Space, Notations, Classful addressing, Classless addressing, Subnetting and Network Address Translation(NAT)

4.4 IPv4 Datagram format and fragmentation

4.5 lPv6 Address Structure and advantages over IPv4

4.6 Routing Algorithms: Distance Vector Routing, Link State Routing 

4.7 Internet Control Protocols: ARP, RARP, ICMP

4.8 Routing protocols: OSPF, BGP, Unicast, Multicast and Broadcast

Lab works

 Practical

1. Prepare hardware and software specification for basic computer system.

2. Determine the appropriate placement of networking devices on a network.

3. Identify networking cable standards. Create and test cross — over and straight cables.

4. Configure the IP address of the computer.

5.Create a basic network and share file and folders.

6. Install and configure windows server: Active Directory, User and Group Policy Management.

7. Set the file access permissions and quota in windows server.

8. Configure basic DNS and DHCP services in windows server.

9. Install Linux based OS and practice on basic Linux and networking commands.

10. Configure IP address and subnet in Linux Machine.

11. Install packet tracer and identify the features of packet tracer.

12. Implement the LAN topologies.

13. Demonstrate the use of VLAN.

14. Implement the both static and dynamic router configurations.

15. Install and configure DNS, DHCP, FTP and Web Servers in Linux machine.

16. Capture some packets and analyze the header using Wireshark.

17. Implement the firewall.