The Archive Database

Design, build, load, index and query a database for a collection you care about, meeting all twelve acceptance criteria. There is no step-by-step, because there is not one at work either. Start from the questions you want answered and design backwards from them. When you think it is finished, hand the repository to somebody else and ask them to answer one of your questions using only your schema and README, without asking you anything. Whatever they have to ask is what is missing.