The process of normalizing a database is explained, progressing from the First Normal Form (1NF) to the Third Normal Form (3NF). A physical ERD diagram is included, demonstrating relationships (1-to-1 ...

sqlite3 path/to/database.db -init sqlite-schema-diagram.sql "" > schema.dot dot -Tsvg schema.dot > schema.svg Note: sqlite3 is invoked with the -init option that tells it to read a file at startup, ...