SOAVADIA

SOAVADIA is a transport business company that has a database to manage its employees, clients, travels...

The database contains much information such as the Clients' information, the employees of the company, the company's Vehicles, the departure and the destination of the trip, and much more.

Model

This is the database model schema of this project

Prerequisites

• OS Windows (XP or Later), Linux, MacOs
• PostgreSQL

Installation

• Open a command prompt or a PowerShell if you are on Windows, or Terminal if you are on Linux
• Run the command below, and enter the user's password.

psql -U $user

• Once you are logged in, run this command

\i path/soavadia.sql

The "path" is the directory where you put the soavadia.sql file

Log in

• To log into the databasse, once you are logged into the user which contains the soavadia database, connect to the database by running this command

\c soavadia;

Requests

If you have any ideas to improve this database then feel free to ask for changes!