I've been maintaining a database for a metal fabrication shop, but it was started from scratch by someone without enough knowledge to start a database from scratch (myself). As changes are made to the database, small problems spiral out because of the poor foundation of the data model... at this point I would like to start building a new database with a solid data model.
The basic need of the database is to create/track the progress of projects/orders, create/track quotes requested by our customers, and create/track invoices based for finished projects.
The orders are for custom parts (new part# designation), catalog parts (existing part#), or repair service. I have attached a screenshot of the existing relationships/tables. Again, not looking to fix this database, just a new data model that I could modify to fit my purposes and import data from the previous database.