I design ERD Database for company XYZ. XYZ database was stored in several systems and in different format, which include : accounting software data, supplier databases, point of sales (POS) systems data, and spreadsheets. I firstly review the data in all of these systems and then proceed to design a central database to house all of the data using PostgreSQL. Afterwards, I create database attributes and load them with the data from each sources. Finally, I create a data mart that Company XYZ marketing partners require, export them, and load them into staging databases using PhpMyAdmin and a RDBMS. Tools Used in this project: PostgreSQL, MysQL and PhpMyAdmin