database_design_atlanta_public_transit

This repo contains all files utilized for the final project in CS4400 - Introduction to Database Systems

The Project

Designing a functional relational database in SQL from scratch for a hypothetical Atlanta Public Transportation system (based on real locations and transports). A GUI (graphical user interface) was then created to allow front-end users to interact with the completed database.

This process included:

Selecting data storage types

ER-diagram modeling

Database normalization

SQL creation and querying

GUI design