Unanswered: SQL 2008 How to redesign this database (multiple records in one cell)
I'm building small movie database, and I have table which contains informations like "title" "year" "rank", and one of my columns is "genre". I have a table of genres with their ID's, so I can create foreign key, and write genre ID in this column. But here is problem: one movie can match few genres. How can I implement it? So far, I have one solution: write genres in this column, separated by comma. But this solution require to delete foreign key and whole genres table, and store them as plain text, which is making harder building any statistics in future.