Posts

Image
                                                             Consistency Consistency: Consistency ensures that after every operation the database follows all rules and remains in a valid state. CREATE THE TABLE: CREATE TABLE accounts (     id SERIAL PRIMARY KEY,     name TEXT NOT NULL,     balance INT NOT NULL CHECK (balance >= 0),     last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT THE VALUES: INSERT INTO accounts (name, balance)  VALUES  ('Alice', 1000),  ('Bob', 500); SHOW THE TABLE: SELECT * FROM accounts; Why this query: id SERIAL  - auto increment (1, 2, 3…) name  - user name balance >= 0  -  NO negative money last_updated  - automatically time save  Then we insert the values: Alice - 1000 Bob - 500 This data will be used for te...