I’m new to creating and using databases, so my problem may not seem serious to you. But I’m really stuck.
I have two tables. The data are as follows:
I understand that this relationship is contrary to the relational model, and it should be done through the third table. But I do not understand how to implement it correctly and use it to perform the necessary tasks:
- Each column is unique but filled with non-unique data.
- There are checks between the columns. So if column 1 is not filled at record, in this record it is impossible to fill column 2, etc.
- Each cell of the record in table 1 is colored in the color that is taken from the record in table 2.
I will be grateful for advice and recommendations.
Thanks in advance!