Need advice on database

Hello,

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:

  1. Each column is unique but filled with non-unique data.
  2. 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.
  3. 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!

Community Page
Last updated: