So, I'm building a very basic database that will track inspections done at auctions. There isn't a lot to it, but I'm having a difficult time with the table structure. What I would like to be able to show is:
- Number of inspections per week
- Number of inspections per week, per auction site
- Number of inspections per week, per employee, per auction site
I would like to be able to accomplish this with the least amount of tables and complexity that is possible. To keep it simple and clean.
I've tried building it with an employee table, an auction table and an inspection table between the two (with foreign keys from both employee and auction). I'm still not able to make it work right.