How shreyas-ven/postgresql-retail-management-system works
This is a small PostgreSQL retail-management SQL project. Its documented capabilities cover schema normalization, data operations, joins and aggregates, views and indexes, and transactions. The tree and README identify the relevant scripts, but no SQL excerpts were provided, so the graph does not infer dependencies or execution order between them; dashed links indicate the general, unverified use of the scripts with PostgreSQL.
Main entry points: schema.sql Schema and Normalization · insert.sql Insert Data · crud_operations.sql CRUD Operations · joins_queries.sql Join Queries
Components 9
Schema and Data
- Schema and Normalization
schema.sql - Insert Data
insert.sql - CRUD Operations
crud_operations.sql
Queries
- Join Queries
joins_queries.sql - Advanced Queries
advanced_queries.sql
Database Features
- Views and Indexes
views_indexes.sql - Transactions
transactions.sql
Other components
- Database User
- PostgreSQL
Connections 8
- Database User → PostgreSQL: uses via pgAdmin
- Schema and Normalization → PostgreSQL: defines schema
- Insert Data → PostgreSQL: inserts data
- CRUD Operations → PostgreSQL: runs operations
- Join Queries → PostgreSQL: runs joins
- Advanced Queries → PostgreSQL: runs queries
- Views and Indexes → PostgreSQL: defines features
- Transactions → PostgreSQL: runs transactions