2024-25 (EVEN)

22CST253: Database Information System

Semester: IV

Offered: 2024

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: 2024

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.

CST306: Object-Oriented Analysis and Design

Semester: VI

Offered: 2024

Part I:

• Unit 1: Introduction to Object-Oriented Programming Fundamentals

• Unit 2: C++ Programming Basics

• Unit 3: C++ Object-Oriented Concepts

Part II:

Unit 4: Introduction to UML and Object-oriented Design Patterns

1. Object-Oriented Design Using UML: History, Motivation and Basics

2. Object-Oriented Design Using UML: Views and Diagrams

3. Object-Oriented Design Using UML: Dynamic Diagrams

4. Design Patterns: GRASP, GoF

References:

1. C++ How to Program, 10/e by Paul J. Deitel and Harvey M. Deitel.

2. Robert Martin, UML for Java Programmers, Pearson, Ali Bahrami, Object-oriented System Development, TMH, 1999

3. Object-Oriented System Development using UML, Java and Patterns, IIT Kharagpur, Prof. Rajib Mall

4. Design Patterns: Elements of Reusable Object-Oriented Software

5. Practice Books:

   • UML Distilled: A Brief Guide to the Standard Object Modeling Language" by Martin Fowler

   • Learning UML 2.0" by Russ Miles and Kim Hamilton

CSP318: Advanced Programming Lab (AP-OOAD)

Semester: VI

Offered: 2024

Lab 1: To become familiar with C++/java programming language (Function calls).

Lab 2: Understanding Objects, Member Functions and Constructors

Lab 3: Demonstrate the concept of composition by creating classes for different scenarios.

Lab 4: Basic functionalities of C++ 1

Lab 5: Basic functionalities of C++ 2

Lab 6: Implementation of Basic functionalities like templates, stream formatting, file input/output, and exception handling

Lab 7: Interpretation of classes, refactoring, and associated concepts from the OO design perspective.

Lab 8: Introducing state machine diagram concepts and demonstrating their implementation in C++/Java.