This project presents a comprehensive immigration and security data analysis system using MySQL for backend data management and R for data visualization. The dataset includes visa applications, border entry logs, geospatial risk points, and regional security alerts. Through structured queries, indexed schema, and spatial analytics, the project extracts actionable insights such as visa approval trends, high-risk border zones, and anomalous travel patterns. Visualizations created with ggplot2 enhance interpretability of SQL-derived results. This portfolio project demonstrates advanced SQL, database optimization, and analytical storytelling with R

This version was created by claude

Classification

Øvelse for studenter i faget ING128 på Høgskulen på Vestlandet.