Question: I have a collection of data like so

```
Programme title |  Episode  |  Subtitle  |  Performers  |  Description

```

Initially I normalised this into two table like so

```
PROGRAMME

progid  |  progtitle  |  description

EPISODE

epid  |  progid  |  episode  |  subtitle  |  description

```

I'm thinking I'd like to represent the performers in another table though, but not sure how to represent it. From what I can tell the following relationships exist

* One to Many: A programme can have many performers
* One to Many: A performer could feature in many programmes

I'm not sure how I would represent this?

**EDIT** Ah I see so I'd actually have tables like this for example?

```
PERFORMER

performerid  |  performer

PROGRAMME

progid  |  progtitle  |  description

EPISODE

epid  |  progid  |  episode  |  subtitle  |  description

PROG_PERFORMER

progid  |  performerid

```

Answer: 
Also, performers can change between episodes
beside performer table you have to create a relation table

performer table

```
performerid | name | ...

```

relation table

```
performerid | progid

```