PostgreSQL Library Registration Database

Customer: AI | Published: 03.11.2025
Бюджет: 750 $

I’m setting up a new member-registration workflow for our library and need a clean PostgreSQL solution. The core requirement is a database that reliably stores each member’s membership type and official start date. While the immediate scope is limited to those two fields, the design should be flexible enough for me to add details such as names or contact numbers later without structural headaches. Here’s what I’d like delivered: • A well-commented PostgreSQL schema (tables, keys, indexes) optimised for quick look-ups and future scalability. • An ER diagram or similar visual aid so staff can understand the structure at a glance. • A short SQL or Python script that inserts sample data and demonstrates basic CRUD operations. • Clear setup instructions covering local installation and a brief note on how to migrate the database to a cloud host if needed. No front-end is required right now; command-line or psql scripting is fine for seeding and testing. I value concise, well-documented code and would appreciate best-practice naming conventions and version control (Git). If you have experience modelling small membership systems or libraries, please mention it along with any relevant portfolio links.