Current Offerings

22CST253: Database Information System

Semester: IV

Offered: 2026

Unit 1: Introduction to Database and Information Systems: Architecture; Prototyping Methodology; Life Cycle, DB Models; and Current Advances.

Unit 2: Database Modeling using Entity-Relationship Diagram: Notations; Entity and its types; Relation and its types; Degree; Cardinality; Extended ER concepts; Reduction to relational models.

Unit 3: Relational Languages: Relational Model, Formal Query Language, Relational Algebra 👉 ; DDL, DML and DCL👉; Advanced topics of SQL👉; PL/SQL language: Functions, Procedures and Triggers, Views 👉.

Unit 4: Relational Database Design: Functional Dependencies and Normal Forms: 1NF, 2NF, 3NF, BCNF, 4NF,5NF; Transactions and Concurrency control👉; Physical Database Design 👉, File Organization👉, Indexing and Hashing👉

Unit 5: Client/Server Database Architecture and Applications: DB Security, Overview of Distributed DB, Data Warehousing and Data Mining, Data Analytics

Reference/Text Books:

1. Database System Concepts, Silberschatz, A, Korth H F, Sudarshan S, McGraw Hill, 6th Ed.

2. Fundamentals of Database Systems, Elmasri R, Navathe S B, Pearson Education, 7th Ed.

22CSP257: Database Information System Lab

Semester: IV

Offered: 2026

Lab 1: To get familiar with different tools for designing databases and mapping ER diagrams to data models (Introduction to XAMPP and MySQL.)

Lab 2: To get familiar with different tools for designing databases and mapping ER diagrams to data models (Introduction to ER-diagram drawing tool(s) with exercises)

Lab 3: Introduction to DDL commands and queries to create databases.

Lab 4: Introduction to DML commands and queries to create and manipulate databases.

Lab 5: Enforcing integrity constraints (Domain, Key constraints (Primary/Foreign keys), NOT NULL, UNIQUE, DEFAULT, Check).

Lab 6: Implementing different types of functions and operators.

Lab 7: Complex SQL query execution

Lab 8: Demonstrating views, roles and authorization.

Lab 9: Demonstrating triggers.

Lab 10: Demonstrating Cursors.

Mini Project: A mini project is distributed to demonstrate the learning outcome of the database information system course.

22CST391: Computers and Network Security

• Department:     B. Tech.-ECE

• Semester:          VI

• Credit:               3 [3-0-0] (Core)

• Offered:             2026

• Pre-requisite:   Fundamentals of Cryptography, Computer Networks  

22CST391: Topics to be covered (Tentative.)

Unit 1: Introduction: Introduction (a) Security(b) Malware(c) OWASP top ten and other major security issues in the world(d) CVE and other information (e) Introduce various types of security areas

Unit 2: Software and OS Security: OS Security: Common Bugs, Buffer Overflow, Runtime Defenses against memory safety vulnerabilities, program verification and other vulnerabilities, Principles in OS Security; Mechanisms for confining bad code, Mechanisms for confining bad code: isolation, sandboxing, SFI and Virtualization, Trusted Computing

Unit 3: Web Security: Secure web site design (SQL injection, XSS, CSRF)

Unit 4: Network Security: TCP/IP, DDoS Attacks, Network worms and botnets: attacks and defenses, DNS and BGP security, Network defense tools – Firewall and Intrusion Detection.

Evaluation

• 50% End-Term Exam | 30% Mid-Term Exam | 20% Class Performance

Tentative Dates for Quiz and Assignment

• Quiz 1: 

• Quiz 2: 

References:

1. Cryptography and Network Security: Principles & Practice by William Stallings

2. Computer and Security; Principles and Practices by William Stallings and Lawrie Brown

3. Operating System Security by Trent Jaeger (The Pennsylvania State University)

4. Practical Malware Analysis by Andrew Honig, Michael Sikorski