The RDBMS database I built from scratch uses the open-source RDBMS POSTGRES. In addition to the fact that manipulation, input, and queries are done using SQL, the main reason I chose POSTGRES over other SQL-based RDBMS is because of the POSTGIS extension, which allows users to store spatial data. To manage the database, I use the GUI app DBeaver, which is also a popular open-source database administration software with a wide range of features and an interface that is easy and intuitive to use.

The database I developed is designed to store data related to laterite nickel exploration. I divided the data into several tables, which are broadly categorized into exploration plan, drilling activity, assay, and logging tables. To prevent data errors and maintain data integrity, several relationships between tables and restrictions for data entry have been set up.

For ease of data visualization, I have integrated this database with Power BI and Dash (Python). For further analysis, such as generating automatic report summaries and statistical calculations, I have built several scripts utilizing available packages and libraries in Python, such as pandas, geopandas, matplotlib, seaborn, fpdf, and others.