This question already has an answer here:
Creating a database that will be searchable using a company's name and then list all the public owners of the company with their phone numbers. And I was wondering how to structure it. I was thinking of making the company name and ID and then make a new table for every company which would then store the information of every stock owner there. But then I thought about what if the owner owned multiple stocks then they would have duplicates in other tables with other companies so that would take a long time to query.
Can anybody help me structure this database? It's my first time doing this.