title: Removing multi valued data from a table after normalization
body: <p>After going through guides for normalization, I have tables in what I believe are 4th normal form here below. These attributes were decomposed from one large table (student number, club, club cost, nickname etc). The problem is I still have repeating rows in STUDENT_CLUB_LIST and STUDENT_NAMES, and I get an error for repeating the primary key or entering redundant data.</p>
  <p>From tutorials I've seen, repeating the primary key row is allowed even up to 4NF (for example if student number 100 attends two clubs, there would be two rows) so what am I missing? How can I avoid repeating multivalued attributes if I've already decomposed the attributes into small tables with unique keys.</p>
  <pre><code>CREATE TABLE STUDENT_CLUB_LIST(
  
          StudentNumber       Int         NOT NULL,
          Club                Char(25)    NOT NULL,
  
          CONSTRAINT      StudentNumberPK     PRIMARY KEY (StudentNumber)
                              
                          );
                          
  
  CREATE TABLE CLUB_COST(
  
          Club            Char(25)            NOT NULL,
          ClubCost        Int                 NOT NULL,
          
          CONSTRAINT      ClubPK              PRIMARY KEY(Club)
          
                          );
  
  CREATE TABLE STUDENT_NAMES(
  
          StudentNumber       Int         NOT NULL,
          Nickname            Char(25)    NOT NULL,
          
          CONSTRAINT          StudentNamesPK      PRIMARY KEY(StudentNumber)
  );
  </code></pre>