The two ways are possible. The most traditional is to use an extra table and normalize the gender register. This is the way normalized. In general you need to have a good reason to not normalize.
In any of the solutions, the ideal is to have a table with descriptions of the genders. And then you only use the ID
of them. Be in the column of Generos
of your table Videos
, be on the X film binding table genres - the most recommended way.
If you still want to keep a list of genders in the column, you can see a question that I made of how to index this.
You’d probably have the tables:
Videos
Id
Titulo
Duracao
Generous
Id
Descricao
Videosxgeneros
Id
VideoId
GeneroId
Because the downvote?
– Ricardo