I have a database with 7 tables. I have one ...main table which contains mostly the primary keys from the other tables. BUT, beeing a primary table, meaning that I need to add the data first in that primary table, then I need to read that data from other tables. My question is:
Do I need to make all the keys in the main table as primary keys, then make those keys foreign keys in the other tables, or what would be the best aproach?