Computer Networking - Syllabus
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-1Overview of E-commerce and its significance in the digital age.
-
E-business vs E-commerce
IN-2Understanding the differences between E-business and E-commerce.
-
Features of E-commerce
IN-3Key characteristics and benefits of E-commerce.
-
Pure vs Partial E-commerce
IN-4Types of E-commerce models and their applications.
-
History of E-commerce
IN-5Evolution and development of E-commerce over time.
-
E-commerce Framework
IN-6Understanding the components of E-commerce framework including People, Public Policy, Marketing and Advertisement, Support Services, and Business Partnerships.
-
Types of E-commerce
IN-7Overview 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-8Common obstacles and difficulties faced in E-commerce.
-
Status of E-commerce in Nepal
IN-9Current state and trends of E-commerce in Nepal.
Key Topics
-
Relational Model Concepts
TH-1This 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-2This 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-3This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.
-
Update Operations and Transactions
TH-4This 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-5This 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-6Defining the structure and constraints of XML documents using XML Schema.
Key Topics
-
Relational Model Concepts
TH-1This 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-2This 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-3This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.
-
Update Operations and Transactions
TH-4This 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-5This 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-6Defining the structure and constraints of XML documents using XML Schema.
-
Simple and Complex Types
TH-7Understanding simple and complex data types in XML Schema.
-
XSD Attributes
TH-8Using attributes in XML Schema to provide additional information.
-
Default and Fixed Values
TH-9Specifying 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-1This 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-2This 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-3This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.
-
Update Operations and Transactions
TH-4This 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-5This 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-6Defining the structure and constraints of XML documents using XML Schema.
Key Topics
-
Relational Model Concepts
TH-1This 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-2This 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-3This 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.