SQL Projects

This repository contains a collection of SQL projects that demonstrate various skills and techniques in working with databases. It basically comprises of two different types of projects, one where I have done Database Design and the other I have done Data Analysis Using SQL.

Table of Contents

1. Database Design Projects
2. Data Analysis Projects

Database Design Projects

In all the Database Design Projects, I have included the main .sql file, the .dbml schema file, an .svg of the schema diagram and revelant .png image for the schema. Ihave written all the SQL code in SQLite3. It can however be modified to meet the needs of all other SQL databases.

1. Blue Waters Amusement Park - Management System
   In this project, I have designed a database for an amusement park named Blue Waters in order the manage their ticketing system, ride maintainance, staff, reviews and ratings and several others. It logs all data from riders, staff, maintainance and the timestamps for each corresponding event.

2. Chaptered Emporium Library - Management System
   In this project, I have designed a database system to manage the issuing or borrowing of books from the Chaptered Emporium Library. It manages the login details of the users, their contact details, the details of the books, its publishers, its current revision and so many other aspects.

3. Homestay - Database Management System
   Homestay is an app to make reservations or book a homestay for a specific date. It facilitates on keeping a record of the popular homestays in the area for fast query results. It also loggs the checkin and checkout time and date for the customers, along with the data of the respective owners.

4. E-Challan Ticket - Management System
   E-Challan focusses on automatic ticketing system for traffic violations. Data has been collected for all registered vehicles of the coutry and when a violation is found to be made, a ticket is issued to the respective owners. It logs all the tickets issued for each vehicle.

5. Cargo Delivery - Database Management System
   Cargo Delivery is a logistic company which delivers goods ordered on online retail stores. This database design logs details of every order olaced, its source and destination and also provides current location updates. It also has details on all the routes, hubs, staff and the location of source and destination.

Data Analysis Projects