Curated design-related notes into the docs/DESIGN.md document; included ERD diagrams referenced in design discussions; added some API-related development tips to the README