Radio_Stations

station_idstation_namefrequency
1Classic Rock96.3
2Top Hits88.7
3Country Gold92.5
4Jazz & Blues100.1
5Electronic Beats99.9

Programs

program_type_idprogram_type_name
1Morning Show
2Afternoon Drive
3Evening News
4Night Music
5Weekend Special

Hosts

host_idhost_namehost_gender
1John DoeM
2Jane SmithF
3Bob JohnsonM
4Alice BrownF
5Tom ClarkM

Radio_Stations_Hosts

radio_station_idhost_id
(→ Radio_Stations.station_id)(→ Hosts.host_id)
11
22
33
44
55

Radio_Stations_Programs

radio_station_idprogram_type_idday_of_weekstart_timeend_time
(→ Radio_Stations.station_id)(→ Programs.program_type_id)
11106:00:0010:00:00
12212:00:0016:00:00
21107:00:0011:00:00
33106:00:0010:00:00
42212:00:0016:00:00
31106:00:0010:00:00
41212:00:0016:00:00
51NoneNoneNone