Create a relational (logical) schema using the following information.

For each ad campaign: a unique AdCampaignID, AdCampaignName, a start date, and a duration of the campaign

For each ad campaign manager: a unique CampaignMgrID and CampaignMgrName

For each ad campaign mode: a unique ModeID, Media, and Range

Each ad campaign is managed by exactly one campaign manager.

Each campaign manager manages at least one ad campaign, but can manage more than one.

Each ad campaign uses at least one campaign mode, but can use more than one.

An ad campaign mode can be used by multiple campaigns, but it does not have to be used by any.