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 |