Given the specifications and business logic, I will create a relational database design to fulfil the needs. This will be suitable for Postgresql or MySQL DBMs. I will try to do it as standard as the problem to solve allows so it would be easy to migrate, use in another DBMs, etc.
As output, you will get a mwb file (mysql workbench file), png (image with the relational diagram) and the DDL script or CREATE script ready to run.
As an extra, I can create several queries/commands for you, including CREATE, ALTER, SELECT, UPDATE, DELETE, DROP, etc. Also, if needed, I can create triggers definitions and functions.
Feel free to ask any question!