How do you approach designing a CRUD API from scratch when given a set of relational database tables and minimal requirements?