devamanikantasala/cs50-sql

This repository contains my solutions for the weekly problem sets and the link to the final project for Harvard University's CS50 SQL course. It demonstrates various concepts learned throughout the course, including database design, SQL querying, constraints, views, indexes, and triggers.

1. Cyberchase

2. 36 Views

3. Normals

4. Players

1. "Packages, Please"

2. DESE

3. Moneyball

1. ATL

2. Happy to Connect

3. Union Square Donuts

1. Don't Panic!

2. Meteorite Cleaning

1. Census Tracker

2. The Private Eye

3. Bed and Breakfast

1. In a Snap

2. your harvard

1. "Don't Panic!" (Sentimental) in Python or Java

2. From the Deep

3. Happy to Connect (Sentimental)

The final project involved designing and implementing a database schema for a conceptual local marketplace application.

Key focus areas:

• Designed a relational database schema with appropriate entities and relationships.
• Focused on data integrity using foreign key constraints, and column constraints.
• Optimized query performance with VIEWs, INDEXs, and TRIGGERs.
• Ensured all the relevant data movements are logged for further analysis.

➡️ Find the full project details, schema, queries, ER Diagram, and video presentation in the Final-Project repository. (Make sure to check out the README.md within the Final-Project repository for a detailed explanation!)

By,
Deva Manikanta Sala