A project to design a fact and dimension star schema for optimizing queries on a flight booking database using PostgreSQL, a relational database management system. This schema is well-suited for a flight booking database, as it allows for efficient querying of data such as booking dates, flight routes, and passenger information.
sql
etl
modeling
postgresql
dimensions
data-engineering
data-modeling
datawarehouse
fact
star-schema
rdbs
-
Updated
Aug 15, 2021 - PLpgSQL