## Radio_Stations

station_id | station_name | frequency
--- | --- | ---
1 | Classic Rock | 96.3
2 | Top Hits | 88.7
3 | Country Gold | 92.5
4 | Jazz & Blues | 100.1
5 | Electronic Beats | 99.9

## Programs

program_type_id | program_type_name
--- | ---
1 | Morning Show
2 | Afternoon Drive
3 | Evening News
4 | Night Music
5 | Weekend Special

## Hosts

host_id | host_name | host_gender
--- | --- | ---
1 | John Doe | M
2 | Jane Smith | F
3 | Bob Johnson | M
4 | Alice Brown | F
5 | Tom Clark | M

## Radio_Stations_Hosts

radio_station_id | host_id
--- | ---
(→ Radio_Stations.station_id) | (→ Hosts.host_id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## Radio_Stations_Programs

radio_station_id | program_type_id | day_of_week | start_time | end_time
--- | --- | --- | --- | ---
(→ Radio_Stations.station_id) | (→ Programs.program_type_id) |  |  |
1 | 1 | 1 | 06:00:00 | 10:00:00
1 | 2 | 2 | 12:00:00 | 16:00:00
2 | 1 | 1 | 07:00:00 | 11:00:00
3 | 3 | 1 | 06:00:00 | 10:00:00
4 | 2 | 2 | 12:00:00 | 16:00:00
3 | 1 | 1 | 06:00:00 | 10:00:00
4 | 1 | 2 | 12:00:00 | 16:00:00
5 | 1 | None | None | None