The data the client wants to be stored in the database is data related to items on sale, orders made, and customers who make the orders. In this article, I will show you how to design and build a relational database from scratch in Postgres for John’s ecommerce business.
Table of contents
PrerequisitesDesigning the Database Using Quick Database DiagramsConnecting Postgres to DbVisualizerCreating a database on Postgres using DbVisualizerCreating Tables Designed On Quick Database DiagramsImporting Data Table Into Postgres Using DbVisualizerRunning SQL queries on DbVisualizerChanging Chart TypeConclusionAbout the authorSort: