concert-management-database-sql

A relational database project designed to manage concerts, artists, venues, ticket sales, and customer bookings using SQL.

Project Overview

This project focuses on designing and implementing a normalized relational database for a concert management system. It supports storing, managing, and analyzing concert-related data such as events, artists, venues, and ticket sales.

The project demonstrates strong skills in:

Database schema design

Data modeling

SQL querying

Analytical reporting

Repository Contents

modified_concerts_schema.sql -- Database schema & table definitions data.sql -- Data insertion scripts code.sql -- Analytical SQL queries REPORT.pdf -- Detailed project explanation

Technologies Used

SQL

MySQL / PostgreSQL (mention the one you used)

Relational Database Design

Key Features

Normalized database schema

Primary & foreign key relationships

Data integrity constraints

Analytical queries for business insights

Structured reporting

Project Report

Detailed documentation is available in REPORT.pdf, including:

ER design explanation

Schema decisions

Query logic

Insights and conclusions

Author

Yuva Narasimha Rao Nambari yuvanarasimharao@gmail.com

LinkedIn: https://linkedin.com/in/yuva-narasimha-rao-nambari

This project was completed as part of a group academic assignment using MySQL.
The repository reflects my contribution and implementation of the database design and SQL queries.