Zuber - Cab booking DMBS framework

A cab booking application DBMS framework featuring OLAP queries, triggers, transactions, a comprehensive schema, over 50 queries, and a populated dummy database. It includes a CLI user interface for interacting with the database.

Quick Start

git clone https://github.com/hyouteki/Zuber

SOURCE /path/to/Zuber/repository/zuber-schema.sql
SOURCE /path/to/Zuber/repository/zuber-data.sql
SOURCE /path/to/Zuber/repository/zuber-queries.sql
SOURCE /path/to/Zuber/repository/zuber-triggers.sql
SOURCE /path/to/Zuber/repository/zuber-olap.sql

this.__databaseInstance = mysql.connector.connect(
    host="localhost",
    user="root",
    password="mysql1234",
    database="zuber"
)

Replace host, user & password @ with your mysql credentials.

cd Zuber/CLI
pip install termcolor tabulate
python zuber_client.py
python zuber_admin.py

Contents

• Requirement document
• ER model & relational schema
• Database schema & population
  • Database schema
  • Database population/sample data
• Queries & relational algebra
  • Relational algebra
  • Sample queries
  • Query explanation
• OLAP queries and triggers
  • OLAP queries
  • Triggers
• Transactions
  • Transactions
  • Transaction explaination
• Zuber CLI
• User guide

Go to top File an issue