3 Best Practice In PostgerSQL

3 Big Point

1. Each column has only one value

2. All non-key columns must be fully dependent on the primary key, not just partially

3. There should be no transitive dependencies, that is, non-key columns depending on other non-key columns.

Example

create table for save contact

Wrong way

The right way

Practice

Study Case

online shop, Create a table to record orders and goods

The Wrong Way

The Right way

Case Study

Table for mini library

Wrong Way

Right Way

Practice

Why you can't use "order" for a table name in PostgreSQL?

---

It's like having a special key for a specific door. In PostgreSQL, ORDER is a reserved keyword. This means it has a special job—it's used to sort data (like in ORDER BY).

Because it's a reserved word, the database won't let you use it for a table or column name, as it would cause confusion and errors.

To fix this, you just need to pick a different name that isn't already "taken," like orders or purchase_orders.

— GEMINI

END !!!!

SEE YOU NEXT TIME .