Archive Database Step 10: Design It Properly

Design the schema for the archive yourself: books, authors, members, loans, and tags with a proper join table. Write the CREATE TABLE statements with every constraint you can justify, and a one-line comment above each table saying what one row of it represents. If you cannot write that sentence, the table is doing more than one job. Then take the flat loans table from this module and write the queries that would migrate it into your design, including what you would do about the two spellings of Octavia Butler.