I'm relatively new into designing databases so this is my first project and I'm trying to understand better it's structure.
I need to create a SQLite database where there will be a simple USERS table with personal information such as name, sex, age, etc.
Then, each user will Add as many Dog names they want on a List.
I was considering to use more than 1 table, where every user will have it's own ID and it will be assigned with the other table, however I'm not sure how to do it without leaving the user with a limit of dogs.
How should I design it to support as many dogs as the user wants?