The construction project DBMS project aims to revolutionize the management of construction projects by proving a comprehensive platform for organizing, tracking, and analyzing project data. It will also centralize project information including budgets, resources as well as streamlining project management processes for enhancing better decision making.

The SQL commands executed are:

Create: DDL command used for creating new objects such as tables, databases, etc.

Update: DML command used to interact with the date itself.

select: command used to display already existing data.

Delete: DML command used to erase data from the database objects such as tables.

Insert: Command used to add data into tables.

JOINS: A table join clause is used to combine rows from 2 or more tables based on a related column between them.