D@tabasics Part 2

I decided I'd have a go at creating another database in Microsoft Access. I wanted to practice setting up relationships and see what would happen. I've also had an idea about how a relief organization might track who is assigned to doing what task, how far along is it, and other questions.

This has led down a rabbit hole with a variety of expansions to the original concept. First of all, where is our organization? Where are we housing volunteers? Where do those volunteers come from?

These questions had to be answered first, and for the first time, I realized that it might help if I wrote down a few notes. It looked something like this:

One vs. Many:
1.) One building has many zones,
one zone has many rooms,
one room has many volunteers.

2.) One organization has many buildings.

3.) One volunteer team has many volunteers.

4.) One building has many staff members...

And so I went on, building tables as I went. Not all of the tables are fully constructed, but there are still some questions that I want answered first.

These relationships helped me construct a series of tables that I felt comfortable with. I then went to the "relationships" display and constructed the joins as I felt they should appear between tables. I do not typically construct relationships because the database workarounds that I use at work have never needed them before. This is interesting practice. There might be more to this appearing in later posts.