A DB schema to organize an inventory of mechanical parts that keep track of all parts, manufacturer, category, location, available inventory, and related infos. This might be updated and queried by an inventory management app that accepts input from users unfamiliar to DB structures. Sufficient data quality checks are needed for valid data entry.

A project implementing a PostgreSQL database that’s suitable for storing data for a data sharing application.