Monday, November 4, 2019

Using PostgreSQL to Create Tool Database

Summer 2019
Creation of a tool database which was able to show data contents, retrievable and filterable by customer, date, account number, product category and product purchase from Excel spreadsheet.

Created entity relationship diagram which featured metadata to be documented onto Excel.

Developed and executed SQL statements (INSERT/SELECT/UPDATE/DELETE) using PostgreSQL.






Lifecycle steps and methodologies were summarized.

No comments:

Post a Comment