broadcasting(Radio) database table design

See more:

SQL

SQL-Server

architecture

, +

Hello,

I Have Basically a Program table and an ADs Table

i need to buled a table that is going to be used as the Playlist (it is for a broadcasting)

that my program going to run an algorathem and buled the playlist for the programs First and then i will have an ADs free time (or time frame) then the program will run again but this time to but the ADs on the Time Frame available based on a specefic criteria

Thanks in Advance
Abdullah Jallad