Create a database schema

Without requirements or design, programming is the art of adding bugs to an empty text file. – Louis Srygley

So, this is what I came up with:

I make no claims to being a database designer. I know just enough to be dangerous. I did, however, make an effort to get

• Identifying and non-identifying relationships correct.
• Include foreign key constraints

The design is centered around a massive PIVOT table. Some people would suggest, because it contains extra fields, that it should be just a normal table.