A supermarket chain wants to analyse monthly sales, customer behaviour and product performance. Design a dimensional model identifying fact table(s), dimensions, measures and appropriate schema. Justify your design.

 Illustrate a three-tier data warehouse architecture for a healthcare organization. Explain the role of
data sources, staging area, ETL, metadata repository, warehouse, OLAP server and front-end tools.  

 A university intends to build an enterprise data warehouse by integrating admissions, examinations, finance and LMS databases. Explain the need for a data warehouse, discuss its characteristics, and
justify whether the Inmon or Kimball approach is more suitable. 

Develop a robust, enterprise-grade server-side application using Java Server Pages (JSP) and Java Database Connectivity (JDBC) to manage profile modifications for university students (e.g., IGNOU BCA/MCA Students). The application must implement a unified dynamic lookup interface that accepts either a unique Student Enrollment Number or a registered Mobile Number as an input token. Upon successful verification of the student, the interface must securely expose and permit modifications to the student’s data, specifically communication address, mobile contact number, and verified email etc. You need to explicitly state your database schema definition and connection configuration assumptions before presenting the source code. 
ii. Design and develop a highly secure, multi-layered RESTful or MVC web application implementing full CRUD (Create, Read, Update, Delete) lifecycle workflows using Spring Boot and Hibernate/JPA frameworks. The system will serve as an automated portal for Online Registration and Fee Payment for an industry-level workshop on "Web Technologies". Furthermore, implement rigorous security configurations (such as Spring Security protocols) to enforce Authentication and Role-Based Access Control (RBAC), while ensuring that updates or deletions to registration rows are structurally validated and restricted according to payment settlement status etc. Make necessary assumptions and list them. 

 Draw a Sequence Diagram mapping the chronological(synchronous and asynchronous) object interactions, including conditional exception frames, for an ATM management system.

Draw a State Machine Diagram capturing the execution lifecycle, event triggers, and transactional guard conditions for an Online Re-registration and Fee Payment Subsystem for IGNOU MCA Learners.

Design a secure, decentralized Deployment Diagram representing an Online Banking Infrastructure across multi-tiered hardware execution nodes, protocol wrappers, and security zones.

 Draw a Class Diagram for a distributed, multi-tiered Online Examination System capturing rolebased administrative boundaries and runtime assessment constraints. 

 Using WEKA, apply the Apriori algorithm to a market basket dataset. Experiment with different minimum support and confidence values, and compare the generated association rules.

 Retail Store Transaction with attributes: Transaction ID, Customer ID, Item Purchased, Product Category, Quantity, Day of Purchase, and Payment Mode. You may create a retail file or any in-built retail.arff file can be used.

 Apply the Apriori Association Rule Mining algorithm on the following transactional datasets. You may generate frequent itemsets and association rules by selecting suitable minimum support and confidence values. Also, provide interpretation of the discovered patterns in all following cases:

Student Performance dataset with attributes: Student ID, Attendance Percentage, Internal
Assessment Marks, Assignment Score, Study Hours per Week, and Final Grade.
Assume creating the above files in .csv format and prepare it as .arff file. You may process the files and apply the clustering mechanism using WEKA.

 Customer Purchase dataset with attributes: Customer ID, Age, Gender, Annual Income,
Spending Score, Membership Type, and Number of Purchases.

 Implement the K-Means Clustering algorithm on the following datasets and analyze the generated
clusters. Comment on the suitability of the selected number of clusters.

Create a network of 7 interconnected nodes, and simulate a broadcast packet transmission from one node and observe how packets propagate through the network. Compare the number of transmissions with a manually constructed logical spanning tree, and comment on the reduction in redundant transmissions.

 Construct a topology with two different paths between a source node and a destination node. Assign different delays or bandwidths to the links. Simulate packet transmission and observe which path is selected. Also, modify one link parameter and compare the results.

Design a network of 6 nodes where communication between the source and destination requires at least 3 hops. Configure Point-to-Point links and demonstrate successful packet transmission. Also, measure the end-to-end delay and packet delivery.

Create a network consisting of 4 nodes connected using Point-to-Point links. Configure IP addresses, install the Internet stack, and transmit packets from Node 1 to Node 4. Verify successful communication using the simulation output. Make any further suitable assumptions, wherever necessary.

 Causes of borderline personality disorder

 Treatment of narcissistic personality disorder