ColdPenguin
New member
- Local time
- Yesterday, 21:34
- Joined
- Jul 8, 2019
- Messages
- 1
This is my first shot at creating a practice database. Ideally, I wanted each table to only reference one other table, but the Visit table ended up hosting 4 foreign keys.
At the same time, that's kinda useful, because I don't have to add irrelevant tables in order to get to the association between two tables I want to query.
I also haven't figured out what table to connect with the Expense table.
In any case, I'm a noob, and if anyone wants to practice their database analyzation--or just enjoy dominating a noob, haha, come at me.
Had to zip the file, as apparently without 10 posts here you can't attach non-zipped files.
At the same time, that's kinda useful, because I don't have to add irrelevant tables in order to get to the association between two tables I want to query.
I also haven't figured out what table to connect with the Expense table.
In any case, I'm a noob, and if anyone wants to practice their database analyzation--or just enjoy dominating a noob, haha, come at me.
Had to zip the file, as apparently without 10 posts here you can't attach non-zipped files.