I'm creating a Data Model, and I'm trying to get it to 3NF.
I keep reasoning myself into a circular model, and I don't want that.
That being said, I was hoping to get some other opinions.
THe attached data model completes the list of data facts I require.
I'm having issues setting the relationships.
Here's the facts I know:
1. There are multiple locations
2. Each location has 1 or more dates
3. Each Location has 1 or more spaces
4. Each space requires a reservation
5. Each reservation is a space per date per location
Each table has the dataparts I require to move forward.
Any recommendations on how to make this data model fit better would be greatly appreciated.