Lucid Chart — Graphically Architecting/Creating SQL database for Applications

What is a Lucid Chart?

Who uses Lucid Chart?

Hand-on

Terminology:

Which table we are creating?

Understanding Relationships in the table:

Creating Relationships in the table:

Exporting Table (i.e. ERD diagram):

Creating database and table in PostgreSQL:

CREATE TABLE "customer" (  "customer_id" integer PRIMARY KEY,  "firstname" character varying,  "lastname" character varying,  "street" character varying,  "city" character varying,  "zip" integer,  "phone" integer);CREATE TABLE "order" (  "order_number" integer PRIMARY KEY,  "customer_id" integer,  "customer_name" character varying,  "to_street" character varying,  "product_id" integer,  "to_city" character varying,  "to_state" character varying,  "to_zip" integer,  "ship_date" date);CREATE TABLE "product" (  "product_id" integer PRIMARY KEY,  "quantity" integer,  "product_type" character varying);ALTER TABLE  public.order ADD CONSTRAINT fk_customer
FOREIGN KEY (customer_id)
REFERENCES customer(customer_id);
customer table
order table

NOTE:

Video:

Closing Thoughts:

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store