Database Assignment 7 – Final Capstone

πŸ“˜ Description

This capstone assignment concludes the MSDS 420 Database Systems course with a comprehensive project that integrates database modeling, complex queries, and data-driven insights. Leveraging a normalized schema, the solution addresses advanced analytical tasks using SQL, visualizations, and narrative synthesis.

The final module demonstrates the culmination of relational theory and applied SQL knowledge, presenting insights across customer behavior, business strategy, and system optimization. Visualized results provide both technical rigor and stakeholder accessibility.

βΈ»

πŸ”§ Features

  • Normalized Schema Design: Applies multi-table relationships with appropriate keys and referential integrity.
  • Advanced SQL Queries: Joins, aggregations, filters, and subqueries applied to generate actionable insights.
  • Data Visualization: Graphs and tabular outputs used to summarize findings.
  • Narrative Interpretation: Written summaries help translate database output into business value.

βΈ»

πŸ’‘ Key Insight

Effective database systems don’t just store information β€” they transform it into strategic knowledge. This project shows how schema design and query optimization support intelligent business decisions.

πŸ”— View the source code on GitHub