I am making a mailing list with PHP and MySQL. I have two questions. Here's the table I have normalized:
Question 1 - How can I enter values in 4 different tables (Client, Product, Department and Area) using a single HTML input form? For example, when I enter data for my client "Andrew" into the client table, related information of Product, Department and Area table should be populated as well through a single SQL INSERT query ? How to achieve that?
Question 2 - Is my normalization ok? I am asking because I have made composite primary key in Product, Department and Area tables, using same foreign key (email). Is this correct?