Hey, I have a question about database normalization. I am making a database that stores spending expenses. I have two tables, merchant and receipts. For the receipts table, would I add a foreign key called merchant that links the merchant data to it or no would that violate the normalization rules? I have ID(primary key), date, total price, merchant(foreign key).

Thank you