Is it possible to drop some of the information from the site into one table, and some into another that is related to the first one?

Question

SQL

I need to create a small site that will provide the user with the opportunity to fill in the fields, then scatter information from these fields into tables, also fill in the table fields depending on the selection in the scroll on the site, then somehow process the received data and send a response. And if I am familiar with the backend and have an idea of ​​​​how to operate with data from tables in java, then how to put this data into tables from the side of the site is not very good.
I should have an application in which there is data including the address, but for the address there is a separate table in which one of the columns (order_id refers to a similar column in the application) and I need a part of the data filled in by the user on the site to be sent to one table (applications) and the other part into a table with addresses, so that later, by request ID, I can pull it into the main table (inner join), can I do this? and I will be grateful for any advice and help, for example, what will I need for all this and how best to do it, what to look for (any tips on the front)? Thanks in advance

Answer 1

You will need a brain. Try it, if you don't like it, change it. If you hit a dead end - formulate a problem and post it here. They will help you with the problem, but only you can cope with understanding

Answer 2

I'll add Ivan's comment. It is better if you visualize all this in diagrams. Then it will be easier to understand the essence of the issue.