New tables for our WDTU project

First, we create a Playlist Header table (Table number 50002), which will contain one record for each scheduled Radio Show:

Then we will create the associated Playlist Line table (Table number 50003). This table will contain the child records for the Playlist Header table. Each Playlist Line record represents one scheduled piece of music, advertisement, public service announcement, or embedded show within the scheduled Radio Show, as defined in the Playlist Header table. The description for each of the Option fields shows the information that needs to be entered into the OptionString, OptionCaption, and OptionCaptionML properties for those fields.

Now we'll create our Playlist Item Rate table. These rates include both what we charge for ad time and what we must pay in royalties for material we broadcast.

A Ledger table contains the detailed history of processed activity records. In this case, the data is a detailed history of all the Playlist...