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.
-
Notifications
You must be signed in to change notification settings - Fork 0
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.
Sandhya80/Build_InventoryDB_postgreSQL
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
About
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.
Topics
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published