Building a DB schema that could be used to organize an inventory of mechanical parts. This schema will keep track of all the parts, their manufacturer, category, location in storeroom, available inventory, and other relevant information. A DB like this might be updated and queried by an inventory management application that accepts input from many users who might not be familiar with the DB structure. So there should be sufficient data quality checks to ensure that only valid data can be entered into the DB.
Sandhya80/Build_InventoryDB_postgreSQL
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.