Skip to content

TriGo06/TransportDB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

5 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

The project is structured into multiple thresholds, each building upon the previous to increase complexity and functionality.

File Structure :

./src/

├── init_database.sql # SQL script to initialize the database schema

├── Level_1.sql # SQL file for Threshold 1 functionality

├── Level_2.sql # SQL file for Threshold 2 functionality

├── Level_3.sql # SQL file for Threshold 3 functionality

├── Level_4.sql # SQL file for Threshold 4 functionality

├── Level_5.sql # SQL file for Threshold 5 functionality

Prerequisites : PostgreSQL (Version 12 or later recommended) PL/pgSQL enabled in the database A PostgreSQL user with sufficient permissions to create databases, tables, and functions.

About

This project is a PostgreSQL-based database system designed to manage a public transportation network. It includes features for managing transportation types, fare zones, lines, stations, users, subscriptions, billing, and employees.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors